Matt Wonlaw

sync cr-sqlite back to libsql after adding: https://github.com/tursodatabase/libsql/pull/219

Still waiting for the latest cr-sqlite to get merged : https://github.com/tursodatabase/libsql/pull/488 Looks like it needs updating again since the PR has been outstanding for so long :/

Yeah, I think that'd work. You could also: 1. Copy the db file 2. Open the new db (do not load the cr-sqlite extension yet) 3. Write your own UUID...

> Can I override the crsql_siteid even with the extension loaded? Ah, no. IIRC I read the site_id out and cache it in-memory. It may be possible to remove that...

libsql apparently allows users to save WASM extensions inside the database file itself. Would be an interesting route for delivering database files w/ cr-sqlite contained in them.

Related to #294 (vtab for full row sync)

this makes it somewhat problematic: https://www.sqlite.org/vtab.html#eponymous_virtual_tables > Eponymous virtual tables exist in the "main" schema only, so they will not work if prefixed with a different schema name. would require...

Found possible bugs: - PK update should also update clocks for rows to move them to the new PK. They're not dropped but moved! Junction table test should now work?...

eventually consistent distributed event DAG would be pretty interesting. Maybe based on SQLite4's LSM tree implementation. Peers could receive updates, rebase them into the DAG, notify embedding app

We've done much of this exploration in the `lww-vs-dag` article (to be re-published post migration to nextjs). We can double down on that further by auto-creating events rather than making...