sqlsync

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

Definitely can still be used on a client, you just have to be creative with running it. https://github.com/orbitinghail/sqlsync uses rusqlite compiled to WASM within a Web Worker, for instance.

I was confused at first because I saw nothing in the Network tab of the browser dev tools. But I figured it out; opening the dev tools for the shared worker, one can see that it does a websocket connection upgrade when the page is reloaded. The github reads "designed to synchronize web application state". But, what if I also have e.g. an Android app and would like to synchronize state with it also? Is that out of scope or something considered for the future? Edit: This issue seems promising: https://github.com/orbitinghail/sqlsync/issues/46

The reducer takes objects representing mutations and applies the appropriate changes to the state. It's called a reducer because it operates like a reduce/fold operation, in that if you take a given state and an ordered list of mutations, you'll end up with a new state out the other side, much like 'let newState = list.reduce(reducer, initialState)' would in JS. The reducer model is how Elm's state management works, and Redux's, and is what allow replaying of subsequent changes against a previous state to get to a current state (which enables, amongst other things, some the features of those systems' respective dev tools). The article links to the (nearly trivial) reducer for the todo example, which is on github here: https://github.com/orbitinghail/sqlsync/blob/ba762ce2a10afbb...

This is such solid feedback - and a frustration I have with offline first apps. In particular Obsidian sync has this problem which is made worse because it doesn't seem to want to sync in the background. (other than that I love Obsidian - just would be nice to get some more feedback) In regard to the TODO demo - I should totally add that. Thanks :) https://github.com/orbitinghail/sqlsync/issues/31

Yea, 100% agree. I'm starting to figure out what that looks like in this issue: https://github.com/orbitinghail/sqlsync/issues/19

It’s not exactly clear in the article, but there is a client part: https://github.com/orbitinghail/sqlsync/blob/main/GUIDE.md > Step 2: Install and configure the React library

Here's another local-first collaborative component: SQLSync [0]. "SQLSync is a collaborative offline-first wrapper around SQLite. It is designed to synchronize web application state between users, devices, and the edge." [0] https://github.com/orbitinghail/sqlsync