Endatabas: An open source immutable, Document Database with Full History(endatabas.com)
endatabas.com
Endatabas: An open source immutable, Document Database with Full History
https://www.endatabas.com/
7 comments
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:
Then:
On disk storage format is Apache Arrow.
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/endbOn disk storage format is Apache Arrow.
This is super cool! It seems that endb uses emscripten to compile to WebAssembly, I wonder if they tried WASI or WASIX (https://wasix.org) to target both browser and server environments!
We did try to get WASI to work, but ECL itself doesn't yet target it. It fell down on missing set/longjmp support in wasi-libc. We haven't tried WASIX yet.
There are other approaches than the one we've taken so far, and we're still experimenting. But for the current demo, we're quite happy with Emscripten. The entire Wasm ecosystem feels pretty darn magical. :)
There are other approaches than the one we've taken so far, and we're still experimenting. But for the current demo, we're quite happy with Emscripten. The entire Wasm ecosystem feels pretty darn magical. :)
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.
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.