Offline-first, multiplayer SQLite
Description
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: https://highperformancesqlite.com/products/sqlite-reference-guide Follow Aaron: Twitter: https://twitter.com/aarondfrancis LinkedIn: https://www.linkedin.com/in/aarondfrancis Website: https://aaronfrancis.com - find articles, podcasts, courses, and more. Follow Carl: Carl: https://twitter.com/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: https://www.youtube.com/playlist?list=PLI72dgeNJtzqElnNB6sQoAn2R-F3Vqm15 Database school audio only: https://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
25:36Build an Offline-First SwiftUI App with SwiftData (Works Without Internet!)iOS Insights61 views
4:07How Do Apps Work Offline? The Copy Living in Your PhoneNIMAX DevOps5 views
5:15How to Use Windows 10 AFTER Microsoft Kills ItTechquickie275K views
10:43Local-First Software: Taking Back Control of Our Data | a mini-docCultRepo 109K views
9:18This Free Offline Server Just Got a Massive UpgradeCrosstalk Solutions80.3K views
40:41BOB 2022 Ragnar Mogk - Local-first Distributed ApplicationsBOBKonf103 views
25:26You Should Try Linux For Ham Radio TODAY!Ham Radio Crash Course55.5K views
4:24Offline Mobile App using CaspioWorkMovr - Caspio Developers 37 views
31:31How to Setup a Raspberry Pi LEARNING Desktop (Linux, Hacking, Coding)NetworkChuck1.5M views
3:01Why Your Apps Still Work Offline.DEV-WRAP20 views
17:13Testing my Smart Home with NO internet!Smart Home Solver136K views
31:59How to Make a SwiftUI App Work Offline (No Internet Required!)”iOS Insights41 views
1:03:13Offline First Architecture - Android Developers Office HoursAndroid Developers7.6K views
32:56Mobile System Design | Offline-First TODO App : HLD-LLD ExplainedRahul Ray9.9K views