bob VS atlas

Use something that does codegen, like sqlc or Bob.

Also hout out to https://github.com/stephenafamo/bob

If you want to read the schema from the DB, use Bob. https://github.com/stephenafamo/bob

Generation for enums is done if you use Bob to generate your ORM.

Bob (https://github.com/stephenafamo/bob) generates models for a database schema, and for ease of use, I think it makes sense to be able to work with whatever format the schema is defined with.

Bob ORM for DB access

For an ORM recommendation, I'm heavily biased towards Bob (https://github.com/stephenafamo/bob) since I created it.

Website

Bob's GitHub Repository

I would definitely appreciate contributions to Bob: https://github.com/stephenafamo/bob

Check out: https://github.com/ariga/atlas

(I'm one of the authors of this project).

fwiw, I personally am interested in this approach too[0]. I keep running into roadblocks around the ordering of events and some of the hairy issues around "destructive" actions (eg: renaming columns). i think we can get there, especially once we make progress with this LSP.

There are other notable mentions in this space:

Reshape: https://fabianlindfors.se/blog/schema-migrations-in-postgres...

Atlas: https://atlasgo.io/

[0] https://github.com/kiwicopple/declarative-schemas

Atlas: https://github.com/ariga/atlas. It can be integrated with any ORM, but also has an official one for GORM: https://atlasgo.io/guides/orms/gorm

Run the queryx db:create command to create a PostgreSQL database, and then run queryx db:migrate to automatically create the database migration files and database structure. Queryx’s database schema management is built upon Atlas.

One of https://atlasgo.io's creators here.

In this case, I'd recommend you to check Atlas: https://github.com/ariga/atlas

My name is Rotem, I'm one of the creators of Atlas (https://atlasgo.io) a modern open-source schema management tool. Recently one of our engineers created a cool Django plugin that creates beautiful (in my eyes at least ;-)) and shareable ERDs from your Django data models.

Yes, there is: Atlas! https://atlasgo.io / https://github.com/ariga/atlas.

Hi there You should take a look at Atlas - https://atlasgo.io which can help your team in many aspects of CI/ CD for databases : * CI - detect (and prevent) risky / incorrect migrations automatically * CD - support for modern deployment infrastructure (terraform, helm, etc)

You might want to check out Atlas. It provides automatic migration planning for GORM, and has various guides on how deploying schema migration on the popular platform and tools, such as Helm, Kubernetes and ECS.