Exploring Local First Technology: Enhancing User Experience and Developer Efficiency

Scott and Wes talk with Søren Bramer Schmidt, Founder and CEO of Prisma, about database best practices, including the latest developments in serverless, local-first, and typed SQL solutions.

• 00:00 Welcome to Syntax!
• 02:55 Søren’s thoughts on GraphQL
• 03:53 Brought to you by Sentry.io
• 06:57 Common database mistakes
• 08:52 Prisma’s stability and user experience
• 10:42 Typed SQL and advanced querying
  • Announcing TypedSQL: Make your raw SQL queries type-safe with Prisma ORM
  • Prisma Optimize
• 20:47 Serverless challenges and solutions
  • Prisma Accelerate
• 27:11 Cloudflare’s potential to dethrone AWS
• 29:13 Prisma and local-first development
  • Prisma & Expo: A Better Path to Local-First Apps | App.js Conf 2024
• 35:30 Making local-first development mainstream
• 40:10 Challenges with async
• 42:43 Søren’s thoughts on Drizzle
• 43:41 Søren’s favorite database
• 47:21 The read your writes problem
• 48:58 Prisma hosted Postgres
• 51:44 Sick Picks & Shameless Plugs

• Søren: Cursor

• Søren:
  • 1: Prisma Optimize
  • 2: Prisma Postgres (coming soon)

Syntax: X Instagram Tiktok LinkedIn Threads

Wes: X Instagram Tiktok LinkedIn Threads

Scott: X Instagram Tiktok LinkedIn Threads

Randy: X Instagram YouTube Threads