:rocket: A lightweight, framework-agnostic database migration tool. - amacneil/dbmate

Matthew Laird

Observability

Community Picks is a section on daily.dev where our community members share the most interesting and valuable content they've discovered online. From insightful articles to handy tools, every post is a gem curated by our dedicated coomunity. To contribute to Community Picks, you need to have at least 250 reputation points, ensuring that only active and trusted members can share their finds.

Community Picks

Dbmate is a framework-agnostic database migration tool that keeps database schema in sync across multiple developers and production servers. It supports multiple programming languages and frameworks. With dbmate, you can easily install and use it with npm, Homebrew, or directly with binary files. Dbmate provides commands to create, run, rollback, and manage database migrations. It also supports various options for customization. You can wait for the database to become available before executing commands. Dbmate can dump the database schema to a file and can be used as a library in Go applications. It also supports embedding migrations in Go application binaries. Dbmate offers a simple format for migration files and stores applied migrations in a table named schema_migrations. Compared to other tools, dbmate is easy to configure, language independent, and supports multiple database drivers.

amacneil/dbmate: :rocket: A lightweight, framework-agnostic database migration tool.

This is a simple yet powerful tool to decouple database migrations from application code

I’ve been using on a personal project for months and still fits perfectly my need :D
Pair it with SQL Boiler for Golang and boom