Syntax - Tasty Web Development Treats

797: Drizzle: The TypeScript SQL ORM

Jul 19, 2024

57:31

Snipd AI

Co-founders of Drizzle ORM discuss type safety, creating filters with Drizzle, and differences with Prisma. They explore managing complexities with separate dialects and the introduction of Drizzle Studio. Additionally, they touch on the challenges faced in Ukraine and expanding the Drizzle team.

AI Summary

AI Chapters

Episode notes

Podcast summary created with Snipd AI

Quick takeaways

Drizzle aims for type safety and practicality in ORM development.

Maintaining positivity amidst challenges is crucial for developers in Ukraine.

Deep dives

Drizzle T-Shirt Collaboration with Open Source Projects

Drizzle collaborates with open source projects on Syntax to launch a new t-shirt initiative, with a portion of each sale supporting the Drizzle project financially. This collaboration aims to promote cool collaborations with open source projects, while also generating funds to sustain and boost Drizzle's work. Beyond selling t-shirts, the initiative illustrates a unique approach to supporting open source development.

Intro

2min

Evolution of Drizzle: From Inception to Challenges

10min

Exploring TypeScript ORM connectivity and error monitoring tools

2min

Differences in Writing Filters and Collaborations in ORMs

14min

Managing Complexity with Separate Dialects for Specific Databases

2min

Committing to a Dialect and Introducing Drizzle Studio

7min

Discussions on Drizzle Studio Features and Drizzle Kit's Migration Tool Design

3min

Evolution of Database Management and Challenges in Ukraine

11min

Expansion of Drizzle Team and Development of New Products

2min

10.

Investing in Drizzle and High-Tech Swimming Goggles

5min

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.