vlcn.io

Interesting realization that if you're syncing CRDTs through a central server you can apply whatever sort of validation logic you want on the server to preserve constraints. The validation logic just needs to write fixes as a new database version to sync back to clients.

"Most databases were built when data was static and queries were dynamic. For applications, most queries are static and the data is dynamic" - @matthew_linkous I never thought about it this way before but this is spot on.

github.com/groue/GRDB.swift is an amazing piece of work in terms of improving the reactivity story for SQLite.

In the refinement phase of cr-sqlite - - decreasing crdt metadata size by 5x - improving crr creation syntax - adding support for resurrecting deleted items - adding list CRDTs to the DB so you can have collaborative text w/o yjs or automerge - improving schema migrations

I was accepted to give a talk about github.com/vlcn-io/cr-sqlite & local-first software at #DWebCamp2023! 🎉 See you there! @GetDWeb

I was blown away by @aboodman's talk and the Replicache model so I spent the last day experimenting with a variation on the idea: "Creating CRDTs without specialized knowledge" vlcn.io/articles/crdt-substr…

One of the things I'm most excited for is partnering with the LibSQL folks to create a custom syntax for defining tables which are backed by CRDTs! LibSQL is truly getting SQLite ready for the coming decades -- github.com/libsql/libsql vlcn.io/cr-sqlite/custom-syn…

Spent the am building reactive code cells that can depend on one another for the new documentation site. Like ObservableHQ but I didn't want to include their notebook interface.