839: Prisma ORM: Local First, Typed SQL Queries and Serverless with Søren Bramer Schmidt

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