Offline-first, multiplayer SQLite

Want to learn more SQLite? Check out the full course: https://highperformancesqlite.com.

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!

Get production ready SQLite with Turso: https://tur.so/af.

Follow Aaron:
Twitter:   / aarondfrancis  
LinkedIn:   / aarondfrancis  
Website: https://aaronfrancis.com - find articles, podcasts, courses, and more.

Follow Carl:
Carl:   / carlsverre  
Carl's new company: https://orbitinghail.dev

Featured in this episode:
PartyKit: https://www.partykit.io
SQLSync: https://sqlsync.dev
Database school on YouTube:    • Database School  
Database school audio only: https://databaseschool.transistor.fm/

Chapters:
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