ghost_adapter
database-lab-engine
| ghost_adapter | database-lab-engine | |
|---|---|---|
| 2 | 20 | |
| 18 | 1,992 | |
| - | 1.2% | |
| 1.5 | 8.1 | |
| 3 days ago | 2 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.
ghost_adapter
-
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... or Goose?
https://github.com/WeTransfer/ghost_adapter integrates gh-ost with activerecord and the departure gem does the same but for pt-osc.
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?
strong_migrations - Catch unsafe migrations in development
neon - Neon: Serverless Postgres. We separated storage and compute to offer autoscaling, branching, and bottomless storage.
safe-pg-migrations - Make your PostgreSQL migrations safe
wal-g - Archival and Restoration for databases in the Cloud
wt_activerecord_index_spy - A gem to spy queries running with Active Record and report missing indexes
goose - A database migration tool. Supports SQL migrations and Go functions.
Large Hadron Migrator - Online MySQL schema migrations
libschema - database schema migrations on a per-library basis [Go]
Ruby on Rails - Ruby on Rails
PolarDB-for-PostgreSQL - A cloud-native database based on PostgreSQL developed by Alibaba Cloud.
reshape - An easy-to-use, zero-downtime schema migration tool for Postgres
blog - OpenSource,Database,Business,Minds. git clone --depth 1 https://github.com/digoal/blog