arkhipov/temporal_tables
View on GitHub ↗ ★ 1,057 C
Temporal Tables PostgreSQL Extension
18 mentions on Hacker News by 13 people: 3 stories, 15 comments · first 2016-03-18 · latest 2025-09-03
20082026
-
▲ 3
Temporal Tables in Postgresstory by merqurio · 2025-09-03 · 0 comments
-
There is also the temporal_tables extension [0], which was already discussed in HN. [1] [0] https://github.com/arkhipov/temporal_tables [1] https://news.ycombinator.com/item?id=26748096
comment by schlowmo · 2023-09-22 · in Ways to capture changes in Postgres -
…- https://github.com/xocolatl/periods - https://github.com/scalegenius/pg_bitemporal - https://github.com/arkhipov/temporal_tables I haven't used any of them but I work on https://xtdb.com which is also implementing SQL:2011's temporal…
comment by refset · 2022-10-23 · in Show HN: I made a CMS that uses Git to store your data -
This extension simplifies things a bit: https://github.com/arkhipov/temporal_tables
comment by Scarbutt · 2021-10-26 · in Postgres audit tables saved us from taking down production -
…there, if you combine this with a plugin like temporal_tables and you can segment by user and time: https://github.com/arkhipov/temporal_tables All of this mostly unknown to the thing that's accessing the DB. If that's not enough for you,…
comment by hardwaresofton · 2021-04-15 · in SQLite the only database you will ever need in most cases -
…`temporal_tables` but I have built similar temporal systems on Postgres in the past. (Judging by https://github.com/arkhipov/temporal_tables#usage at least.) The trouble with these sorts of approaches is that they solve temporality the…
comment by deobald · 2021-04-09 · in Bitemporal History -
…to hear whether anyone has experience with the Temporal Tables[1] extension in PostgreSQL? [1] - https://github.com/arkhipov/temporal_tables
comment by jka · 2021-04-09 · in Bitemporal History -
▲ 153
Temporal Tables PostgreSQL Extensionstory by jka · 2021-04-09 · 27 comments
-
Check out https://github.com/arkhipov/temporal_tables or https://github.com/scalegenius/pg_bitemporal
comment by phonon · 2020-05-30 · in Oracle vs. PostgreSQL – A Comment -
…for Postgres that supports system-versioned tables, but it hasn't been updated in 2 years: https://github.com/arkhipov/temporal_tables In the past, I've manually implemented system-versioning for audit purposes in SQL Server using…
comment by ripley12 · 2019-12-22 · in Ask HN: What do you know about bitemporal databases? -
…[3] https://illuminatedcomputing.com/posts/2017/12/temporal-data... [4] https://github.com/arkhipov/temporal_tables [5] https://github.com/pgaudit/pgaudit
comment by pjungwir · 2019-04-21 · in The Value of Bitemporality – Whose Time Is It Anyway? -
See also the Temporal Tables extension to PostgreSQL https://github.com/arkhipov/temporal_tables
comment by fanf2 · 2017-07-07 · in Migration from Postgres to Datomic -
https://github.com/arkhipov/temporal_tables seems like a good option?
comment by phonon · 2017-05-18 · in PostgreSQL 10 Beta 1 Released -
▲ 5
Temporal Tables PostgreSQL Extensionstory by tosh · 2017-05-17 · 0 comments
-
There is https://github.com/arkhipov/temporal_tables which seems okay. Of course, it would be nice if Postgres natively supported the full SQL:2011 standard...
comment by phonon · 2016-09-26 · in Major features of PostgreSQL 9.6 [pdf] -
…supports the system-period temporal tables only. Also here is the same extension on github: https://github.com/arkhipov/temporal_tables
comment by pjungwir · 2016-06-23 · in Time-travel queries in CockroachDB -
There's an extension to add partial support of this to Postgres: https://github.com/arkhipov/temporal_tables I have used it in production for years and it works great, but does indeed use a lot of disk space if you enable it for all tables…
comment by clarkdave · 2016-06-23 · in Time-travel queries in CockroachDB -
https://github.com/arkhipov/temporal_tables works pretty well.
comment by phonon · 2016-03-18 · in No More Full Table Vacuums in PostgreSQL