Oh man this is really good. I have had to do some gist exclusions for payment data and it was clunky. Hopefully we get the other half of bitemporal support with postgres 20!
To the author of the article. This was a really nice and educating read. You made me finally understand recursive CTEs, the org chart was a really good example. Thank you.
This reminds me of learning linux and cli commands because an old netbook with like 512 of ram was struggling with modern guis and web browsers. So I used a minimal i3 installation and interacted mostly with a terminal.