migra

Like diff but for PostgreSQL schemas (by djrobstep)

Migra Alternatives

Similar projects and alternatives to migra

  1. Hasura

    233 migra VS Hasura

    Blazing fast, instant realtime GraphQL APIs on all your data with fine grained access control, also trigger webhooks on database events.

  2. Nutrient

    Nutrient – The #1 PDF SDK Library, trusted by 10K+ developers. Other PDF SDKs promise a lot - then break. Laggy scrolling, poor mobile UX, tons of bugs, and lack of support cost you endless frustrations. Nutrient’s SDK handles billion-page workloads - so you don’t have to debug PDFs. Used by ~1 billion end users in more than 150 different countries.

    Nutrient logo
  3. alnoda-workspaces

    172 migra VS alnoda-workspaces

    :fireworks: Flexible and extendable containerized workspaces. Now. with free offline chat GPT!!! 🚀🚀🚀

  4. sqlc

    179 migra VS sqlc

    Generate type-safe code from SQL

  5. ent

    146 migra VS ent

    An entity framework for Go

  6. dolt

    96 migra VS dolt

    Dolt – Git for Data

  7. atlas

    73 migra VS atlas

    Manage your database schema as code (by ariga)

  8. graphjin

    GraphJin - Build NodeJS / GO APIs in 5 minutes not weeks

  9. CodeRabbit

    CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

    CodeRabbit logo
  10. realtime

    59 migra VS realtime

    Broadcast, Presence, and Postgres Changes via WebSockets

  11. liquibase

    56 migra VS liquibase

    Main Liquibase Source

  12. dbmate

    28 migra VS dbmate

    🚀 A lightweight, framework-agnostic database migration tool.

  13. reshape

    18 migra VS reshape

    An easy-to-use, zero-downtime schema migration tool for Postgres

  14. pgroll

    21 migra VS pgroll

    PostgreSQL zero-downtime migrations made easy

  15. awesome-db-tools

    Everything that makes working with databases easier

  16. sqldef

    9 migra VS sqldef

    Idempotent schema management for MySQL, PostgreSQL, and more

  17. tusker

    9 migra VS tusker

    PostgreSQL migration management tool

  18. prisma-engines

    🚂 Engine components of Prisma ORM

  19. pggen

    Generate type-safe Go for any Postgres query. If Postgres can run the query, pggen can generate code for it.

  20. postgres_migrator

    A postgres migration generator and runner that uses raw declarative sql.

  21. bytebase

    41 migra VS bytebase

    World's most advanced database DevSecOps solution for Developer, Security, DBA and Platform Engineering teams. The GitHub/GitLab for database DevSecOps.

  22. refinery

    6 migra VS refinery

    Powerful SQL migration toolkit for Rust. (by rust-db)

  23. SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better migra alternative or higher similarity.

migra discussion

Log in or Post with

migra reviews and mentions

