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! + Syntax × Drizzle Swag. * 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. + Drizzle Studio Syntax Theme. * 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. + DrizzleORM v0.30.6 release notes. * 44:00 Being a developer in Ukraine in 2024. + How to support Ukraine: Savelife, United24. * 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