I Have A New Favorite Database Tool

DrizzleORM is the most hyped I've been for db tech in awhile. I hope y'all love it as much as I do.

Keywords: PRISMA ALTERNATIVE MYSQL DATABASEJS POSTGRES PSQL MYSQL PLANETSCALE EDGE SQLITE

S/O Mir for the awesome edit 🙏

[prestonharrison]

Can't wait to see which tool you'll be using next week!

Ah, the classic, why learn SQL once, when you can spend every month learning a new ORM library and every second month debugging it.

[ykhi]

On top of that, Drizzle orm has the best memers

[ryzzlas]

Having Drizzle make just a single query is big. Because that means the DB's own query optimizer has the full context and can optimize the query better than we all ever could.

[sadkebab]

You forgot to mention that they have also a "drizzle-zod" plugin that generates customizable validators from the table schemas. Even less redundant work to think about.

[danny_rh]

Ive been using drizzle for about 2 months now and i love it. At first making complex queries was a pain but since they released the new documentation my devepler experience has increased exponentially

[itanio]

Been waiting for a Theo primer about Drizzle! Thanks! 👍

[dipupoawe]

I love drizzle for it's flexibility, the default query builder offers a lot of flexibility for my backend projects and the relational queries are great for less complex queries

[July-dhlk]

Drizzle gets better with time. Really very good syntax

[jackevansevo]

Always good to see advancements in the ORM space, this looks like a really nice DX.

[jacoblockwood]

OMG i'm so hyped to start using the new drizzle relational queries ASAP this was like the one blocker stopping me from moving forward with it!!

[hamesjetfield]

I use Prisma as a pure migration tool. My backend isn't even in Typescript. I connect to it using my kotlin backend. It's great for that honestly.

[bilbobeutlin]

Prisma is like the hot goth girlfriend with lots of tattoos and piercings.
It's a lot of fun first but comes with a lot of baggage.

[rtorcato]

Defining a schema in front/back end code must make DBA heads explode. I like how Supabase cli just dumps out the typescript from Postgres. Now I can do database stuff where it belongs... in the database!

[nanashi]

Drizzle is great but we need alternative of Prisma studio. Prisma studio is amazing.

[naranyala_dev]

thanks theo, it would be awesome when it becomes an alternative or maybe default option in the t3 stack

[netssrmrz]

Surely you'll eventually drive yourself mad if you fall for a new shiny ORM every 6 months. Just commit to SQL. You don't understand the power of the dark side! Anyway, I understand that most people that don't like SQL turn to ORMs, but I can't help feeling these are exactly the people that should not be using them. Still, good to be aware of Drizzle.

[dbug]

Is there a way to get Zod schemas as well? I like the way Zod works and how you can get Typescript types from the schema objects. The Zod schemas can be used for many different things, such as validation data from an endpoint, or for forms.

[djSeakDigital]

The fact that this video shows after fireship video of ORMs is a chefs kiss

[ChristianBoehmTV]

Are you going to replace prisma with drizzle in the T3 stack?