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

Syntax - Tasty Web Development Treats

Oct 25, 2024•55 min

--:--

Listen in podcast apps:

Apple Podcasts

Spotify

Download

Listen to this episode in Metacast mobile app

Don't just listen to podcasts. Learn from them with transcripts, summaries, and chapters for every episode. Skim, search, and bookmark insights. Learn more

Episode description

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.

Show Notes

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

Sick Picks

Søren: Cursor

Shameless Plugs

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

Hit us up on Socials!

Syntax: X Instagram Tiktok LinkedIn Threads

Wes: X Instagram Tiktok LinkedIn Threads

Scott: X Instagram Tiktok LinkedIn Threads

Randy: X Instagram YouTube Threads

For the best experience, listen in Metacast app for iOS or Android