Check out this video for the full tutorial ukposts.info/have/v-deo/oHmKgoWgkY6CmI0.html

The other cool thing about Drizzle is that it will take multiple queries and handle them as one query to your database rather than multiple. This alone has some real speed benefits.

This seems like LINQ and entity framework but for typescript, pretty cool imo

Looks cool... _Goes back to just rawdogging my SQL code._

When you hate SQL so much that you go full circle to just write raw SQL again but with fancy colors

Devs will do anything to not have to write SQL. Even create a syntax that closely mirrors SQL.

Two years ago I started learning software development and struggled to understand what you were talking bout in most of your videos. I'm happy to say now that everything is making sense 😃

Drizzle seems like the ORM we never knew we needed. Can't wait to try it out on my next project!

Been using Drizzle on my latest project for a few months now, and I think it's absolutely great. Sure there are still a few cases where types can get a bit confusing, but overall it's extremely simple to use, it's basically SQL with type safety. I love it.

"This has been Entity F.... uh Drizzle in 100 seconds"

Third video without mentioning AI. You can do it Jeff!

Finally an actual 100 seconds video because there was a freaking 74 seconds ad :) ty fireship

Reminds me of the Eloquent ORM for Laravel. Loved using that one since the early days of Laravel.

Waiting for a Kysely video now, its a nice typesafe query builder and does most of the job when an ORM isnt needed.

Would love a video comparing Drizzle and Kysely

Drizzle seems like a banger!

Started using typeORM tonight and stumbled across your Drizzle video and already I'm thinking of moving from typeORM to Drizzle. I love the native SQL query like syntax

I'm a fan of query builder Kysely. It's fantastic combo together with prisma for schema and migrations or with atlas.

Good video as always. Would you please do Mikro-ORM next?

This was just what I was looking for yesterday, couldn't decide between Prisma and Sequelize before this, thanks!

I just started looking into drizzle yesterday. What perfect timing

Zero days without the nodejs community reinventing the wheel

Excellent video that convinced me to give neon and drizzle a try for my next project. Currently used to knex to handle the queries but drizzle seems to be a better choice

man i love how fast youve been releasing new videos lately

Huh, EntityFramework

okay this is one of the few videos I need to rewatch when I can sit to do some work. Nice!

So far drizzle has been amazing to use. I love being able to auto generate my types from an existing database

I have this in production, it is amazing!!!

cool looking ORM , I will try this in my next Nodejs projects

Drizzle seems amazing. Going to use it on my next personal project.

Found this just in time to start writing my postgreSQL queries. Ty!

Neon is great. Super easy to get going and it works great with vercel. The ability to do everything serverless is also a godsend.

You learn new things every day. Insane

Thank for sharing! I'll try this!

Awesome tool, thanks for the recommendation!

New fireship video 🎉

EF also has a version that closely matches sql, but had the presence of mind to fix the order of clauses to put the select last

I'm planning to use Neon for my next project. Seems promising, thanks.

That looks seriously dope

I have this really long going project which still uses JQuery and raw MySQL queries. I always get sad when I see those cool new technologies which you present on your channel. Really awesome

On the other note... Love Neon!

Im surprised this wasn't developed earlier. I made this for our proprietary non-relational database software years ago No more runtime "hey your raw string query doesn't work", the methods you call can only be chained in specific ways that the compiler (or at least your linter) knows, and at runtime it spits out that raw string (so no objectification overhead)

Sqlc and go-jet/jet for Go, are in my opinion the best option if you don’t want to deal with raw SQL queries (type safety) and also don’t think ORMs are the best fit (complex schema/large DB with many tables). The best part about these 2 libraries is they work on your existing schema. No need to redefine types they are created using the existing DB. Definitely worth checking out.

Drizzle is definitely my favorite ORM, pretty easy to use once you learn how to declare your schema, and so powerfull by generating one query from the entire statement Still, it may have some issues, like prepared statements having to be explicit, but the most notable I think would be in some parts the documentation.. When I started learning it I found myself spending more time that I should reading it and still not understanding the exact difference between some things (like drizzle-kit push and migration) The prisma-like relations schema seemed a little bit boilerplate and not really well explained either And in the SQL-like approach, the aggregates part (the GROUP BY and HAVING) could have more examples Or at least that was my experience back then, but last time I checked it had already improved I hope it gains more popularity so it keeps polishing those details, since really like the general approach and having things like drizzle studio is so convenient

Fireship be spoiling us with content this week 😊

Tried it today. Better than prisma in many ways imo.

OMG. FINALLY. This is fing masterpiece. I currently use sqlalchemy in python and it uses a similar approach. You have both stupid-like and sql-like code. Finally it's possible to write human-readable code in javascript

Revolutionary! If we ignore all other ORMs.

Loving Drizzle, really nice Prisma alt

one(horse) many(horses) Me: fuck, that's genius.

oh my god this is exactly what i needed

the earliest ive been to any video ever

Seeing non-ai frequent videos gives me hope to go on

Oh God, what great editing, I lol'ed when he showed the candle under the shower.

very excited that there's yet another option in the sea of options

