aquameta
pgreplay
aquameta | pgreplay | |
---|---|---|
8 | 2 | |
1,092 | 205 | |
0.0% | - | |
8.0 | 4.2 | |
4 months ago | 7 months ago | |
PLpgSQL | C | |
GNU General Public License v3.0 only | GNU General Public License v3.0 or later |
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.
aquameta
-
Versioning data in Postgres? Testing a Git like approach
Aquameta has an interesting extension that something like this in a different way: https://github.com/aquametalabs/aquameta/tree/master/extensi....
-
You Can Now Code Websites with SQL
Related: Web development platform built entirely in PostgreSQL - https://github.com/aquametalabs/aquameta
- Just Use Postgres for Everything
- Aquameta is a web stack mostly in Postgres
- How to really use Postgres for literally everything.
-
What is the best way of implementing versions/revisions/history on a Postgres database?
I've never used this but it looks interesting https://github.com/aquametalabs/aquameta/tree/master/extensions/bundle
pgreplay
-
Versioning data in Postgres? Testing a Git like approach
pgreplay parses not the WAL Write Ahead Log but the log file: https://github.com/laurenz/pgreplay
From "A PostgreSQL Docker container that automatically upgrades your database" (2023) https://news.ycombinator.com/item?id=36748041 :
pgkit wraps Postgres PITR backup and recovery:
-
Real Application Testing on 🚀YugabyteDB with 🐘pgreplay
This blog was just to verify that it works with YugabyteDB. Check pgreplay documentation for more, all works the same in YugabyteDB. If you want to capture a workload from connections on multiple database nodes, each one will have their logfile. You can merge them. The Session ID (the 6th field in the csvlog built from start time and backend pid will probably not collide with another one, but you can make it unique by concatenating a node number if you want). The replay connects to one node, but though a HA proxy the connections can be distributed to multiple ones. All depends on what you want to capture and wh you want to replay. Capturing from PostgreSQL and replaying to YugabyteDB is also a good way to check that all works the same without performance regressions.
What are some alternatives?
omdb-postgresql - PostgreSQL Schema for OMDB
pgkit - Pgkit - Backup, PITR and recovery management made easy
snowfs - SnowFS - a fast, scalable version control file storage for graphic files :art:
Logidze - Database changes log for Rails
duckdb_fdw - DuckDB Foreign Data Wrapper for PostgreSQL
blog - Subscribe to this repository to receive notifications whenever a new article is published at https://vb-consulting.github.io/
klapa - Text patterns clustering in PostgreSQL
temporal_tables - Postgresql temporal_tables extension in PL/pgSQL, without the need for external c extension.
neon - Neon: Serverless Postgres. We separated storage and compute to offer autoscaling, branching, and bottomless storage.
blog - OpenSource,Database,Business,Minds. git clone --depth 1 https://github.com/digoal/blog
simonwillisonblog-backup - Backups of the database for simonwillison.net