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)

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
psykopodiaa-podcast
voi-hyvin-meditaatiot-2
rss-narsisti
rss-niinku-asia-on
adhd-podi
rss-liian-kuuma-peruna
aamukahvilla
psykologia
rss-valo-minussa-2
rss-vapaudu-voimaasi
kesken
rss-koira-haudattuna
aloita-meditaatio
dear-ladies
esa-saarinen-filosofia-ja-systeemiajattelu
ihminen-tavattavissa-tommy-hellsten-instituutti
leveli
rss-luonnollinen-synnytys-podcast
filocast-filosofian-perusteet