0:19 ORM doesn't hide SQL's complexity but adds a new level of it in exchange for a reduction of code that is required to map database objects into language-specific ones and vice versa, also you can use your language syntax (depending on ORM) to perform read and write operations from/to the database. But a developer should be well aware of how SQL and ORM work, if one doesn't know first, there will be no way to go beyond simple queries (neither high-performance queries nor complex relationships between tables), if last, the developer will end up "slowly" writing plain SQL. The best way will be to get the benefits of both "worlds", ORM for an average case and SQL for a complex one. ORM is not a replacement for SQL it's just a tool to get most of the stuff done faster, but you still need to have a good understanding of SQL.

wow that was easy, i think i'm gonna give it a try

neon is great indeed, I used it with laravel

Entity framework core: finally a worthy opponent.

I am quite hyped about drizzle and its ease of use. Two days ago I stumbled upon some weird stuff with Prisma ORM for SQL, and TBH It is my first time to use it. But the pitfall I had is that it wasn't exactly an ORM l hoped it to be(used TypeORM till now, but decided to try something new because the development there seems stalled), there is this feeling that you are not actually using SQL and actually learning/using the Prisma API - and if something is rather straightforward, in Prisma it was complex for me. And I know that it was probably a Prisma API knowledge gap, but I don't want to adopt something just because its popular and has XY starts. I want something that is easy to use, with SQL like syntax, with more control when needed, and PERFOMANT. Just now, I completed migration from Prisma to Drizzle, took me about couple of hours to rewrite everything, but it was worth it. Shout to everyone to actually use it in a new project. And big shout out to drizzle team for making a remarkable work! 🎉

Once again, eloquent orm, thanks.

I mean this has been done in SQLAlchemy for years, and you get a ORM too! Cool to see it comes to JS/TS too.

One awesome thing about drizzle is the one query guarantee, drizzle never runs more than one query and never transforms the data in js, its pretty neat how they pulled this off, i inspected some queries and they rely on a lot of json functions which is a pretty cool use case for this

Just use raw SQL as it was intended to be used from the start. I've seen so many projects being built with nhibernate, EF Core, etc, etc and all of them gets performance issues and super complex abstractions on top of abstractions as soon as your database gets complex. SQL isn't a hard language to learn, I would argue that alot of ORMs are even harder to learn and just slows down your performance.

Can you do Gunicorn in 100 Seconds? This video was great btw! So concise and no bloat.

Should be noted that the migration and studio are not open source. They both might be a service in the long run...

Looks like Knex query builder i have been using for ages on node. It too has similar method chaining and migrations.

I looked for the free tier db to mess around, Neon looks like this

Cool, they ported LINQ and Entity Framework to TypeScript! 👏🏻👏🏻

0:15 I liked the Cassandra reference right there!

It's a prisma without the bad side of prisma. hope it works actually as good as said in the video. Anyway, it deserves to be checked up. can't wait to try it in my next project

Everyone's talking about EF, but not about JOOQ for Java. That thing generates types from your actual db tables and allows you to use everything you'd use with sql type-safely. You get out of sync, you get a compile time error. No ORM can ever come close to this.

Reminds me of ReQL, this is fantastic

There is some haunting sound in the background at 2:26 which sent shivers down my spine :O You good Jeff?

Idk shit about coding, yet I still watch your videos

So, it's like EF Core for TypeScript. Cool!

Don't forget about Kysely as well ;)

There should be a C++ version of this library 😉 This has serious potential!

Hey, can you please make a video about this new offline-first app trend?

I love these videos, even if I cannot understand a single word this man is saying.

Kysely is the best and the only ORM needed for any TS project

Is this pretty equivalent to Python's SQLAlchemy? Or does this have even more functionality? Its been a while since I've touched it but SQLAlchemy has been super useful for the APIs I've built.

Drizzle is awesome! It hits the perfect balance between orm and raw sql.

Chose Drizzle for my latest project - it's brilliant.

Does Drizzle have introspection/codegen? I’m a kysely user for the closeness to SQL while having IDE autocomplete and database introspection and codegen was the reason why I picked it. Defining types manually just seemed like too much of a drag even though schema shouldn’t change too much over time.

so, it's just a querry builder with the overhead of having to write extra schemas? How great. Can't wait to use it

R in 100 seconds! R’s dplyr package is the OG Drizzle-style ORM

This is literally what I've been doing manually for Perl for years

First, I love your videos. Nevertheless, I have a question, did you make the subject based on the sponsor's ecosystem or is it the other way around ? cause I got a strange feeling watching it...

existence of this framework it's like natural selection, but with extra steps

Interesting. But for the moment I am sticking with MikroORM, which I really recommend as an substitute for TypeORM.

Do a video about Spark/Databricks

Fireship is back with good old classics! And now I want Ai content again

I'd love to see a video about Odoo

Drizzle (+ Zod) has been a pleasurable experience. I've encountered a few edge cases with the types though when the database gets modified directly outside of Drizzle.

I swear today I saw this tool in a random docs and said wtf is that and you just dropped this

I love drizzle. Neon tho.... Its a different story

100 Seconds of Hono 🔥 next!

dang. if only I found out this first than typeorm. I would've opted to using this in my recent project. typeorm is a literal pain in the ass.

finally a 100 sec video in 156 seconds