Hacker GitHub

← All repos

djrobstep/migra

View on GitHub ↗ ★ 3,048 Python

DEPRECATED: Like diff but for PostgreSQL schemas

29 mentions on Hacker News by 17 people: 6 stories, 23 comments · first 2017-03-01 · latest 2026-07-15

Mentions per year 29 mentions · busiest year 2019 (8)
20082026
AllStoriesComments NewestTopOldest
  1. See also: https://github.com/djrobstep/migra
    comment by gavinray · 2026-02-05 · in Sqldef: Idempotent schema management tool for MySQL, PostgreSQL, SQLite
  2. Reminds me of Migra: https://github.com/djrobstep/migra
    comment by ForHackernews · 2026-02-05 · in Sqldef: Idempotent schema management tool for MySQL, PostgreSQL, SQLite
  3. Hey, are you using some tool like the unmaintained migra https://github.com/djrobstep/migra (perhaps using this tool https://github.com/blainehansen/postgres_migrator ) or pg-schema-diff https://github.com/stripe/pg-schema-diff or maybe…
    comment by nextaccountic · 2025-04-04 · in Declarative Schemas for simpler database management
  4. …[6]. [1] https://github.com/stripe/pg-schema-diff [2] https://github.com/bikeshedder/tusker [3] https://github.com/djrobstep/migra [4] https://github.com/sqldef/sqldef/ [5] https://david.rothlis.net/declarative-schema-migration-for-s...…
    comment by evanelias · 2025-04-03 · in Declarative Schemas for simpler database management
  5. 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…
    comment by nextaccountic · 2023-10-03 · in Pgroll: zero-downtime, reversible schema migrations for Postgres
  6. …R&D and doesn't even give credit in a respectful manner! [1] https://github.com/skeema/skeema [2] https://github.com/djrobstep/migra [3] https://github.com/k0kubun/sqldef [4] https://david.rothlis.net/declarative-schema-migration-for-s...…
    comment by evanelias · 2023-01-22 · in Prisma laying off 28% staff
  7. …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 migrati
    comment by nextaccountic · 2023-01-06 · in Ask HN: ORM or Native SQL?
  8. …a diff between the current and desired schema for your database, for instance Migra for Postgres ( https://github.com/djrobstep/migra ).
    comment by dkdbejwi383 · 2022-10-17 · in Yagni Exceptions (2021)
  9. …mention this use case but it does look like you can pass specific schema(s) or exclude them: https://github.com/djrobstep/migra/blob/master/migra/migra.p... It looks like the schema do have to have the same name between the databases,…
    comment by michelpp · 2022-05-04 · in Sqldiff: SQLite Database Difference Utility
  10. …omission is column-level grants though - as far as I know changes to those aren’t detected [1] https://github.com/djrobstep/migra
    comment by gregplaysguitar · 2022-05-04 · in Sqldiff: SQLite Database Difference Utility
  11. https://atlasgo.io/ or https://github.com/djrobstep/migra
    comment by rockwotj · 2022-02-25 · in PostgreSQL Schema Change Guide
  12. …in this space are sqldef ( https://github.com/k0kubun/sqldef , for MySQL or Postgres) and migra ( https://github.com/djrobstep/migra , for Postgres). In MS SQL Server, SSDT DACPACs are also somewhat similar.
    comment by evanelias · 2022-01-13 · in Treating SQL like code
  13. At the moment I use https://github.com/djrobstep/migra to make PostgreSQL diff.
    comment by stephane-klein · 2020-08-06 · in Launch HN: Datafold (YC S20) – Diff Tool for SQL Databases
  14. …author of one, https://github.com/skeema/skeema , for MySQL and MariaDB. Or for Postgres check out https://github.com/djrobstep/migra .
    comment by evanelias · 2020-01-13 · in Catching SQL errors at build time
  15. Or something a bit more high-level like Migra? https://github.com/djrobstep/migra
    comment by fanf2 · 2019-12-06 · in Get PostgreSQL Database Structure as a Detailed JavaScript Object
  16. …need to do a "diff" between your current "CREATE" and the on in the system where you are deploying. https://github.com/djrobstep/migra Also something similar which uses apgdiff https://github.com/subzerocloud/subzero-cli
    comment by ruslan_talpa · 2019-11-08 · in Modern Data Practice and the SQL Tradition
  17. …[2] https://www.skeema.io/blog/2019/01/18/declarative/ [3] https://github.com/k0kubun/sqldef/ [4] https://github.com/djrobstep/migra
    comment by evanelias · 2019-10-31 · in Ask HN: How do you organize and manage database migrations?
  18. …I understand, in the SQL Server world there are a number of others. [1] https://www.skeema.io [2] https://github.com/djrobstep/migra [3] https://github.com/k0kubun/sqldef/
    comment by evanelias · 2019-09-04 · in ORMs Are Backwards
  19. …So I think/hope it's just a matter of time before this concept becomes more widely known. [1] https://github.com/djrobstep/migra [2] https://github.com/k0kubun/sqldef/
    comment by evanelias · 2019-05-10 · in Ask HN: How does your development team handle database migrations?
  20. This was discussed here recently: https://github.com/djrobstep/migra I haven't used it, but it fits your request of a postgresql specific migration tool where you don't have to futz with manually writing migration scripts.
    comment by kronin · 2019-04-27 · in PostgreSQL Features to Try
  21. …knows how to run the correct DDL to reach that new state. [1] https://github.com/skeema/skeema [2] https://github.com/djrobstep/migra [3] https://github.com/k0kubun/sqldef [4] https://www.skeema.io/blog/2019/01/18/declarative/
    comment by evanelias · 2019-01-23 · in Why We Chose Rails to Build Gitlab
  22. …changes using a declarative approach for over 8 years now. [1] https://github.com/skeema/skeema [2] https://github.com/djrobstep/migra [3] https://github.com/k0kubun/sqldef
    comment by evanelias · 2019-01-07 · in SQL Is No Excuse to Avoid DevOps
  23. …PostgresOpen 2017, and have written a schema diff tool for Postgres that supports this approach ( https://github.com/djrobstep/migra ). I'd be curious to know if this is what you are getting at, and if it would solve your problem?
    comment by djrobstep · 2017-09-13 · in Better Database Migrations in Postgres