3 ms·
I was exploring an interesting local-first component earlier today: cr-sqlite, which adds CRDTs to SQLite so you can have multiple databases that receive writes
by simonw 3y ago
I was exploring an interesting local-first component earlier today: cr-sqlite, which adds CRDTs to SQLite so you can have multiple databases that receive writes and then sync up and merge their changes later on.
My notes here: https://til.simonwillison.net/sqlite/cr-sqlite-macos https://til.simonwillison.net/sqlite/cr-sqlite-macos
- chii 3y agoOh that is very interesting. Thanks for writing it up for all to learn off! The internet is made better because you put in the effort!
- obeavs 3y agoThink you'd really enjoy exploring Electric SQL (https://electric-sql.com/blog/2023/08/14/introducing-electricsql-v0.5 https://electric-sql.com/blog/2023/08/14/introducing-electri...). They're syncing client-side SQLite to server-side Postgres on backend via an Erlang service that enables bi-directional active-active replication. They have a little more work to go until they solve the RLS concerns, but its been an incredible project to follow.
- rapnie 3y agoHere'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 https://github.com/orbitinghail/sqlsync
- steida 3y ago[dead]
- remram 3y agoYour comment is missing a disclaimer, dear author of evolu...
- tantaman 3y agoRecently put a video overview together of cr-sqlite and supporting libraries: https://youtu.be/T1ES9x8DKR4?si=Fo_4LIsKljm7Opal https://youtu.be/T1ES9x8DKR4?si=Fo_4LIsKljm7Opal