5 ms·

Oh how I wish for Postgres to introduce system-versioned (bi-temporal) tables.

• qianli_cs 2y ago
  What's your use case for system-versioned tables? You could use some extensions like Periods that support bi-temporal tables: https://wiki.postgresql.org/wiki/Temporal_Extensions https://wiki.postgresql.org/wiki/Temporal_Extensions Or you could use triggers to build one: https://hypirion.com/musings/implementing-system-versioned-tables-in-postgres https://hypirion.com/musings/implementing-system-versioned-t...
  • baq 2y ago
    any system of record has a requirement to be bitemporal, it just isn't discovered until too late IME. I don't know if there's a system anywhere which conciously decided to not be bitemporal during initial design.
• jeltz 2y ago
  It will hopefully be in PostgreSQL 18.
  • infamia 2y ago
    Is there an active effort to get temporal tables into Postgres at the moment?
    • infamia 2y ago
      It looks like Paul A. Jungwirth and others are trying to get Temporal Tables into Postgres 18. https://illuminatedcomputing.com/posts/2024/07/temporal-reverted/ https://illuminatedcomputing.com/posts/2024/07/temporal-reve...