simonwillison.net · Saved

Endatabas

simonwillison.net/2024/Mar/1/endatabas

What Jamie wrote

I hadn't heard of Endatabas and this summary from Willison hits on some great highlights.

It uses a variant of SQL which allows you to insert data into tables that don’t exist yet (they’ll be created automatically) then run standard select queries, joins etc. It maintains a full history of every record and supports the recent SQL standard “FOR SYSTEM_TIME AS OF” clause for retrieving historical records as they existed at a specified time (it defaults to the most recent versions).

Pretty cool stuff.