Jean Niklas L'orange personal blog

Implementing system-versioned tables in Postgres

by Jean Niklas hyPiRion L'orange hypirion.com published 2024-01-2116 min read

There's no official support for system-versioned tables in Postgres yet, and the temporal extensions aren't supported on Azure/AWS/GCP. Let's implement it ourselves with 3 triggers and an index.

Points

161

HN comments

92

Submissions

1

Cited by

0 commenters

Databases & DataSoftware Engineering2024

Related posts from the same era

Ingesting PDFs and why Gemini 2.0 changes everything

Sergey's Blog20251,303 points447 comments details

GPT in 500 Lines of SQL

Explain Extended20241,111 points76 commentscited by 3 details

Datomic is Free

DDatomic Blog20231,099 points368 commentscited by 5 details

Postgres IDE in VS Code

Microsoft Tech Community20251,040 points407 comments details

My favourite API is a zipfile on the European Central Bank's website

csvbase Blog20231,024 points265 comments details

The DuckDB Local UI

DuckDB Blog2025926 points188 commentscited by 3 details