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

  •        147

Dbmate is a database migration tool, to keep your database schema in sync across multiple developers and your production servers. It is a standalone command line tool, which can be used with Go, Node.js, Python, Ruby, PHP, or any other language or framework you are using to write database-backed applications. This is especially helpful if you are writing many services in different languages, and want to maintain some sanity with consistent development tools.

https://github.com/amacneil/dbmate

Tags
Implementation
License
Platform

   




Related Projects

Evolve - Database migration tool for .NET and .NET Core projects. Inspired by Flyway.

  •    CSharp

Database migration tool for .NET and .NET Core. Inspired by Flyway. Evolve is an easy migration tool that uses plain SQL scripts. Its purpose is to automate your database changes, and help keep those changes synchronized through all your environments and development teams. This makes it an ideal tool for continuous integration / delivery.

ruckusing-migrations - Database migrations for PHP ala ActiveRecord Migrations with support for MySQL, Postgres, SQLite

  •    PHP

Ruckusing is a framework written in PHP5 for generating and managing a set of "database migrations". Database migrations are declarative files which represent the state of a DB (its tables, columns, indexes, etc) at a particular state of time. By using database migrations, multiple developers can work on the same application and be guaranteed that the application is in a consistent state across all remote developer machines. The idea of the framework was borrowed from the migration system built into Ruby on Rails. Any one who is familiar with Migrations in RoR will be immediately at home.

squasher - Squasher - squash your old migrations in a single command

  •    Ruby

Squasher compresses old ActiveRecord migrations. If you work on a big project with lots of migrations, every rake db:migrate might take a few seconds, or creating of a new database might take a few minutes. That's because ActiveRecord loads all those migration files. Squasher removes all the migrations and creates a single migration with the final database state of the specified date (the new migration will look like a schema). @note if you use Rbenv don't forget to run rbenv rehash.

mysql-workbench-export-laravel-5-migrations - A MySQL Workbench plugin which exports a Model to Laravel 5 Migrations

  •    Python

A MySQL Workbench plugin that allows for exporting a model to Laravel 5 migrations that follow PSR-2 coding standards. When exported, each migration is generated and saved in it's own, properly named, migration file. This plugin requires MySQL Workbench to work properly.


aerich - A database migrations tool for TortoiseORM, ready to production.

  •    Python

Aerich is a database migrations tool for Tortoise-ORM, which is like alembic for SQLAlchemy, or like Django ORM with it's own migration solution. If your Tortoise-ORM app is not the default models, you must specify the correct app via --app, e.g. aerich --app other_models init-db.

fluentmigrator - Fluent Migrations framework for .net

  •    CSharp

Fluent Migrator is a migration framework for .NET much like Ruby on Rails Migrations. Migrations are a structured way to alter your database schema and are an alternative to creating lots of sql scripts that have to be run manually by every developer involved. Migrations solve the problem of evolving a database schema for multiple databases (for example, the developer's local database, the test database and the production database). Database schema changes are described in classes written in C# that can be checked into a version control system.This will also build the whole solution.

lobos - A library to create and manipulate SQL database schemas with migrations support.

  •    Clojure

Lobos is a SQL database schema manipulation and migration library written in Clojure. It currently support supports H2, MySQL, PostgreSQL, SQLite and SQL Server. If you have any questions, please join the mailing list.

prisma-client-go - Prisma Client Go is an auto-generated and fully type-safe database client

  •    Go

Prisma Client Go is an auto-generated query builder that enables type-safe database access and reduces boilerplate. You can use it as an alternative to traditional ORMs such as gorm, xorm, sqlboiler and most database-specific tools. It is part of the Prisma ecosystem. Prisma provides database tools for data access, declarative data modeling, schema migrations and visual data management.

efcore - EF Core is a modern object-database mapper for

  •    CSharp

This repository is home to the following .NET Foundation projects. These projects are maintained by Microsoft and licensed under the Apache License, Version 2.0. EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations. EF Core works with SQL Server, Azure SQL Database, SQLite, Azure Cosmos DB, MySQL, PostgreSQL, and other databases through a provider plugin API.

node-pg-migrate - Node.js database migration management for Postgresql

  •    Javascript

Node.js database migration management built exclusively for postgres. (But can also be used for other DBs conforming to SQL standard - e.g. CockroachDB.) Started by Theo Ephraim, now maintained by Salsita Software. You can specify your database connection information using config.

Flyway - Database Migrations Made Easy

  •    Java

Flyway is the open-source tool that makes database migrations easy. You can think of Flyway as version control for your database. It lets you evolve your database schema easily and reliably across all your instances. Flyway has been designed from day one to be easy to setup and simple to master. It strongly favors simplicity and convention over configuration. It achieves this by focusing on one problem only and solving it well.

node-sqlite - SQLite client library for Node

  •    Javascript

A wrapper library that adds ES6 promises and SQL-based migrations API to sqlite3 (docs).🔥 Want to strengthen your core JavaScript skills and master ES6? I would personally recommend this awesome ES6 course by Wes Bos.

phinx - PHP Database Migrations for Everyone

  •    PHP

Phinx makes it ridiculously easy to manage the database migrations for your PHP app. In less than 5 minutes, you can install Phinx and create your first database migration. Phinx is just about migrations without all the bloat of a database ORM system or framework. Check out https://book.cakephp.org/3.0/en/phinx.html (EN, ZH) for the comprehensive documentation.

migrations-generator - Laravel Migrations Generator: Automatically generate your migrations from an existing database schema

  •    PHP

Please note that the Laravel 4 Generator edits have been moved to https://github.com/xethron/Laravel-4-Generators.git to update compatibility. In Laravel 5.5 the service providers will automatically get registered.

gh-ost - GitHub's Online Schema Migrations for MySQL

  •    Go

gh-ost is a triggerless online schema migration solution for MySQL. It is testable and provides pausability, dynamic control/reconfiguration, auditing, and many operational perks.gh-ost produces a light workload on the master throughout the migration, decoupled from the existing workload on the migrated table.

Sharp Migrations

  •    DotNet

Sharp migrations is a framework to help you deal with database changes and versioning over time. The idea comes from the excellent Ruby on Rail's migrations and it is the best way to alter your database in a structured and organised manner.

pop - A Tasty Treat For All Your Database Needs

  •    Go

So what does Pop do exactly? Well, it wraps the absolutely amazing https://github.com/jmoiron/sqlx library. It cleans up some of the common patterns and work flows usually associated with dealing with databases in Go. Pop makes it easy to do CRUD operations, run migrations, and build/execute queries. Is Pop an ORM? I'll leave that up to you, the reader, to decide.

scenic - Versioned database views for Rails

  •    Ruby

Scenic adds methods to ActiveRecord::Migration to create and manage database views in Rails. Using Scenic, you can bring the power of SQL views to your Rails application without having to switch your schema format to SQL. Scenic provides a convention for versioning views that keeps your migration history consistent and reversible and avoids having to duplicate SQL strings across migrations. As an added bonus, you define the structure of your view in a SQL file, meaning you get full SQL syntax highlighting in the editor of your choice and can easily test your SQL in the database console during development.






We have large collection of open source products. Follow the tags from Tag Cloud >>


Open source products are scattered around the web. Please provide information about the open source projects you own / you use. Add Projects.