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)

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

Suosittua kategoriassa Koulutus

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