departure
database-lab-engine
departure | database-lab-engine | |
---|---|---|
1 | 20 | |
134 | 2,023 | |
0.0% | 7.2% | |
8.0 | 8.1 | |
3 months ago | 3 days ago | |
Ruby | TypeScript | |
GNU General Public License v3.0 or later | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
departure
-
Changing Tires at 100mph: A Guide to Zero Downtime Migrations
At least for Rails there are several gems available (ie https://github.com/WeTransfer/ghost_adapter or https://github.com/departurerb/departure) that seamlessly hook into the existing migration system and will run all eligible migrations through gh-ost or pt-osc as needed. You're right that it's not free but it isn't all that far off either.
That said, online schema migrations are a specialized tool designed for very big tables that take hours to run an ALTER TABLE on. If all your tables are small enough that alterations take less than a second or so, don't bother and just block the table for a bit. It's fine.
database-lab-engine
-
Pg_branch: Pre-alpha Postgres extension brings Neon-like branching
Underlying DBLab Engine is FOSS (Apache 2.0), with API, CLI and UI https://github.com/postgres-ai/database-lab-engine
-
Want to avoid MySQL but find PlanetScale really appealing
That said, there are a few folks out there attempting it. As mentioned, Neon attempts branching but has no "merge". Postgres.ai has "thin clones" for similar migration testing but again, no "merge".
-
Neon – Serverless Postgres
Agreed, this direction is underestimated and should be developed better -- we (Postgres.ai) do it for any Postgres with our Database Lab Engine [1], and Neon would bring even more power if it's installed on production
[1] https://github.com/postgres-ai/database-lab-engine
- Changing Tires at 100mph: A Guide to Zero Downtime Migrations
- Database Lab Engine 3.1 for PostgreSQL
- Database Lab Engine 3.1 released: native support for pgBackRest, timezones in CLI, more
- Database Lab Engine: Thin PostgreSQL Clones. DLE provides blazing-fast database cloning to build powerful development, test, QA, staging environments.
- Thin PostgreSQL clones
What are some alternatives?
reshape - An easy-to-use, zero-downtime schema migration tool for Postgres
neon - Neon: Serverless Postgres. We separated storage and compute to offer autoscaling, branching, and bottomless storage.
data-migrate - Migrate and update data alongside your database structure.
wal-g - Archival and Restoration for databases in the Cloud
pg-osc - Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL
goose - A database migration tool. Supports SQL migrations and Go functions.
ghost_adapter - Run ActiveRecord migrations through gh-ost
libschema - database schema migrations on a per-library basis [Go]
janet - A dynamic language and bytecode vm
PolarDB-for-PostgreSQL - A cloud-native database based on PostgreSQL developed by Alibaba Cloud.
litestream - Streaming replication for SQLite.
blog - OpenSource,Database,Business,Minds. git clone --depth 1 https://github.com/digoal/blog