> You gain temporal querying with a history/audit table that mirrors the main one (or not -- if you prefer not to, and instead want to cram everything into a js

> You gain temporal querying with a history/audit table that mirrors the main one (or not -- if you prefer not to, and instead want to cram everything into a jsonb column). I rather liked that MariaDB has temporal tables out of the box: https://mariadb.com/kb/en/temporal-tables/ https://mariadb.com/kb/en/temporal-tables/ I think for PostgreSQL there was an extension last I checked: https://pgxn.org/dist/temporal_tables/ https://pgxn.org/dist/temporal_tables/ (edit: this doesn't appear very popular) Pretty nice, when the database does the heavy lifting and you have to do a bit less work yourself.