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. ▲ 3
    Show HN: Pgmig: Generate migrations between Postgres databases
    story by McAvey · 2026-07-15 · 0 comments
  2. See also: https://github.com/djrobstep/migra
    comment by gavinray · 2026-02-05 · in Sqldef: Idempotent schema management tool for MySQL, PostgreSQL, SQLite
  3. 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
  4. 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
  5. …[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
  6. 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
  7. …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
  8. …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?
  9. …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)
  10. …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
  11. …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
  12. ▲ 136
    Migra: Diff for PostgreSQL schemas
    story by thunderbong · 2022-02-25 · 21 comments
  13. https://atlasgo.io/ or https://github.com/djrobstep/migra
    comment by rockwotj · 2022-02-25 · in PostgreSQL Schema Change Guide
  14. …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
  15. ▲ 1
    Migra: Like Diff but for Postgres Schemas
    story by Jarwain · 2021-04-08 · 0 comments
  16. 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
  17. …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
  18. 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
  19. …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
  20. …[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?
  21. …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
  22. …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?
  23. 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
  24. …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
  25. …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
  26. ▲ 177
    Migra – A schema diff tool for PostgreSQL
    story by networked · 2018-03-25 · 29 comments
  27. ▲ 1
    Migra: like diff for PostgreSQL schemas; migrations made almost painless
    story by fanf2 · 2017-09-14 · 1 comment
  28. …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
  29. ▲ 3
    Migra: like diff but for PostgreSQL schemas
    story by djrobstep · 2017-03-01 · 0 comments