#10 – Matt Wonlaw: cr-sqlite, syncing strategies and incremental view maintenance

The guest of this episode is Matt Wonlaw, a prolific local-first tool builder who’s behind projects such as Vlcn, cr-sqlite and Materialite. Most recently Matt also joined Rocicorp to work on their new product. This conversation will go deep on his projects covering CRDTs, SQLite and incremental view maintenance. 00:00 Intro 02:26 Lockheed Martin 05:25 Meta 08:24 CR-SQLite 11:14 Strut.io 16:29 Choosing the right CRDT 26:05 Challenges 39:57 Materialite 50:12 Rocicorp 53:25 Picking the right tool 01:01:51 Outro Mentioned in podcast Matt Wonlaw: https://x.com/tantaman + https://github.com/tantaman RemoteStorage: https://remotestorage.io ownCloud: https://owncloud.com The Virtual Table Mechanism Of SQLite: https://www.sqlite.org/vtab.html Towards a General Database Management System of Conflict-Free Replicated Relations: https://munin.uit.no/handle/10037/22344 Materialite benchmark: https://observablehq.com/@tantaman/ma... Links: Website: https://localfirst.fm X/Twitter: https://x.com/localfirstfm Local-First Conf 2024: https://www.localfirstconf.com Thank you to https://expo.dev/ and https://rocicorp.dev/ for supporting the podcast