localfirst.fm #10 – Matt Wonlaw: cr-sqlite, syncing strategies and incremental view maintenance
32 snips
Jun 12, 2024 
Matt Wonlaw, a local-first tool builder, discusses CRDTs, SQLite, and incremental view maintenance. Topics include software dev for submarines, event sourcing, CR SQLite, challenges of SQLite in browsers, Materialite, and data modeling for multiplayer apps.
AI Snips
Chapters
Transcript
Episode notes
Submarine Software
- Matt Wonlaw's first job involved building software for submarines, demanding a local-first approach due to the lack of internet connectivity.
- The software needed to store the last 24 hours of data to function even if all servers failed, highlighting resilience.
Event Sourcing's Relevance
- Event sourcing, a pattern used in submarine software, remains relevant in local-first development.
- It involves logging all events, enabling replay and merging of changes after reconnection.
Resurrecting Strut.io
- Matt initially built Strut.io, a local-first presentation editor, to operate offline without accounts.
- Resurrecting it after Facebook, he aimed to add multiplayer and syncing due to evolving user expectations.