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

29/05/2025 1h 31min Episodio 15
From Prisma Founder to LiveStore: Building local-first apps with Johannes Schickling

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

Episode Synopsis


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 MentionedWant to learn more about SQLite?Check out my SQLite course:https://highperformancesqlite.com/?ref=ytLiveStoreWebsite: https://livestore.devRepo: https://github.com/livestorejsDiscord: https://discord.gg/RbMcjUAPd7Follow JohannesTwitter: https://www.x.com/schicklingLinkedIn: https://www.linkedin.com/in/schicklingWebsite: https://www.schickling.devPodcast: https://www.localfirst.fmFollow AaronTwitter: https://twitter.com/aarondfrancisLinkedIn: https://www.linkedin.com/in/aarondfrancisWebsite: https://aaronfrancis.com — find articles, podcasts, courses, and moreDatabase SchoolYouTube: https://www.youtube.com/playlist?list=PLI72dgeNJtzqElnNB6sQoAn2R-F3Vqm15Audio only: https://databaseschool.transistor.fm🕒 Chapters00:00 - Intro to Johannes01:00 - From Prisma to LiveStore03:00 - Discovering local-first through Riffle05:00 - What is local-first and who is it for?07:00 - Why local-first is gaining popularity10:00 - The inspiration from apps like Linear13:00 - Gaps in local-first tooling in 202016:00 - Social apps vs. user-centric apps18:00 - Distributed systems and why they’re hard21:00 - The value of embracing local-first24:00 - What LiveStore is and what it’s not26:00 - Event sourcing as the core of LiveStore30:00 - Benefits of event sourcing for apps33:00 - Schema changes and time travel via events37:00 - Materializers and how they work43:00 - Syncing data across clients and devices48:00 - Sync servers and cross-tab communication54:00 - Architecture choices and dev tooling59:00 - State of the project and future vision1:06:00 - How to get involved