Posts with mentions or reviews of migra. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-10-03.
  • Pgroll: zero-downtime, undoable, schema migrations for Postgres
    15 projects | news.ycombinator.com | 3 Oct 2023
    Forr postgres, how does the schema diffing aspect compare to migra?

    https://github.com/djrobstep/migra

    I'm asking because, although migra is excellent and there are multiple migrations tools based on it (at least https://github.com/bikeshedder/tusker and https://github.com/blainehansen/postgres_migrator), issues are piling up but development seem to be slowing down

  • Supabase Local Dev: migrations, branching, and observability
    8 projects | dev.to | 8 Aug 2023
    We’ve extended the CLI migration feature and added Dashboard support. Database migrations give you a way to update your database using version-controlled SQL files. We’ve built a lot of tooling around our migrations, including reparation, migration cleanup using the squash command, and diffing (using migra) to generate a new migration or to detect schema drift.
  • How do you handle schema migrations?
    2 projects | /r/Database | 9 Jun 2023
  • Tool for generating automatic migrations/schema diff
    3 projects | /r/PostgreSQL | 7 Jun 2023
    I've had a lot of success with: https://github.com/djrobstep/migra
  • Diesel 2.1
    5 projects | /r/rust | 26 May 2023
    Is this similar to migra? There's a tool written in Rust that calls it, postgres_migrator (there's also tusker)
  • Prisma laying off 28% staff
    5 projects | news.ycombinator.com | 22 Jan 2023
    If you wish to auto-generate migrations, there are declarative schema change tools available for most relational databases. I'm the creator of Skeema [1] which provides them for MySQL, but there are options for other DBs too [2][3][4].

    Prisma's migration system actually partially copied Skeema's design, while giving credit in a rather odd fashion which really rubbed me the wrong way: "The workflow of working with temporary databases and introspecting it to determine differences between schemas seems to be pretty common, this is for example what skeema does." [5]

    While I doubt I was the first person to ever use that technique, I absolutely didn't copy it from anywhere, and it was never "pretty common". I'm not aware of any other older schema change systems that work this way.

    [1] https://www.skeema.io

    [2] https://github.com/djrobstep/migra

    [3] https://github.com/k0kubun/sqldef

    [4] https://david.rothlis.net/declarative-schema-migration-for-s...

    [5] https://github.com/prisma/prisma-engines/blob/6be410e/migrat...

  • Ask HN: ORM or Native SQL?
    10 projects | news.ycombinator.com | 6 Jan 2023
    The best solution I've ever seen is this Rust library https://github.com/cornucopia-rs/cornucopia

    You write plain SQL for you schema (just a schema.sql is enough) and plain SQL functions for your queries. Then it generates Rust types and Rust functions from from that. If you don't use Rust, maybe there's a library like that for your favorite language.

    Optionally, pair it with https://github.com/bikeshedder/tusker or https://github.com/blainehansen/postgres_migrator (both are based off https://github.com/djrobstep/migra) to generate migrations by diffing your schema.sql files, and https://github.com/rust-db/refinery to perform those migrations.

    Now, if you have simple crud needs, you should probably use https://postgrest.org/en/stable/ and not an ORM. There are packages like https://www.npmjs.com/package/@supabase/postgrest-js (for JS / typescript) and probably for other languages too.

    If you insist on an ORM, the best of the bunch is prisma https://www.prisma.io/ - outside of the typescript/javascript ecosystem it has ports for some other languages (with varying degrees of completion), the one I know about is the Rust one https://prisma.brendonovich.dev/introduction

  • I greatly dislike ORMs, but I find myself wanting ORM agnostic SQL migration tools. What do you use to perform RDBMS table migrations outside of an ORM?
    3 projects | /r/ExperiencedDevs | 8 Nov 2022
    I really liked the idea proposed in https://github.com/djrobstep/migra but haven’t used it yet.
  • How to sustainably developer SQL database code (schemas, functions, ...)?
    1 project | /r/AskProgrammers | 19 Aug 2022
    I'd love to be able to be able to declaratively make changes directly in the table create commands instead of manually creating new migration scripts every time. I've found migra (we use PostgreSQL) and it seems to be exactly what I'm looking for. I'm curious about other people's experience and why things like Migra are the norm.
  • Schema diffing tool?
    1 project | /r/PostgreSQL | 19 Aug 2022
    Migra should do it https://databaseci.com/docs/migra
  • A note from our sponsor - Nutrient
    www.nutrient.io | 12 Feb 2025
    Other PDF SDKs promise a lot - then break. Laggy scrolling, poor mobile UX, tons of bugs, and lack of support cost you endless frustrations. Nutrient’s SDK handles billion-page workloads - so you don’t have to debug PDFs. Used by ~1 billion end users in more than 150 different countries. Learn more →

Stats

Basic migra repo stats
25
2,935
0.0
9 months ago

djrobstep/migra is an open source project licensed under The Unlicense which is an OSI approved license.

The primary programming language of migra is Python.


Sponsored
Nutrient – The #1 PDF SDK Library, trusted by 10K+ developers
Other PDF SDKs promise a lot - then break. Laggy scrolling, poor mobile UX, tons of bugs, and lack of support cost you endless frustrations. Nutrient’s SDK handles billion-page workloads - so you don’t have to debug PDFs. Used by ~1 billion end users in more than 150 different countries.
www.nutrient.io

Did you know that Python is
the 2nd most popular programming language
based on number of references?