Hacker GitHub

← All repos

hettie-d/pg_bitemporal

View on GitHub ↗ ★ 63 PLpgSQL

Bitemporal tables in Postgres

4 mentions on Hacker News by 2 people: 0 stories, 4 comments · first 2023-08-30 · latest 2026-01-05

Mentions per year 4 mentions · busiest year 2023 (1)
20082026
AllStoriesComments NewestTopOldest
  1. …Otherwise there are full bitemporal extensions for PG, like this one: https://github.com/hettie-d/pg_bitemporal What we do is range types for when a row applies or not, so we get history, and then for 'immutability' we have 2 au
    comment by zie · 2026-01-05 · in Databases in 2025: A Year in Review
  2. Interesting. It sounds like you are only doing partial temporality? I'm playing with https://github.com/hettie-d/pg_bitemporal right now and it seems great so far.
    comment by zie · 2025-09-04 · in Poor man's bitemporal data system in SQLite and Clojure
  3. …And without the ORM layer there's this extension for Postgres: https://github.com/hettie-d/pg_bitemporal
    comment by refset · 2024-09-25 · in Insights after 11 years with Datomic [video]
  4. …bitemporal tables on Postgres, I think the only actively maintained library/extension available is https://github.com/hettie-d/pg_bitemporal (it's also not SQL:2011 compliant though).
    comment by refset · 2023-08-30 · in Historical records with PostgreSQL, temporal tables and SQL:2011(2015)