wal-g
database-lab-engine
Our great sponsors
| wal-g | database-lab-engine | |
|---|---|---|
| 13 | 20 | |
| 3,048 | 1,900 | |
| 3.9% | 2.3% | |
| 9.0 | 8.2 | |
| about 15 hours ago | 4 days ago | |
| Go | 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.
wal-g
- WAL-G 3.0.0 – fast disaster recovery for Postgres
-
Introducing Read Replicas
Streaming replication minimizes replication lag, while file-based log shipping provides a fallback. For file-based log shipping, we use our existing Point In Time Recovery (PITR) infrastructure. We regularly archive files from the primary using WAL-G, an open source archival and restoration tool, and ship the WAL files to S3.
- WAL-G 2.0: backup and restore for database in the cloud
- Script to take PostgreSQL backups
-
Go 1.18 (Go with generics) no blocking issues left
While everyone fears some new spiral of complexity, it's nice
https://github.com/wal-g/wal-g/pull/1186
Add a few type constraints, throw out a few type casts along with the error handling
- Optimizing Postgres Queries at Scale
-
A rough proposal for sum types in Go, from a Rust compiler engineer
When it's occasionally useful return (type, err), but generally the two results are distinct so there's no need to return two results in the general case when one suffices
Indeed, I recently updated some code to return a relevant value in the error case: https://github.com/wal-g/wal-g/pull/1143/files#diff-d896e5d5...
- WAL-G 1.1 released: better disaster recovery for PG, MySQL, MongoDB, MS SQL
-
Automate pg_basebackup in linux
Have a look at barman, pgBackrest or for maybe WAL-G or WAL-E
- WAL-G 1.0: unified backup tool for PostgreSQL, MySQL, SQL Server, MongoDB, Redis
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?
pgBackRest - Reliable PostgreSQL Backup & Restore
neon - Neon: Serverless Postgres. We separated storage and compute to offer autoscaling, branching, and bottomless storage.
wal-e - Continuous Archiving for Postgres
goose - A database migration tool. Supports SQL migrations and Go functions.
docker-postgres-wale - Postgres docker container with WALE-E installed
libschema - database schema migrations on a per-library basis [Go]
citus-failover - Worker failover support for PostgreSQL Citus extension using pg_auto_failover.
PolarDB-for-PostgreSQL - A cloud-native database based on PostgreSQL developed by Alibaba Cloud.
gobackup - 🗄 CLI tool for backup your databases, files to cloud storages in schedully.
blog - OpenSource,Database,Business,Minds. git clone --depth 1 https://github.com/digoal/blog
spilo - Highly available elephant herd: HA PostgreSQL cluster using Docker
upscheme - Database migrations and schema updates made easy