797: Drizzle: The TypeScript SQL ORM
Syntax - Tasty Web Development Treats
Wes Bos
4.9 • 1.1K Ratings
🗓️ 19 July 2024
⏱️ 58 minutes
🧾️ Download transcript
Summary
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
Transcript
Click on a timestamp to play from that location
| 0:00.0 | Welcome to Syntax. Today we've got two of the devs on from Drizzle. We're really excited about this both because a big fan of Drizzle myself. |
| 0:09.4 | Drizzle is a TypeScript ORM for several databases. |
| 0:13.6 | We'll talk all about that in just a sec, |
| 0:15.2 | but also look at these cool t-shirts. |
| 0:19.4 | We are launching this new thing on syntax, which is sort of like collaborations with open source projects |
| 0:26.0 | and part of it is like we're trying to figure out like like how do we do cool stuff |
| 0:30.0 | but also like support open source projects |
| 0:32.0 | so this drizzle |
| 0:33.4 | shout out to drizzle because they were like one of the first to sign on like yeah |
| 0:36.8 | we'll we'll do that with you ten bucks of the shirt will go straight to the |
| 0:40.9 | drizzle project and continue funding the work of it. |
| 0:44.0 | So you got that. |
| 0:45.4 | We got syntax on the back. |
| 0:47.4 | You think that's it? |
| 0:48.4 | You're not. |
| 0:49.4 | Look at this. |
| 0:50.4 | Yeah. |
| 0:51.4 | There we go. |
| 0:53.4 | Really, really cool t-shirt. |
| 0:59.3 | You want to go to syntax out of fam for, |
| 1:01.1 | slash shop or click the show notes or anything like that and |
| 1:04.4 | and snap up a t-shirt for there all gone so we got Andrew and Alex |
... |
Please login to see the full transcript.
Disclaimer: The podcast and artwork embedded on this page are from Wes Bos, and are the property of its owner and not affiliated with or endorsed by Tapesearch.
Generated transcripts are the property of Wes Bos and are distributed freely under the Fair Use doctrine. Transcripts generated by Tapesearch are not guaranteed to be accurate.
Copyright © Tapesearch 2025.