SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 database-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.
-
laravel-migrations-generator
Laravel Migrations Generator: Automatically generate your migrations from an existing database schema.
-
database-lab-engine
DBLab enables 🖖 database branching and ⚡️ thin cloning for any Postgres database and empowers DB testing in CI/CD. This optimizes database-related costs while improving time-to-market and software quality. Follow to stay updated.
-
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.
-
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.
-
yuniql
Free and open source schema versioning and database migration made natively with .NET/6. NEW THIS MAY 2022! v1.3.15 released!
-
nestjs-api-boilerplate
Nestjs API Boilerplate 😍 💪 🔥 : Typescript, Postgresql, TypeORM, Swagger for Api documentation, Passport-JWT authentication, Jest, Env configuration, Migrations, Seeds, Docker, Redis, AWS S3, and best application architecture.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Project mention: Ask HN: What tool(s) do you use to code review and deploy SQL scripts? | news.ycombinator.com | 2024-04-14Also RedGate, but Flyway has some reasons to recommend it over RedGate Deploy depending on your DBAs/workflows: https://flywaydb.org/
(Though I don't think it is "complete" or "perfect", either.)
EF Migrations are in a really good place now if you like/don't mind C# as a language (and you can easily embed SQL inside the C#, too, but there are benefits to being able to also run high level C# code). With today's tooling you can package your migration "runner application" as a single deployable executable for most platforms. You can build the executable once and run it in all your environments. (The same tool that updates your QA and Staging updates your Prod, testably running the same migrations.) Given the single executable deployable I might even consider using it for projects not themselves written in C#.
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: I am looking for a troubled/bad open source codebase | /r/ExperiencedDevs | 2023-07-12While I respect the work, Liquibase's code base is quite messy... https://github.com/liquibase/liquibase
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.
Project mention: Pg_branch: Pre-alpha Postgres extension brings Neon-like branching | news.ycombinator.com | 2023-10-01Underlying DBLab Engine is FOSS (Apache 2.0), with API, CLI and UI https://github.com/postgres-ai/database-lab-engine
gem "lol_dba" - https://github.com/plentz/lol_dba | Inspect the state of table indexes.
Great write up! At PeerDB, we’ve been using refinery https://github.com/rust-db/refinery to handle database migrations of our catalog Postgres database from Rust. It is easy, typesafe and gets the job done. Thought this would be useful for users building apps with Rust!
Project mention: migrate-mongo VS db-mongo-migration - a user suggested alternative | libhunt.com/r/migrate-mongo | 2023-06-25
Project mention: Schmig: Database migration tool written in BASH | news.ycombinator.com | 2024-02-02
The one that does complex stuff (aka super Enterprise) which you would think would be closed source is open source: https://github.com/goldmansachs/obevo
database-migrations related posts
- Ask HN: What tool(s) do you use to code review and deploy SQL scripts?
- Schmig: Database migration tool written in BASH
- Using Flyway to version your database
- Database Migrations
- Any free SchemaDiff tools out there? pgAdmin Schema Diff created a script but it fails (order is wrong, etc)
-
migrate-mongo VS db-mongo-migration - a user suggested alternative
2 projects | 25 Jun 2023
- dbForge Schema Compare vs Redgate SQL Compare vs ApexSQL Diff
-
A note from our sponsor - SaaSHub
www.saashub.com | 19 Apr 2024
Index
What are some of the best open-source database-migration projects? This list will help you:
Project | Stars | |
---|---|---|
1 | Flyway | 7,754 |
2 | goose | 5,554 |
3 | Phinx | 4,439 |
4 | liquibase | 4,384 |
5 | dbmate | 4,321 |
6 | laravel-migrations-generator | 2,233 |
7 | database-lab-engine | 1,893 |
8 | Lol DBA | 1,571 |
9 | upscheme | 1,292 |
10 | refinery | 1,199 |
11 | migrate-mongo | 893 |
12 | aerich | 779 |
13 | tenanti | 585 |
14 | shmig | 457 |
15 | compalex | 425 |
16 | yuniql | 409 |
17 | obevo | 227 |
18 | flyway-docker | 204 |
19 | Scala-Forklift | 188 |
20 | phoenix | 164 |
21 | micrate | 158 |
22 | SQift | 142 |
23 | nestjs-api-boilerplate | 119 |