sqlite-sync

It's kind of hard for me to think of a devtool as local-first or not, since the actual definition of local-first [1] talks about end-user software, not devtools. So the question is whether it's possible to build software that adheres to the local-first principles using sqlite-sync. edit: I'm aware people are using the term "local-first" very loosely, so perhaps my reply here is a bit off-topic p.s. yes you can self-host ElectricSQL p.p.s. I really need to keep my list of "sqlite sync" things updated: I have SQLSync [2], SQLiteSync [3] and now SQLite-Sync [4]. Simple! [1] https://www.inkandswitch.com/essay/local-first/ [2] https://github.com/orbitinghail/sqlsync [3] https://ampliapps.com/sqlite-sync/ [4] https://github.com/sqliteai/sqlite-sync

This is content marketing for a open-source SQLite extension called `sqlite-sync` [0]. It seems pretty cool, implementing CRDTs and some networking directly in SQLite. Unfortunately this extension "is tightly integrated with SQLite Cloud." It doesn't support peer-to-peer syncing or self-hosting a central source of truth. The project is really just a client for the sqlite.ai cloud service. [0] https://github.com/sqliteai/sqlite-sync

I'd like to point out the following open-source SQLite project: https://github.com/sqliteai/sqlite-sync with a built-in cross-platform network layer. P.S. I am the author of the project.

There is a new solution that is worth considering: https://github.com/sqliteai/sqlite-sync P.S. I am the author

Great write-up! You should check out SQLite-Sync (https://github.com/sqliteai/sqlite-sync) - it might be exactly what you're looking for. There's also a WASM build (https://www.npmjs.com/package/@sqliteai/sqlite-sync-wasm)

It is open-source: https://github.com/sqliteai/sqlite-sync