Uploaded June 2024 | Updated September 2026, 1 hour ago
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 your free SQLite reference guide: highperformancesqlite.com/products/sqlite-reference-guide
Follow Aaron:
Twitter: twitter.com/aarondfrancis
LinkedIn: linkedin.com/in/aarondfrancis
Website: aaronfrancis.com - find articles, podcasts, courses, and more.
Follow Carl:
Carl: twitter.com/carlsverre
Carl's new company: https://orbitinghail.dev
Featured in this episode:
PartyKit: partykit.io
SQLSync: https://sqlsync.dev
Database school on YouTube: youtube.com/playlist?list=PLI72dgeNJtzqElnNB6sQoAn2R-F3Vqm15
Database school audio only: databaseschool.com
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
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 your free SQLite reference guide: highperformancesqlite.com/products/sqlite-reference-guide
Follow Aaron:
Twitter: twitter.com/aarondfrancis
LinkedIn: linkedin.com/in/aarondfrancis
Website: aaronfrancis.com - find articles, podcasts, courses, and more.
Follow Carl:
Carl: twitter.com/carlsverre
Carl's new company: https://orbitinghail.dev
Featured in this episode:
PartyKit: partykit.io
SQLSync: https://sqlsync.dev
Database school on YouTube: youtube.com/playlist?list=PLI72dgeNJtzqElnNB6sQoAn2R-F3Vqm15
Database school audio only: databaseschool.com
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
