797: Drizzle: The TypeScript SQL ORM
Update: 2024-07-19
Description
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 ">00:00 Welcome to Syntax!
- 01:15 ">01:15 What is Drizzle?
- 02:36 ">02:36 The genesis of Drizzle.
- 04:15 ">04:15 The process of building an ORM.
- 05:38 ">05:38 ‘100% Type-Safe’ and why that’s not a great goal.
- 07:50 ">07:50 Who is responsible for writing the complicated TypeScript?
- 09:40 ">09:40 Is an ORM necessary for anyone working with data?
- 12:15 ">12:15 Creating a product that fits different complexities.
- 13:19 ">13:19 Brought to you by Sentry.io.
- 13:44 ">13:44 Creating filters in Drizzle. Callback-based, or imported. Why?
- 19:22 ">19:22 Drizzle vs Prisma vs Kysely.
- 22:45 ">22:45 Are you friendly with Prisma?
- 23:35 ">23:35 Relational queries.
- 25:17 ">25:17 Query vs select.
- 27:42 ">27:42 Maintaining so many different technologies.
- 30:37 ">30:37 Switching databases.
- 31:39 ">31:39 Drizzle Studio.
- 35:00 ">35:00 Accessing Cloudflare D1 SQLite requires connection through a worker.
- 37:40 ">37:40 Drizzle Kit.
- 41:37 ">41:37 Will you ever support MongoDB?
- 42:10 ">42:10 Supporting PGlite and local data storage landscape.
- 44:00 ">44:00 Being a developer in Ukraine in 2024.
- 51:07 ">51:07 Drizzle is expanding.
- 53:50 ">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
Comments
Top Podcasts
The Best New Comedy Podcast Right Now – June 2024The Best News Podcast Right Now – June 2024The Best New Business Podcast Right Now – June 2024The Best New Sports Podcast Right Now – June 2024The Best New True Crime Podcast Right Now – June 2024The Best New Joe Rogan Experience Podcast Right Now – June 20The Best New Dan Bongino Show Podcast Right Now – June 20The Best New Mark Levin Podcast – June 2024
In Channel