Database School Building a serverless database replica with Carl Sverre
7 snips
Apr 18, 2025 Carl Sverre, the creator of SQLSync and Graft, delves into the world of edge-native, partially replicated databases. He argues that syncing everything isn’t efficient and unveils Graft's innovative approach to optimize data transfer. The discussion covers the challenges of traditional database synchronization, the groundbreaking features of SQL Sync, and how Graft's architecture scales effectively. Full of insights on transactional guarantees and caching performance, this conversation highlights the future of serverless database replicas and efficient data retrieval.
AI Snips
Chapters
Transcript
Episode notes
Selective Syncing Beats Syncing Everything
- Syncing all data everywhere is inefficient and doesn't scale well for web or edge-native databases.
- Selective, partial syncing tailored to client needs drastically improves performance and resource usage.
Lessons from SQL Sync's Physical Replication
- SQL Sync replicates entire SQLite database files physically to multiple clients for collaboration.
- This approach worked but revealed limits in scaling and efficiency during real-world use.
Graft Bridges Object Storage & Transactions
- Graft layers on top of object storage to enable efficient small writes and partial replication.
- It transforms object storage to support transactional workloads unsuitable for naive object storage use.