Sign inOpen the app
Syntax - Tasty Web Development Treats

797: Drizzle: The TypeScript SQL ORM

Jul 19, 2024 · 57 min
0:00-57:30

Streams straight from the publisher. podnod never proxies or re-hosts episode audio.

Open in podnod

Scott and Wes chat with Alex Blokh and Andrew Sherman, the co-founders of Drizzle ORM, about building a modern ORM from the ground up. They dive into the importance of type safety, creating filters with Drizzle, and the differences between Drizzle and other ORMs like Prisma.

Show Notes
  • 00:00 Welcome to Syntax!
  • 01:15 What is Drizzle?
  • 02:36 The genesis of Drizzle.
  • 04:15 The process of building an ORM.
  • 05:38 ‘100% Type-Safe’ and why that’s not a great goal.
  • 07:50 Who is responsible for writing the complicated TypeScript?
  • 09:40 Is an ORM necessary for anyone working with data?
  • 12:15 Creating a product that fits different complexities.
  • 13:19 Brought to you by Sentry.io.
  • 13:44 Creating filters in Drizzle. Callback-based, or imported. Why?
  • 19:22 Drizzle vs Prisma vs Kysely.
  • 22:45 Are you friendly with Prisma?
  • 23:35 Relational queries.
  • 25:17 Query vs select.
  • 27:42 Maintaining so many different technologies.
  • 30:37 Switching databases.
  • 31:39 Drizzle Studio.
  • 35:00 Accessing Cloudflare D1 SQLite requires connection through a worker.
  • 37:40 Drizzle Kit.
  • 41:37 Will you ever support MongoDB?
  • 42:10 Supporting PGlite and local data storage landscape.
  • 44:00 Being a developer in Ukraine in 2024.
  • 51:07 Drizzle is expanding.
  • 53:50 Sick Picks + Shameless Plugs.
Sick Picks

Andrew - Smart Swim Goggles.

Shameless Plugs

Andrew - Savelife, United24. Scott - Syntax × Drizzle Swag.

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