1. A general-purpose Bitemporal Data Schema using SQLite (for storage) and Clojure (for data processing).
I'm trying to see if I can "get away with it": no schema migration, no fixed views, one tenant per DB, local-first-friendliness.
The general approach is "Datomic meets XTDB meets redplanetlabs/Rama meets Local First". Conceptually, the lynchpin "WORLD FACTs" table looks like this:
| tx_id | valid_id | tx_t | valid_t | origin_t | entity | attribute | value | assert | namespace | user | role |
|--------+----------+---------+---------+----------+--------+-----------+-------+--------+---------------+------+------|
| uuidv7 | uuidv7 | unix ms | unix ms | uuid7 | adi | problems | sql | 1 | org.evalapply | adi | boss |
A workshop I've been experimenting with, using willing friends as guinea pigs. To help people remove friction from being able to "spool brain to disk". The sales-y part is here, with more context / explanation about what it is about and what it is not about: https://www.evalapply.org/index.html#writing-for-nerds