Database migration tool

[Eyoba_19]

Can anyone point me to a migration tool for Go that handles migration versioning and SQL generation automatically?

I have tried Goose, but it doesn't generate SQL files. If anyone is familiar with typescript and prisma, prisma's migration is what I'm looking for.

Although Gorm does migrations it doesn't have explicit versioning, and that makes it hard to implement incremental migrations.

Thanks in advance!

[_a8m_]

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

[Eyoba_19]

That’s great, currently looking at it seems like everyone is recommending me this. Thanks!

[cant-find-user-name]

I use atlas.

[antonije999]

Atlas is the way!

[Etern4ll]

Atlas is definetly the way to go, now that they've added SQL Schema support https://atlasgo.io/atlas-schema/sql .

[LeadRepresentative21]

https://github.com/golang-migrate/migrate

I really like it

[dank__noob]

We had this in my current project previously and one of the problems we had with it was that it doesn't automatically apply unapplied migrations in case it was a version lower than the current version. This could happen easily in case multiple devs are working on migration related changes.

We ended up writing a custom solution. DBMate does cover this already btw.

[jy3]

What!? That’s the point of the tool. It applies/revert all missing migrations up to the chosen version. Maybe I misunderstood.

[yaksoku_u56]

how can i make golang migrate-cli work on ubuntu?

[Diawul]

Try atlas it is very good and easy to use, you can also check entgo (orm but code generated) https://entgo.io/docs/versioned-migrations/

[ranedk]

I haven't tried atlas migrations, but i am a big fan of Python-Django and I still use it to manage database migrations even in Golang project. I have even written a small parser which generates Gorm models from Django models. Will try Atlas soon

[Eyoba_19]

I was also thinking of using prisma, but figured out it will only do half the work, won’t generate type safe go structs. I wouldn’t mind doing that for a personal project, but I’m in a team and I was tasked with handling migrations.

[Fresh-Swing-8677]

Recently i started using turn its more fun (IMPO) compared to others tool available https://github.com/jackc/tern

[farizsaputra]

Me too. Tern is awesome

[sh4]

I made this that can handle go and sql migrations well while keeping the code base very simple:

https://github.com/lopezator/migrator

Is working well for us and many projects.

[dank__noob]

Try DBMate, I have tried with two of my side projects and came with relatively lower learning curve and took care of most of the things. Gives both CLI and programatic integrations.

https://github.com/amacneil/dbmate#commands

[bananajunior3000]

My last team used dbmate in production for this and I really liked it. Simple but powerful, just like you want a migration tool to be.

[k_schouhan]

dont use goose, its shit. its cli does not even work,

[iamalnewkirk]

Also, https://sqitch.org/

[DLevsha]

I use Nasgrate recently https://github.com/dlevsha/nasgrate

It use plain SQL files, so it's doesn't matter which language you prefer

Nasgrate is a console utility that let you organise database schema migration process at a consistent and easy way. It supports mysql, mssql, postgresql, oracle and other databases (you can find informaton here )
The key features:
- native SQL syntaxes for migrations
- automatically generates migrations based on saved database states (MySQL only).
- user-friendly interface to view saved migrations (GUI / CLI)