meta_pixel
Tapesearch Logo
Log in
Syntax - Tasty Web Development Treats

721: You should learn Drizzle, the TypeScript SQL ORM

Syntax - Tasty Web Development Treats

Wes Bos

Tech News, News, Technology

4.91.2K Ratings

🗓️ 24 January 2024

⏱️ 54 minutes

🧾️ Download transcript

Summary

We’re doing a Tasty overview of Drizzle in this episode. What is Drizzle? What are different types of databases? How do you host databases? What have we built with Drizzle? And how does Drizzle handle relational data, TypeScript, querying, selects, transactions, and more! Show Notes 00:10 Welcome 00:52 Syntax Brought to you by Sentry 01:50 What is Drizzle? 09:11 Different types of databases 17:58 Why pay for SQLite hosting? 20:36 Defining your data structures 24:27 What we’ve built using Drizzle 28:28 Relational data 36:17 TypesScript and Drizzle 40:53 Querying + Selects with Drizzle 46:23 Transactions 47:09 Syntax Drizzle Studio theme 48:27 Sick Picks Drizzle ORM Drizzle ORM - Overview Meet Drizzle Studio Benchmarks Sequel Pro TablePlus phpMyAdmin Cloudflare D1 Bun habitpath.io Chartable Neon Answer Overflow Drizzle Studio Themes Sick Picks Scott: BlackBerry - Apple TV (CA) Wes: Candle Warmer Lamp Shameless Plugs Syntax Tiktok Hit us up on Socials! Syntax: X Instagram Tiktok LinkedIn Threads Wes: X Instagram Tiktok LinkedIn Threads Scott: X Instagram Tiktok LinkedIn Threads

Transcript

Click on a timestamp to play from that location

0:00.0

You're listening to Syntax, the podcast with the tastiest web development treats out there.

0:06.0

Strap yourself in and get ready. Here is Scott Telinsky and West Boss.

0:10.6

Welcome to Syntax, the podcast with the tastiest web development treats out there today. We've got a show for you on two things

0:18.2

drizzle and databases so drizzle is an ORM that allows you to interact and have queries and insert data to different databases.

0:29.0

So we thought we would explain what Dr drizzle is and how it works alongside explaining a bunch of stuff about

0:37.2

my SQL, Postgress, and SQL, and SQL, those are the three databases that drizzle supports and being able to explain their features and

0:46.4

context of drizzle we thought would be super helpful. So buckle up for a database filled

0:52.3

episode.

0:53.0

Yeah, databases, huh?

0:55.0

If you're working in databases,

0:57.0

ORMs, chances are, you're going to mess up your code.

1:02.0

You're going to have some slow queries. You know, one of the, my favorite

1:06.2

new features on Century is the query performance tracker.

1:13.0

You know, when we were building our syntax site,

1:16.0

some of our queries ended up being a little bit slow,

1:19.0

and I don't know if I would have noticed that I was using the wrong ORM method to query when you're trying to find

1:26.9

one. I wasn't doing it. I believe it was find unique. I think I was doing find first instead of

1:31.3

find unique or something. And because of that we had a

1:34.8

bunch of slow queries and I was able to see that because of Century's slow query

1:39.6

monitoring so if you sign up for Century at century dot I own that's S-E-N-T-R-Y dot I-O.

1:45.0

Use the coupon code Tasty Treat, you go two months for free.

1:49.0

And the show is presented by Century.

...

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 2026.