The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →
Top 23 Migration Open-Source Projects
-
-
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
-
-
-
express-typescript-boilerplate
A delightful way to building a RESTful API with NodeJs & TypeScript by @w3tecch
-
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
-
-
laravel-migrations-generator
Laravel Migrations Generator: Automatically generate your migrations from an existing database schema.
-
-
Lol DBA
lol_dba is a small package of rake tasks that scan your application models and displays a list of columns that probably should be indexed. Also, it can generate .sql migration scripts.
-
-
-
online_migrations
Catch unsafe PostgreSQL migrations in development and run them easier in production (code helpers for table/column renaming, changing column type, adding columns with default, background migrations, etc).
-
-
Ruckusing
Database migrations for PHP ala ActiveRecord Migrations with support for MySQL, Postgres, SQLite
-
laravel-one-time-operations
Run operations once after deployment - just like you do it with migrations!
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Go does not natively support the use of migrations, but we could use the ORM that has this functionality, such as GORM which is the most used by the community, but We can use migrations without using an ORM, for this we will use the golang-migrate package.
In v3.16.0 we added a new Provider feature that unlocks the ability to implement a lot of highly requested features. More details in the blog post:
Project mention: How do you manage database structure changes? And deploying code? | /r/webdev | 2023-06-18
Project mention: Ask HN: What tool(s) do you use to code review and deploy SQL scripts? | news.ycombinator.com | 2024-04-14A regular code repo with the scripts (with pull/merge requests for review) and then a CI job that builds containers with something like dbmate https://github.com/amacneil/dbmate that can then be run against any staging/prod environment.
I thought I recognized xataio - they submitted pgroll a few months back https://news.ycombinator.com/item?id=37752366 (https://github.com/xataio/pgroll - Apache 2)
I like to use plain SQL files for migrations but needed a tool to handle this. Settled for Umzug in the end, which is working pretty well. Its high configurable and framework-agnostic.
Project mention: Show HN: Reshape – Zero-downtime schema migrations for Postgres | news.ycombinator.com | 2023-11-16
gem "lol_dba" - https://github.com/plentz/lol_dba | Inspect the state of table indexes.
Project mention: migrate-mongo VS db-mongo-migration - a user suggested alternative | libhunt.com/r/migrate-mongo | 2023-06-25
NOTE:
The open source projects on this list are ordered by number of github stars.
The number of mentions indicates repo mentiontions in the last 12 Months or
since we started tracking (Dec 2020).
Migrations related posts
- Revolutionizing PostgreSQL Schema Changes with pg-osc
- PostgreSQL zero-downtime and reversible migrations
- How to use SQLC with Golang
- How pgroll works under the hood
- Python vs Powershell on *nix Systems
- Looking for recommendations for model/schema/migration management in Golang
- Migration Without ORM
-
A note from our sponsor - WorkOS
workos.com | 24 Apr 2024
Index
What are some of the best open-source Migration projects? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | migrate | 13,946 |
| 2 | goose | 5,637 |
| 3 | Doctrine Migrations | 4,633 |
| 4 | Phinx | 4,439 |
| 5 | dbmate | 4,321 |
| 6 | express-typescript-boilerplate | 3,205 |
| 7 | pgroll | 2,504 |
| 8 | cli | 2,503 |
| 9 | dbatools | 2,329 |
| 10 | Flask-Migrate | 2,295 |
| 11 | laravel-migrations-generator | 2,243 |
| 12 | umzug | 1,955 |
| 13 | reshape | 1,621 |
| 14 | Lol DBA | 1,571 |
| 15 | gobuffalo/pop | 1,405 |
| 16 | upscheme | 1,292 |
| 17 | node-pg-migrate | 1,215 |
| 18 | migrate-mongo | 893 |
| 19 | online_migrations | 579 |
| 20 | PHPMig | 566 |
| 21 | django-migration-linter | 509 |
| 22 | Ruckusing | 505 |
| 23 | laravel-one-time-operations | 378 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com