In this episode, Scott and Wes dive into the world of local-first apps with Johannes Schickling, the mastermind behind Prisma. From databases, WASM for non-JS, to authentication challenges, they explore the ins and outs of crafting apps that prioritize local functionality. Show Notes 00:00 Welcome to Syntax! 01:10 Brought to you by . 01:28 What is Overtone? 03:45 Can you explain the experience you're trying to achieve? 06:43 What makes the best music app? Is it local first? 08:03 Is it best to create a local first app from the ground up? 10:31 What are the considerations when making a local first app? 13:04 What database are you using? 16:12 How do you handle authentication? 19:15 Pick the tech based on the problem. 20:40 WASM for Non-JS or heavy lifting tasks. 24:39 How did you get SQLite running in the browser? 27:58 What about WA-SQLite, how does it compare to Riffle? 29:24 The backstory of Effect for TypeScript. 34:04 What actually is Effect? 39:32 Consolidating tools. 42:30 What's a cool aspect of Effect that is often overlooked? 45:47 Building a web server with this. 48:16 Will this ever get "Bluebirded"? 50:29 What about promises? 52:19 Sick Picks + Shameless Plugs. All links available at ------------------------------------------------------------------------------ Hit us up on Socials! Scott: Wes: Randy: @randyrektor Syntax: Brought to you by #webdevelopment #webdeveloper #javascript