pg_bitemporal
Reladomo
pg_bitemporal | Reladomo | |
---|---|---|
7 | 2 | |
140 | 375 | |
1.4% | -0.5% | |
0.0 | 3.2 | |
about 2 years ago | 10 months ago | |
PLpgSQL | Java | |
BSD 3-clause "New" or "Revised" 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_bitemporal
-
The Guide to PostgreSQL Data Change Tracking
I feel like i keep yelling the following, but bitemporal tables.
- https://aiven.io/blog/two-dimensional-time-with-bitemporal-d...
- https://github.com/scalegenius/pg_bitemporal
4 timestamps and some ugly queries.
-
Eventual Business Consistency
People here may also be interested to see this analysis of the state of SQL:2011 "temporal table" feature adoption: https://illuminatedcomputing.com/posts/2019/08/sql2011-surve...
I don't think much has really changed since, and I'm not sure Postgres is any closer to addressing this natively (although there have been extensions, e.g. https://github.com/scalegenius/pg_bitemporal).
- Show HN: I made a CMS that uses Git to store your data
-
Record history / Temporal table question
Something more sophisticated would be https://github.com/scalegenius/pg_bitemporal
- PostgreSQL 14 Released
-
Bitemporal History
Sure, I can appreciate that native support for a feature like this is nice.
As I understand it, most implementations (including another one for bitemporality[1]) involve either audit tables, as you mention, and/or additional support columns. It's as if the "now" representation is simply a narrow lens onto the underlying data.
That said, PostgreSQL encodes and has battle-tested decades of database functionality including an ecosystem around those, so I'd be a little wary of switching technology even if it does solve one individual problem thoroughly. Everything has to start somewhere, though.
[1] - https://github.com/scalegenius/pg_bitemporal
Reladomo
-
Java SQL code generator. SQL and OOP united finally.
Looks promising! You can also check out https://github.com/goldmansachs/reladomo for some inspiration. I used to work with this library when I worked at Goldman Sachs. They open sourced it couple years ago.
-
Bitemporal History
Not the OP, but Reladomo is a Java ORM which supports bitemporal history.
https://github.com/goldmansachs/reladomo
What are some alternatives?
temporal_tables - Temporal Tables PostgreSQL Extension
Hibernate - Hibernate's core Object/Relational Mapping functionality
crux - General purpose bitemporal database for SQL, Datalog & graph queries. Backed by @juxt [Moved to: https://github.com/xtdb/xtdb]
MyBatis - MyBatis SQL mapper framework for Java
wasmer.io - The Wasmer.io website
Spring Data JPA - Simplifies the development of creating a JPA-based data access layer.
outstatic - Outstatic - A static CMS for Next.js
Ebean ORM - Ebean ORM
Kirby - Kirby's core application folder
Apache Cayenne - Mirror of Apache Cayenne
Publii - The most intuitive Static Site CMS designed for SEO-optimized and privacy-focused websites.