Hacker GitHub

← All repos

scalegenius/pg_bitemporal

View on GitHub ↗ ★ 163 PLpgSQL

Bitemporal tables in Postgres

14 mentions on Hacker News by 9 people: 0 stories, 14 comments · first 2019-04-22 · latest 2025-02-26

Mentions per year 14 mentions · busiest year 2019 (3)
20082026
AllStoriesComments NewestTopOldest
  1. …Temporal "immutable DB" functionality? [0] https://en.wikipedia.org/wiki/Temporal_database [1] https://github.com/scalegenius/pg_bitemporal/blob/master/doc... [2] https://github.com/ifad/chronomodel
    comment by xanth · 2025-02-26 · in EdgeDB is now Gel and Postgres is the future
  2. …way, such as bitemporal tables. - https://aiven.io/blog/two-dimensional-time-with-bitemporal-d... - https://github.com/scalegenius/pg_bitemporal 4 timestamps and some ugly queries.
    comment by _boffin_ · 2024-02-24 · in The Ultimate Guide to PostgreSQL Data Change Tracking
  3. …sure Postgres is any closer to addressing this natively (although there have been extensions, e.g. https://github.com/scalegenius/pg_bitemporal ).
    comment by refset · 2023-08-05 · in Eventual Business Consistency
  4. …- https://hdombrovskaya.files.wordpress.com/2016/09/bi_tempora... - https://github.com/scalegenius/pg_bitemporal
    comment by _boffin_ · 2022-12-08 · in Row change auditing options for PostgreSQL (2020)
  5. …close enough: - https://github.com/nearform/temporal_tables - 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…
    comment by refset · 2022-10-23 · in Show HN: I made a CMS that uses Git to store your data
  6. How does this compare to https://github.com/scalegenius/pg_bitemporal ?
    comment by phonon · 2021-04-11 · in Temporal Tables PostgreSQL Extension
  7. …it does solve one individual problem thoroughly. Everything has to start somewhere, though. [1] - https://github.com/scalegenius/pg_bitemporal
    comment by jka · 2021-04-09 · in Bitemporal History
  8. Check out our framework for bitemporlity: https://github.com/scalegenius/pg_bitemporal We use it in production for 5 years. I am ready to answer any performance/indexing and other questions
    comment by Hettie · 2021-04-09 · in Bitemporal History
  9. …suited) [although there are attempts on making bitemporality accessible in postgresql too, like https://github.com/scalegenius/pg_bitemporal ]
    comment by diggan · 2020-09-24 · in PostgreSQL 13
  10. …supported this out of the box. Does anyone have experience using this? How does it compare to https://github.com/scalegenius/pg_bitemporal ?
    comment by alecbenzer · 2020-07-12 · in MariaDB Temporal Data Tables
  11. 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
  12. …by now. Zero performance problems, lots of gains from the business perspective. Our code is here: https://github.com/scalegenius/pg_bitemporal
    comment by Hettie · 2019-04-23 · in The Value of Bitemporality – Whose Time Is It Anyway?
  13. https://github.com/scalegenius/pg_bitemporal
    comment by Hettie · 2019-04-23 · in The Value of Bitemporality – Whose Time Is It Anyway?
  14. Anyone know whether the [pg_bitemporal]( https://github.com/scalegenius/pg_bitemporal ) project is still being developed? There's a talk on YouTube which showed promise but the Github repo seems pretty dead.
    comment by snthpy · 2019-04-22 · in The Value of Bitemporality – Whose Time Is It Anyway?