News for hackers. Stuff that matters.

ftdyuio9p0iugy

Re:SQLite Internals: Pages and B-trees on Wednesday July 27, 2022 @12:37PM (#32252704)
I've had some append-only tables in Postgres and only recently realised that Postgres' system columns (https://www.postgresql.org/docs/14/ddl-system-columns.html) already effectively enabled some Datomic-like structure for such append-only tables! Specifically the xmin column allows me to identify the rows to treat atomically as a unit, and to ignore if I'm querying for a historical view.