Pgschema – Declarative schema migration for Postgres (pgschema.com)

Interesting idea; For schemas migration I like tools like Liquibase/Flyway/Knex, but their main disadvantage is that the more migrations you've had, the harder it's to reason about your current db schema

I tend to prefer Grate for this. And, though migration scripts aren't the same as an active schema, there's other tools to see a current database's schema, and it's easy enough to run on a new/empty db locally if you want to do it offline.

i wish i had a project to test this with over time. i never really loved the idea of writing plain SQL migrations for schema management, purely from an ops perspective. maybe that's partially just because i don't spend enough time reading raw sql queries to put a model together in my head as quickly as i could from something declarative.

What a journey:

AGPL https://github.com/pgschema/pgschema/blob/97f4bf5c00fd10add5...

MIT https://github.com/pgschema/pgschema/blob/53313057201931b2e8...

Whatever the fuck this is, that ain't community that's "I made up a licence how hard can it be": https://github.com/pgschema/pgschema/blob/6f5ce89cc1ac12f4a6...