Database School Offline-first, multiplayer SQLite
Jun 13, 2024
Carl Sverre, developer of SQLSync, discusses event sourcing, conflict resolution, VFSes, and more in the podcast. They cover multiplayer SQLite, durable objects, local-first approach, conflict resolution as business logic, and the future goals for SQLSync.
AI Snips
Chapters
Transcript
Episode notes
Carl's background
- Carl Sverre worked at SingleStore for 10 years, where he was known as the "mad scientist".
- His last project involved adding WebAssembly to SingleStore for database extensibility.
SQLSync Goals
- SQLSync simplifies creating multiplayer web apps that need a relational data model.
- It aims to make multiplayer implementation easier to reason about and keep it SQL-centric.
PartyKit vs SQLSync
- PartyKit offers a transport layer for multiplayer, providing a session backend for clients to connect and exchange messages.
- SQLSync uses Cloudflare Durable Objects, similar to PartyKit, for its infrastructure.