Some notes on local-first development

Re:Some notes on local-first development by simonw on Tuesday September 12, 2023 @09:56PM (#37491263)

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

[ Parent | on HN ]

Re:Some notes on local-first development by chii on Tuesday September 12, 2023 @10:44PM (#37491596)

Oh 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!

[ Parent | on HN ]

Re:Some notes on local-first development by obeavs on Tuesday September 12, 2023 @11:42PM (#37491925)

Think you'd really enjoy exploring Electric SQL (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.

[ Parent | on HN ]

Re:Some notes on local-first development by rapnie on Wednesday September 13, 2023 @12:31AM (#37492202)

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

[ Parent | on HN ]

Re:Some notes on local-first development by steida on Wednesday September 13, 2023 @05:31AM (#37494378)

Have you seen https://github.com/evoluhq/evolu? What do you think?

[ Parent | on HN ]

Re:Some notes on local-first development by remram on Wednesday September 13, 2023 @07:42AM (#37495420)

Your comment is missing a disclaimer, dear author of evolu...

[ Parent | on HN ]

Re:Some notes on local-first development by tantaman on Wednesday September 13, 2023 @06:22AM (#37494803)

Recently put a video overview together of cr-sqlite and supporting libraries: https://youtu.be/T1ES9x8DKR4?si=Fo_4LIsKljm7Opal

[ Parent | on HN ]