Want to learn more about SQLite? Check out the full course:
https://highperformancesqlite.com. Get production ready SQLite with Turso:
https://tur.so/af.
In this interview I talk to Carl Sverre about his new project: SQLSync. It's an offline-first, collaborative wrapper around SQLite. We cover event sourcing, conflict resolution, VFSes, and more! Carl: https://twitter.com/carlsverre PartyKit: https://www.partykit.io SQLSync: https://sqlsync.dev Carl's new company: https://orbitinghail.dev -------
00:00 Intro and Background
01:56 What is SQLSync 02:30 Amplify
05:08 SQLSync Use Case
07:35 Multiplayer Explained
09:41 Durable Objects
12:00 Compare to PartyKit
13:08 Local First
22:46 SQLSync Terminology
24:28 SQLSync Replication Flow
27:33 Virtual File System
33:51 Transactions in WASM
39:41 Sync to Coordinator
43:22 Conflict Resolution as Business Logic
52:03 Sync to Clients
1:01:12 Goals for SQLSync
1:04:14 Scaling Limitations
1:07:30 Graft Storage Engine
1:14:47 Graft as a SQLite Extension
1:17:08 What's Next -----