{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Database School","title":"From Prisma Founder to LiveStore: Building local-first apps with Johannes Schickling","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/408899d7\"></iframe>","width":"100%","height":180,"duration":5500,"description":"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.\n\nWe dive deep into event sourcing, syncing with SQLite, and why this approach might power the next generation of reactive apps.\n\n🔗 Links Mentioned\n\nWant to learn more about SQLite?\nCheck out my SQLite course:\nhttps://highperformancesqlite.com/?ref=yt\n\nLiveStore\nWebsite: https://livestore.dev\nRepo: https://github.com/livestorejs\nDiscord: https://discord.gg/RbMcjUAPd7\n\nFollow Johannes\nTwitter: https://www.x.com/schickling\nLinkedIn: https://www.linkedin.com/in/schickling\nWebsite: https://www.schickling.dev\nPodcast: https://www.localfirst.fm\n\nFollow Aaron\nTwitter: https://twitter.com/aarondfrancis\nLinkedIn: https://www.linkedin.com/in/aarondfrancis\nWebsite: https://aaronfrancis.com — find articles, podcasts, courses, and more\n\nDatabase School\nYouTube: https://www.youtube.com/playlist?list=PLI72dgeNJtzqElnNB6sQoAn2R-F3Vqm15\nAudio only: https://databaseschool.transistor.fm\n\n🕒 Chapters\n\n00:00 - Intro to Johannes\n01:00 - From Prisma to LiveStore\n03:00 - Discovering local-first through Riffle\n05:00 - What is local-first and who is it for?\n07:00 - Why local-first is gaining popularity\n10:00 - The inspiration from apps like Linear\n13:00 - Gaps in local-first tooling in 2020\n16:00 - Social apps vs. user-centric apps\n18:00 - Distributed systems and why they’re hard\n21:00 - The value of embracing local-first\n24:00 - What LiveStore is and what it’s not\n26:00 - Event sourcing as the core of LiveStore\n30:00 - Benefits of event sourcing for apps\n33:00 - Schema changes and time travel via events\n37:00 - Materializers and how they work\n43:00 - Syncing data across clients and devices\n48:00 - Sync servers and cross-tab communication\n54:00 - Architecture choices and dev tooling\n59:00 - State of the project and future vision\n1:06:00 - How to get involved","thumbnail_url":"https://img.transistorcdn.com/QPpKhRBWtM56k1sC7Y7j7aqGy8sd-XKWw6mEKgA1jmw/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9lMmRl/ZTM5ZTAxOTMzNTgy/MmJmZTA4MWE1ZjMw/YjE4Ny5wbmc.webp","thumbnail_width":300,"thumbnail_height":300}