pg-clone-schema
database-lab-engine
| pg-clone-schema | database-lab-engine | |
|---|---|---|
| 3 | 20 | |
| 176 | 2,108 | |
| - | 0.3% | |
| 8.7 | 8.7 | |
| 1 day ago | 4 days ago | |
| PLpgSQL | TypeScript | |
| MIT License | 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.
pg-clone-schema
-
Pg_branch: Pre-alpha Postgres extension brings Neon-like branching
For ad hoc copies I’ve found the third party schema cloning function useful. I assume performance would be an issue for huge databases though. https://github.com/denishpatel/pg-clone-schema
- Does PostgreSQL have schema creation command which replicates all the objects of another schema?
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?
pg_branch - Experimental Postgres extension for quickly branching databases through file system snapshots
neon - Neon: Serverless Postgres. We separated storage and compute to offer autoscaling, code-like database branching, and scale to zero.
examples - Examples for Oh Krab!
wal-g - Archival and Restoration for databases in the Cloud
pgcow - Bringing copy-on-write semantics to PostgreSQL.
goose - A database migration tool. Supports SQL migrations and Go functions.
dolt - Dolt – Git for Data
libschema - database schema migrations on a per-library basis [Go]
PolarDB-for-PostgreSQL - A cloud-native database based on PostgreSQL developed by Alibaba Cloud.
blog - Opensource,Database,AI,Business,Minds. git clone --depth 1 https://github.com/digoal/blog
reshape - An easy-to-use, zero-downtime schema migration tool for Postgres
upscheme - Database migrations and schema updates made easy