zheap
periods
zheap | periods | |
---|---|---|
3 | 5 | |
88 | 236 | |
- | - | |
10.0 | 2.4 | |
over 3 years ago | 3 months ago | |
HTML | PLpgSQL | |
- | PostgreSQL License |
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.
zheap
-
Tracking down high CPU Utilization on Amazon Aurora PostgreSQL
Hoping something like the zheap storage engine initiative should help us get past these bottlenecks in the future. Until then we may not be able to prevent the bloat but could certainly minimize the impact.
-
Building an interface (even if there's only one implementation) is always right
Hey, OP here -- it is a bit odd and also possibly immature to be so harsh on MySQL apropos of nothing. That said, I intended more to be pro-Postgres rather than anti-MySQL (it's a great piece of software, other DBs and Postgres learn from it all the time, zheap[0] exists to replicate what they've built, for example).
I also have to admit that I definitely want postgres every time I see MySQL. Maybe I need to read more on just how easy and amazing MySQL can be. Links welcome!
[0]: https://cybertec-postgresql.github.io/zheap/
-
Databases in 2021: A Year in Review
Postgres's dominance is well deserved, of course. My only concerns with it, both are actively worked on, are bloat management (significant for update heavy workloads and programmers used to the MySQL model of rollback segments) and the scaling of concurrency (going over 500 connections). Bloat was taken over by Cybertec[1] after stalling for a bit and is funded (yay), while concurrency was also enhanced out of Microsoft [2]. All in all, an excellent future for our beloved Postgres.
[1] https://github.com/cybertec-postgresql/zheap
periods
- Show HN: I made a CMS that uses Git to store your data
- Databases in 2021: A Year in Review
-
Status of WITH SYSTEM VERSIONING: need help understanding commitfest page
One of the first items in the linked thread also mentions an extension that does the same right now. https://github.com/xocolatl/periods/
-
Temporal tables patch in progress perhaps for PG 15
Found within the discussion is this postgresql extension which performs a similar role using triggers and stored procedures.
- Temporal Tables PostgreSQL Extension
What are some alternatives?
sysbench - Scriptable database and system performance benchmark
zombodb - Making Postgres and Elasticsearch work together like it's 2023
dbdb.io - The On-line Database of Databases
django-simple-history - Store model history and view/revert changes from admin site.
pg_partman - Partition management extension for PostgreSQL
temporal_tables - Temporal Tables PostgreSQL Extension
pev2 - Postgres Explain Visualizer 2
postgres-aws-s3 - aws_s3 postgres extension to import/export data from/to s3 (compatible with aws_s3 extension on AWS RDS)
clickhouse-operator - Altinity Kubernetes Operator for ClickHouse creates, configures and manages ClickHouse clusters running on Kubernetes