3
DBMate
source link: https://console.dev/tools/dbmate
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Plain-SQL DB migrations.
ManagementOpen Source
Our review
What we like
Standalone CLI for managing database migrations. Maintains a “current state” SQL file so you can always provision the database and diff changes. Migrations are specified in plain SQL with up and down states to support rollbacks. Runs migrations inside transactions. Single binary & can also be embedded in code (Go).
What we don't like
Framework agnostic, but may not play well if you do use a framework like Prisma and want to manage migrations for its schema across other languages. Not sure if that’s a limitation of DBMate or Prisma, though!
Reviewed: 2023-09-21
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK