Building a serverless database replica with Carl Sverre
Database School18 Huhti 2025

Building a serverless database replica with Carl Sverre

Want to learn more SQLite? Check out my SQLite course: https://highperformancesqlite.com

In this episode, Carl Sverre and I discuss why syncing everything is a bad idea and how his new project, Graft, makes edge-native, partially replicated databases possible. We dig into SQLite, object storage, transactional guarantees, and why Graft might be the foundation for serverless database replicas.

SQLSync: https://sqlsync.dev
Stop syncing everything blog post: https://sqlsync.dev/posts/stop-syncing-everything
Graft: https://github.com/orbitinghail/graft

Follow Carl:
Twitter: https://twitter.com/carlsverre
LinkedIn: https://www.linkedin.com/in/carlsverre
Website: https://carlsverre.com/

Follow Aaron: Twitter: https://twitter.com/aarondfrancis
LinkedIn: https://www.linkedin.com/in/aarondfrancis
Website: https://aaronfrancis.com - find articles, podcasts, courses, and more.

Database school on YouTube: https://www.youtube.com/playlist?list=PLI72dgeNJtzqElnNB6sQoAn2R-F3Vqm15
Database school audio only: https://databaseschool.transistor.fm

Chapters: 00:00 - Intro and Carl’s controversial blog title
01:00 - Why “stop syncing everything” doesn't mean stop syncing
02:30 - The problem with full database syncs
03:20 - Quick recap of SQL Sync and multiplayer SQLite
04:45 - How SQL Sync works using physical replication
06:00 - The limitations that led to building Graft
09:00 - What is Graft? A high-level overview
16:30 - Syncing architecture: how Graft scales
18:00 - Graft's stateless design and Fly.io integration
20:00 - S3 compatibility and using Tigris as backend
22:00 - Latency tuning and express zone support
24:00 - Can Graft run locally or with Minio?
27:00 - Page store vs meta store in Graft
36:00 - Index-aware prefetching in SQLite
38:00 - Prefetching intelligence: Graft vs driver
40:00 - The benefits of Graft's architectural simplicity
48:00 - Three use cases: apps, web apps, and replicas
50:00 - Sync timing and perceived latency
59:00 - Replaying transactions vs logical conflict resolution
1:03:00 - What’s next for Graft and how to get involved
1:05:00 - Hacker News reception and blog post feedback
1:06:30 - Closing thoughts and where to find Carl

Jaksot(30)

A million transactions per second: building TigerBeetle with Joran Greef

A million transactions per second: building TigerBeetle with Joran Greef

In this episode, Aaron talks with Joran Greef, CEO and creator of TigerBeetle, the world’s first financial transactions database. Joran takes us on a deep dive of on how TigerBeetle brings double-entr...

23 Loka 20251h 28min

PlanetScale Postgres with CEO Sam Lambert

PlanetScale Postgres with CEO Sam Lambert

Sam Lambert, my former boss at PlanetScale, talks to me about PlanetScale moving from a MySQL company to now also having a Postgres offering. Sam shares why PlanetScale decided to move to Postgres, ho...

22 Syys 20251h 6min

The database for all your AI needs

The database for all your AI needs

Marcel Kornacker, the creator of Apache Impala and co-creator of Apache Parquet, joins me to talk about his latest project: Pixeltable, a multimodal AI database that combines structured and unstructur...

16 Syys 20251h

Sharding Postgres without extensions with PgDog founder, Lev Kokotov

Sharding Postgres without extensions with PgDog founder, Lev Kokotov

I chat with Lev Kokotov to talk about building PgDog, an open-source sharding solution for Postgres that sits outside the database. Lev shares the journey from creating PgCat to launching PgDog throug...

19 Elo 202548min

Rewriting SQLite from scratch (yes, really)

Rewriting SQLite from scratch (yes, really)

Want to learn more about SQLite?  Check out my course on SQLite: https://highperformancesqlite.com/?ref=yt  In this episode of Database School, I chat with Glauber Costa, CEO of Turso, about their aud...

8 Elo 20251h 17min

Vitess for Postgres, with the co-founder of PlanetScale

Vitess for Postgres, with the co-founder of PlanetScale

Sugu Sougoumarane, co-creator of Vitess and co-founder of PlanetScale, joins me to talk about his time scaling YouTube’s database infrastructure, building Vitess, and his latest project bringing shard...

1 Heinä 20251h 7min

PlanetScale Metal

PlanetScale Metal

In this episode, I chat with Richard Crowley from PlanetScale about their new offering: PlanetScale Metal.We dive deep into the performance and reliability trade-offs of EBS vs. locally attached NVMe ...

27 Kesä 202550min

From Prisma Founder to LiveStore: Building local-first apps with Johannes Schickling

From Prisma Founder to LiveStore: Building local-first apps with Johannes Schickling

Johannes Schickling, original founder of Prisma, joins me to talk about LiveStore, his ambitious local-first data layer designed to rethink how we build apps from the data layer up.We dive deep into e...

29 Touko 20251h 31min

Suosittua kategoriassa Koulutus

rss-murhan-anatomia
voi-hyvin-meditaatiot-2
psykopodiaa-podcast
adhd-podi
rss-narsisti
psykologia
kesken
rahapuhetta
rss-niinku-asia-on
rss-vapaudu-voimaasi
rss-liian-kuuma-peruna
rss-duodecim-lehti
rss-luonnollinen-synnytys-podcast
rss-tietoinen-yhteys-podcast-2
aamukahvilla
rss-uskonto-on-tylsaa
rss-valo-minussa-2
rss-honest-talk-with-laurrenna
rss-opeklubi
rss-psykalab