migra Reviews and details

Social recommendations and mentions

• How to sustainably developer SQL database code (schemas, functions, ...)?

  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. Source: over 1 year ago

• A Postgres toolkit, might be handy for web development projects

  I included migra - https://databaseci.com/docs/migra. It does the same. I will include pgdiff too in the next release. Source: about 2 years ago

• MariaDB to go public at $672M valuation

  Thanks! I know of a couple Postgres tools that work in a declarative fashion: migra [1] and sqldef [2]. Migra is Postgres-specific. Its model is similar to Skeema's, in that the desired-state CREATEs are run in a temporary location and then introspected, to build an in-memory understanding of the desired state which can be diff'ed against the current actual state. (This approach was also borrowed by Prisma Migrate... - Source: Hacker News / over 2 years ago

• Atlas – Terraform but for Database Migrations

  I use migra [https://databaseci.com/docs/migra] for PostgreSQL. I only put schema.sql into git, no migration scripts. To make changes, I update schema.sql and load it up into temporary db. Then I run migra prod_db temp_db and it spits out the SQL statements that take me from the old schema.sql (which was in production) to the new. I eyeball the statements and if they look good, I apply them to prod_db. - Source: Hacker News / over 2 years ago