Rewriting SQLite from prison with Preston Thorpe
Database School30 Loka 2025

Rewriting SQLite from prison with Preston Thorpe

In this episode of Database School, Aaron talks with Preston Thorpe, a senior engineer at Turso who is currently incarcerated, about his incredible journey from prison to rewriting SQLite in Rust. They dive deep into concurrent writes, MVCC, and the challenges of building a new database from scratch while discussing redemption, resilience, and raw technical brilliance.

Follow Preston and Turso:
LinkedIn: https://www.linkedin.com/in/PThorpe92
Preston's Blog: https://pthorpe92.dev
GitHub: https://github.com/PThorpe92
Turso: https://turso.tech

Follow Aaron:
Twitter/X: https://twitter.com/aarondfrancis
Database School: https://databaseschool.com
Database School YouTube Channel: https://www.youtube.com/@UCT3XN4RtcFhmrWl8tf_o49g (Subscribe today)
LinkedIn: https://www.linkedin.com/in/aarondfrancis
Website: https://aaronfrancis.com - find articles, podcasts, courses, and more.

Chapters:
00:00 - Intro and Preston’s story
02:13 - How Preston learned programming in prison
06:06 - Making his parents proud and turning life around
09:01 - Getting his first job at Unlock Labs
10:47 - Discovering Turso and contributing to open source
12:53 - From contributor to senior engineer at Turso
22:27 - What Preston works on inside Turso
24:00 - Challenges of rewriting SQLite in Rust
26:00 - Why concurrent writes matter
27:57 - How Turso implements concurrent writes
35:02 - Maintaining SQLite compatibility
37:03 - MVCC explained simply
43:40 - How Turso handles MVCC and logging
46:03 - Open source contributions and performance work
46:23 - Implementing live materialized views
50:55 - The DBSP paper and incremental computation
52:55 - Sync and offline capabilities in Turso
56:45 - Change data capture and future possibilities
1:02:01 - Implementing foreign keys and fuzz testing
1:06:02 - Rebuilding SQLite’s virtual machine
1:08:10 - The quirks of SQLite’s codebase
1:10:47 - Preston’s upcoming release and what’s next
1:14:02 - Gratitude, reflection, and closing thoughts

Jaksot(30)

How Durable Objects and D1 Work: A Deep Dive with Cloudflare’s Josh Howard

How Durable Objects and D1 Work: A Deep Dive with Cloudflare’s Josh Howard

Josh Howard, Senior Engineering Manager at Cloudflare, joins me to explain how Durable Objects and D1 work under the hood—and why Cloudflare’s approach to stateful serverless infrastructure is so uniq...

14 Touko 20251h 14min

20 years of hacking Postgres with Heikki Linnakangas (cofounder of Neon)

20 years of hacking Postgres with Heikki Linnakangas (cofounder of Neon)

In this episode of Database School, I talk with Heikki Linnakangas, co-founder of Neon and longtime PostgreSQL hacker, to talk about 20+ years in the Postgres community, the architecture behind Neon, ...

6 Touko 20252h

Building a serverless database replica with Carl Sverre

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,...

18 Huhti 20251h 28min

Postgres on bare metal with the CEO of Prisma

Postgres on bare metal with the CEO of Prisma

Prisma started as a GraphQL backend and pivoted into one of the most widely used ORMs in the world. Now, they’ve launched Prisma Postgres, and CEO Søren Bramer Schmidt is here to break down the journe...

17 Helmi 20251h 24min

Moving from Redis to SQLite with Mike Buckbee

Moving from Redis to SQLite with Mike Buckbee

Want to learn more SQLite? Check out my SQLite course: https://highperformancesqlite.com In this episode, I sit down with Mike Buckbee to dive into the nitty-gritty of web application firewalls and hi...

26 Marras 20241h 9min

Bootstrapping an email service provider (with Jesse Hanley)

Bootstrapping an email service provider (with Jesse Hanley)

Want to learn more Postgres? Check out my Postgres course: https://masteringpostgres.com. In this interview, I talk with Jesse Hanley, founder of Bento, about running a lean email service from Japan. ...

14 Loka 20241h 21min

Creating a Postgres platform with Monica & Tudor from Xata.io

Creating a Postgres platform with Monica & Tudor from Xata.io

Want to learn more Postgres? Check out my Postgres course: https://masteringpostgres.com. Production ready Postgres for teams that ship fast: https://xata.io In this interview, I talk with Monica Sarb...

7 Loka 20241h 1min

Heroku's glory days & Postgres vs the world, w/ Craig Kerstiens

Heroku's glory days & Postgres vs the world, w/ Craig Kerstiens

Want to learn more Postgres? Check out my Postgres course: https://masteringpostgres.com. In this interview, I dive deep with Craig Kerstiens from Crunchy Data into the world of Postgres, covering its...

24 Syys 20241h 2min

Suosittua kategoriassa Koulutus

rss-murhan-anatomia
voi-hyvin-meditaatiot-2
psykopodiaa-podcast
adhd-podi
rss-narsisti
rss-rahamania
rahapuhetta
rss-liian-kuuma-peruna
kesken
rss-uskonto-on-tylsaa
rss-vapaudu-voimaasi
rss-niinku-asia-on
rss-tietoinen-yhteys-podcast-2
aloita-meditaatio
salainen-paivakirja
esa-saarinen-filosofia-ja-systeemiajattelu
filocast-filosofian-perusteet
rss-valo-minussa-2
rss-koira-haudattuna
rss-hereilla