pgreplay
pgreplay reads a PostgreSQL log file (*not* a WAL file), extracts the SQL statements and executes them in the same order and relative time against a PostgreSQL database cluster. (by laurenz)
aquameta
Web development platform built entirely in PostgreSQL (by aquametalabs)
pgreplay | aquameta | |
---|---|---|
2 | 8 | |
205 | 1,092 | |
- | 0.0% | |
4.2 | 8.0 | |
7 months ago | 4 months ago | |
C | PLpgSQL | |
GNU General Public License v3.0 or later | GNU General Public License v3.0 only |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.
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.
pgreplay
Posts with mentions or reviews of pgreplay.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-10-20.
-
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.
aquameta
Posts with mentions or reviews of aquameta.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-10-20.
-
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
What are some alternatives?
When comparing pgreplay and aquameta you can also consider the following projects:
pgkit - Pgkit - Backup, PITR and recovery management made easy
omdb-postgresql - PostgreSQL Schema for OMDB