Jean Niklas L'orange

hypirion.com

This is hyPiRion's blog, with posts about data structures and other things.

Popular posts: 3
Total points: 444
HN comments: 264
Rank: #5,927 personal

Visit hypirion.com → On Hacker News Feb 2024 – Apr 2026

Software Engineering 3 Programming Languages 1 Databases & Data 1

Most points Most discussed Most cited Newest

Implementing system-versioned tables in Postgres

2024161 points92 comments Databases & Data details

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.