{"repo":"amacneil/dbmate","free":true,"listed":false,"github":"https://github.com/amacneil/dbmate","clone":"git clone https://github.com/amacneil/dbmate.git","description":"🚀 A lightweight, framework-agnostic database migration tool.","language":"Go","stars":7050,"topics":["database-migrations","golang","nodejs","python","database-schema","docker","mysql","postgresql","sqlite","migration"],"license":"MIT","category":"databases-storage","readme_excerpt":"Dbmate Dbmate is a database migration tool that will keep your database schema in sync across multiple developers and your production servers. It is a standalone command line tool that can be used with Go, Node.js, Python, Ruby, PHP, Rust, C++, or any other language or framework you are using to write database-backed applications. This is especially helpful if you are writing multiple services in different languages, and want to maintain some sanity with consistent development tools. For a comparison between dbmate and other popular database schema migration tools, please see Alternatives. Table of Contents - Features - Installation - Commands - Command Line Options - Usage - Connecting to the Database - PostgreSQL - MySQL - MariaDB - SQLite - ClickHouse - BigQuery - Spanner - Creating Migrations - Running Migrations - Rolling Back Migrations - Migration Options - Waiting For The Database - Exporting Schema File - Library - Use dbmate as a library - Embedding migrations - Concepts - Migration files - Schema file - Schema migrations table - Alternatives - Contributing Features - Supports MySQL, MariaDB, PostgreSQL, SQLite, and ClickHouse - Uses plain SQL for writing schema migrations - Migrations are timestamp-versioned, to avoid version number conflicts with multiple developers - Migrations are run atomically inside a transaction - Supports creating and dropping databases (handy in development/test) - Supports saving a schema.sql file to easily diff schema changes in git - Da","default_branch":null,"files":null,"tree":[],"storefront":"/r/amacneil","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/amacneil/dbmate/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}