From Prisma Founder to LiveStore: Building local-first apps with Johannes Schickling
Database School29 Touko 2025

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 event sourcing, syncing with SQLite, and why this approach might power the next generation of reactive apps.


🔗 Links Mentioned


Want to learn more about SQLite?

Check out my SQLite course:

https://highperformancesqlite.com/?ref=yt


LiveStore

Website: https://livestore.dev

Repo: https://github.com/livestorejs

Discord: https://discord.gg/RbMcjUAPd7


Follow Johannes

Twitter: https://www.x.com/schickling

LinkedIn: https://www.linkedin.com/in/schickling

Website: https://www.schickling.dev

Podcast: https://www.localfirst.fm


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

YouTube: https://www.youtube.com/playlist?list=PLI72dgeNJtzqElnNB6sQoAn2R-F3Vqm15

Audio only: https://databaseschool.transistor.fm


🕒 Chapters


00:00 - Intro to Johannes

01:00 - From Prisma to LiveStore

03:00 - Discovering local-first through Riffle

05:00 - What is local-first and who is it for?

07:00 - Why local-first is gaining popularity

10:00 - The inspiration from apps like Linear

13:00 - Gaps in local-first tooling in 2020

16:00 - Social apps vs. user-centric apps

18:00 - Distributed systems and why they’re hard

21:00 - The value of embracing local-first

24:00 - What LiveStore is and what it’s not

26:00 - Event sourcing as the core of LiveStore

30:00 - Benefits of event sourcing for apps

33:00 - Schema changes and time travel via events

37:00 - Materializers and how they work

43:00 - Syncing data across clients and devices

48:00 - Sync servers and cross-tab communication

54:00 - Architecture choices and dev tooling

59:00 - State of the project and future vision

1:06:00 - How to get involved

Jaksot(30)

Infinite, shareable volume storage with Hunter Leath, Archil CEO

Infinite, shareable volume storage with Hunter Leath, Archil CEO

Hunter Leath, CEO of Archil, explains how they’re building a “universal storage engine” that sits between your apps and S3—making an S3 bucket behave like a fast, POSIX-compatible disk for containers,...

15 Tammi 55min

Building search for AI systems with Chroma CTO Hammad Bashir

Building search for AI systems with Chroma CTO Hammad Bashir

Hammad Bashir, CTO of Chroma, joins the show to break down how modern vector search systems are actually built from local, embedded databases to massively distributed, object-storage-backed architectu...

18 Joulu 20251h 6min

Scaling DuckDB in the cloud with MotherDuck CEO Jordan Tigani

Scaling DuckDB in the cloud with MotherDuck CEO Jordan Tigani

In this episode of Database School, Aaron Francis sits down with Jordan Tigani, co-founder and CEO of MotherDuck, to break down what DuckDB is, how MotherDuck hosts it in the cloud, and why analytics ...

11 Joulu 20251h 5min

Just use Postgres with Denis Magda

Just use Postgres with Denis Magda

In this episode, Aaron talks with Dennis Magda, author of Just Use Postgres!, about the wide world of modern Postgres, from JSON and full-text search to generative AI, time-series storage, and even me...

4 Joulu 20251h 7min

Strictly typed SQL with Contra CTO, Gajus Kuizinas

Strictly typed SQL with Contra CTO, Gajus Kuizinas

In this episode, Gajus Kuizinas, co-founder and CTO of Contra, joins Aaron to talk about building the engineering world you want to live in, from strict runtime-validated SQL with Slonik to creating h...

20 Marras 202559min

Building serverless vector search with Turbopuffer CEO, Simon Eskildsen

Building serverless vector search with Turbopuffer CEO, Simon Eskildsen

In this episode, Aaron Francis talks with Simon Eskildsen, co-founder and CEO of TurboPuffer, about building a high-performance search engine and database that runs entirely on object storage. They di...

13 Marras 20251h 6min

Building an S3 Competitor with Tigris CEO Ovais Tariq

Building an S3 Competitor with Tigris CEO Ovais Tariq

Aaron talks with Ovais Tariq, co-founder and CEO of Tigris Data and former Uber engineer who helped scale one of the world’s largest distributed systems. They discuss Uber’s hyperscale infrastructure,...

6 Marras 20251h 7min

Rewriting SQLite from prison with Preston Thorpe

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

30 Loka 20251h 18min

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