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
Watch video Offline-first, multiplayer SQLite online without registration, duration hours minute second in high quality. This video was added by user Aaron Francis 10 June 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 14,593 once and liked it 430 people.