Endatabas: An open source immutable, Document Database with Full History

This is great, but it had a 14-hour run on HN's front page just a few months ago:

Endatabas: A SQLite-inspired, SQL document database with full history - https://news.ycombinator.com/item?id=38484654 - Dec 2023 (20 comments)

Reposts are fine after a year or so (https://news.ycombinator.com/newsfaq.html), but if a topic has had significant attention more recently, that's what we count as a dupe.

Interactive (in your browser via WebAssembly) demo is here: https://www.endatabas.com/demo

Follow the tutorial at https://docs.endatabas.com/tutorial/sql_basics - so start with this:

    insert into posts (id, user_id, text) values (123, 456, 'Hello World');

(Which will create the table automatically)

Then:

    select * from posts;

It's AGPL licensed and written in Common Lisp, looks like it's been in development for just over a year: https://github.com/endatabas/endb

On disk storage format is Apache Arrow.

I spoke to the authors of this database while running my last startup about the exact problem this sets out to solve—the need for time-travel features in particular domains (versioning for everything!). Opens up a range of interesting options for novel user experiences—really glad that this is seeing the light of day.

Seems to be a breakout group from XTDB (which has a similar feature set), but they switched from Clojure to Common Lisp.