Pirijan Ketheswaran, creator of Kinopio and co-creator of Glitch, discusses his journey as a solo developer, sharing insights on building offline apps, the importance of a local-first approach, and the collaborative features of Kinopio. He explores the technical architecture of Kinopio, challenges faced in building Canopio, and the benefits of understanding different disciplines in product development.

In this episode, James Long, creator of Actual Budget and Absurd-SQL, discusses building Actual Budget, implementing syncing solutions, transitioning to different platforms, and bringing SQLite to the browser. Topics include using SQLite in Electron apps, collaboration in local-first apps, challenges in desktop-mobile app integration, and navigating async issues in WebAssembly. The conversation also explores the evolution of web development, programming models, and the role of React.

Rasmus Andersson, a key contributor to Spotify, Dropbox, and Figma, discusses software quality, data model trade-offs, and the web's role in modern applications. The conversation delves into the evolution of local-first software, challenges in user experience design, and the development of Playbit, an operating system focused on joyful coding experiences.

Kyle Matthews discusses the benefits of using a sync engine for building local-first apps, talks about his experiences in developing personal apps, and explores the challenges and advantages of adopting new technology in the app development space.

Exploring CRDTs, Automerge, and generic syncing servers with Martin Kleppmann. Discussing the future impact on local-first software. Transition from JSON CRDT paper to Auto Merge. Evolution and future enhancements of Auto Merge. Peer-to-peer syncing and transition to local-first software. Evolution of local-first technology and user control over data. Impact of local-first computing on niche use cases.

Guest Geoffrey Litt discusses malleable software and how relational databases can improve web apps and data ownership. They explore unifying UI states and app data, the concept of Riffle, trade-offs of using SQLite in TypeScript, schema management challenges, and introduce LiveStore as a solution.

Aaron Boodman, Google Gears developer and local-first expert, discusses his journey in local-first software, advancements in web app building and storage challenges, implementation of Replica Hash, using Next JS for websites and Vee for web apps, replicas and Reflect in a React app, and the concept of local first and its collaboration capabilities.

Peter van Hardenberg, director of the Ink & Switch Research Lab, discusses the concept of Local First software, its limitations, and suitability for different applications. They explore the role of peer-to-peer technology, potential of local-first software, and cross-app collaboration. The chapter delves into the benefits of this approach, examples of successful implementation, and available technologies. The podcast emphasizes the importance of having data live on the user's device.