Drizzle ORM in 100 Seconds

Ғылым және технология

Drizzle is a serverless TypeScript ORM designed for PostgreSQL, MySQL and SQLite. Get started with Drizzle by hooking it up to Neon's free serverless database neon.tech/fireship
#programming #database #100SecondsOfCode
💬 Chat with Me on Discord
/ discord
🔗 Resources
Neon Postgres Database neon.tech/fireship
Drizzle ORM github.com/drizzle-team/drizz...
Neon's Full Drizzle Tutorial • Learn Drizzle ORM in 1...
I tried 8 PostgreSQL ORMS • I tried 8 different Po...
🔥 Get More Content - Upgrade to PRO
Upgrade at fireship.io/pro
Use code YT25 for 25% off PRO access
🎨 My Editor Settings
- Atom One Dark
- vscode-icons
- Fira Code Font
🔖 Topics Covered
- What is Drizzle?
- Best database to use with Drizzle
- Best serverless database tools
- What is object relational mapping?
- Comparison of JavaScript ORMs
- How does Object Relational Mapping in SQL work?

Пікірлер: 927

  • @Fireship
    @Fireship2 ай бұрын

    Check out this video for the full tutorial kzread.info/dash/bejne/mn2NsLGiiru3Z7w.html

  • @randomyoutubeacts6mviews2y6

    @randomyoutubeacts6mviews2y6

    2 ай бұрын

    Day 2 without ai video

  • @not_hehe__

    @not_hehe__

    2 ай бұрын

    drizzle deez nuts

  • @dhaloi

    @dhaloi

    2 ай бұрын

    ok boss. id use

  • @LuisSierra42

    @LuisSierra42

    2 ай бұрын

    Looks pretty good ngl

  • @samuel-zagueiro-raiz-de-rua

    @samuel-zagueiro-raiz-de-rua

    2 ай бұрын

    y

  • @NicholasMaietta
    @NicholasMaietta2 ай бұрын

    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.

  • @abhi.r8

    @abhi.r8

    2 ай бұрын

    Who to become a backend developer

  • @lucassilvas1

    @lucassilvas1

    2 ай бұрын

    @@abhi.r8 Me to become a backend developer

  • @alviahmed7388

    @alviahmed7388

    2 ай бұрын

    How did you know that?

  • @abhi.r8

    @abhi.r8

    2 ай бұрын

    @@lucassilvas1 how bro are u getting interviews the job market is fucked big time

  • @abhi.r8

    @abhi.r8

    2 ай бұрын

    @@alviahmed7388 because I am jobless now year after being laid off 🤪

  • @douwezumker
    @douwezumker2 ай бұрын

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

  • @stea27

    @stea27

    2 ай бұрын

    That was exactly my 1st thought when I saw the video.

  • @peteruelimaa4973

    @peteruelimaa4973

    2 ай бұрын

    Wtf seriously.

  • @marcuss.abildskov7175

    @marcuss.abildskov7175

    2 ай бұрын

    Look at Deepkit ORM

  • @seannewell397

    @seannewell397

    2 ай бұрын

    Closer to Dapper right?

  • @MartinLiversage

    @MartinLiversage

    2 ай бұрын

    @@seannewell397 No, Dapper has no way to maintain a schema while both Drizzle and EF Core provides a code first approach. Also, both Drizzle and EF Core allow you to write your queries in either TypeScript or C# (using LINQ). Out of the box Dapper doesn't have this feature. Instead you typically provide the SQL as a string which is why some people prefer Dapper: you have complete control of the SQL used.

  • @arcan762
    @arcan7622 ай бұрын

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

  • @agenta6412

    @agenta6412

    2 ай бұрын

    😂

  • @AmlanjyotiSaikia

    @AmlanjyotiSaikia

    2 ай бұрын

    In my entire career I am yet to see any project of anything above trivial complexity where you can solely rely on ORMs. You HAVE to write raw SQL at some point and boy you better learn how to rawdog it good.

  • @saadalmuttakee8469

    @saadalmuttakee8469

    2 ай бұрын

    man of culture 👍

  • @jaideepshekhar4621

    @jaideepshekhar4621

    2 ай бұрын

    LMAO!

  • @igordasunddas3377

    @igordasunddas3377

    2 ай бұрын

    *Hibernate to devs saying one should learn how to rawdog SQL:* am I a joke to you? Seriously though: if you have a database, that requires you to write raw SQL to accomplish something in a performant manner, this means either your database structure or the structure of your entities sucks balls.

  • @kalemmentore384
    @kalemmentore3842 ай бұрын

    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 😃

  • @typescript_evangelist

    @typescript_evangelist

    2 ай бұрын

    The exact same thing here 😊

  • @arcan762

    @arcan762

    2 ай бұрын

    You are just at the peak of the bell curve. Soon everything will start being confusing again. 😐

  • @kalemmentore384

    @kalemmentore384

    2 ай бұрын

    @@arcan762 can’t wait 😂

  • @Banz_FPSB
    @Banz_FPSB2 ай бұрын

    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.

  • @DaLoler1

    @DaLoler1

    2 ай бұрын

    Wait how does SQL not have type safety?

  • @ymahtab

    @ymahtab

    2 ай бұрын

    ​@@DaLoler1I think they mean it brings the SQL's type safety into the code for you.

  • @Banz_FPSB

    @Banz_FPSB

    2 ай бұрын

    @DaLoler1 @@ymahtab Yeah that's what I meant. You wouldn't have much type safety from the TS environment by just sending queries like myDb.query('SELECT * FROM users');, but of course the DBMS itself manages types very well.

  • @thatsalot3577

    @thatsalot3577

    2 ай бұрын

    @@DaLoler1 because SQL is just raw strings ? I still think it's possible to use a linter but IDK, it seems better when your db feels like just another library with constraints instead of random string bs

  • @federicopisa4465
    @federicopisa44652 ай бұрын

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

  • @kiss-liava

    @kiss-liava

    2 ай бұрын

    Well... Yep

  • @atom6_

    @atom6_

    2 ай бұрын

    This. thank you, it doesnt make any freaking sense. i see this like all the weird crappy javascript frameworks that all think to solve something.

  • @kushalramakanth7922

    @kushalramakanth7922

    2 ай бұрын

    @@atom6_ “Solving problems no one has” seems to be the motto of most tech startups lmao

  • @VladK-1

    @VladK-1

    2 ай бұрын

    With fancy colors, intellisense, DBprogramming language type mapping, and compile-time verification. Plus DB scheme generation, migration scripts, etc utils. This is way more than just a “reinvented SQL”. It’s a full toolkit which makes the life of a software engineer much easier.

  • @mixed_nuts

    @mixed_nuts

    2 ай бұрын

    @@atom6_ it's like y'all want to purposely miss the point. Type safety.

  • @ceezar
    @ceezar2 ай бұрын

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

  • @okie9025

    @okie9025

    2 ай бұрын

    the point isn't to avoid writing SQL, it's to introduce types to SQL. If the language is robust enough then you could do some magic like sqlx in Rust, but this is Typescript.

  • @kiramaticc

    @kiramaticc

    2 ай бұрын

    It's not about not writing SQL, it's about ensuring type safety for your queries and the data returned by your queries. Drizzle still has some flaws, like you still can't define views in Typescript files, you still have to do that with raw SQL which isn't so bad, but it's a product gap they've yet to fill (and seems like a mismatch between the dev experience they want to provide). But it has a great developer experience for full stack devs working on Typescript projects. If you know SQL, you don't even really need to "learn" Drizzle. If someone doesn't know SQL, I can see Drizzle as a great gateway into it as it's API very closely resembles the SQL DDL.

  • @ilearncode7365

    @ilearncode7365

    2 ай бұрын

    You arent supposed to write english in source code.

  • @oscarljimenez5717

    @oscarljimenez5717

    2 ай бұрын

    Yeah, that's the point. SQL or CSS aren't safe, you could easily make a mistake and break a lot of things. So types are needed.

  • @samuel.ibarra

    @samuel.ibarra

    2 ай бұрын

    @@kiramaticcjust cast your columns in your queries to be exactly the type you expect. Make your columns not null able by default, and rely on the relational model

  • @conundrum2u
    @conundrum2u2 ай бұрын

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

  • @vrnvorona

    @vrnvorona

    2 ай бұрын

    Thing is Entity is C#, which no one aside from .net and unity nerds use

  • @theilluminatimember8896

    @theilluminatimember8896

    2 ай бұрын

    More like TypeORM

  • @conundrum2u

    @conundrum2u

    2 ай бұрын

    @@theilluminatimember8896 except Entity Framework itself predates TypeORM by at least 13 years, LINQ syntax came out the year prior to that, and the Fluent API for EF came a few years after EF's release.

  • @conundrum2u

    @conundrum2u

    2 ай бұрын

    @@theilluminatimember8896 not quite... LINQ released 2007, EF released 2008 Fluent API for EF released 2013 TypeORM released 2021

  • @conundrum2u

    @conundrum2u

    2 ай бұрын

    @@theilluminatimember8896 2007: LINQ 2008: Entity Framework 2011: Fluent API for EF 2021: TypeORM

  • @Yenzi769
    @Yenzi7692 ай бұрын

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

  • @LuisSierra42

    @LuisSierra42

    2 ай бұрын

    Crypto bot detected

  • @0644dev

    @0644dev

    2 ай бұрын

    but she's right

  • @94SL3

    @94SL3

    2 ай бұрын

    Famous last words

  • @yevgeniyvasilyicbazarov1555

    @yevgeniyvasilyicbazarov1555

    2 ай бұрын

    Julia, is the crypto business booming or not?

  • @hck1bloodday

    @hck1bloodday

    2 ай бұрын

    honestly, looks a lot like EntityFramework

  • @HelloWorld-rx1iy
    @HelloWorld-rx1iy2 ай бұрын

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

  • @MisterBlex
    @MisterBlex2 ай бұрын

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

  • @perfect.stealth

    @perfect.stealth

    2 ай бұрын

    The absolute first thing I thought of was Laravel as well 😂

  • @medilies

    @medilies

    2 ай бұрын

    I was horrified when he showed how things are done with prizma.

  • @aditya321998

    @aditya321998

    2 ай бұрын

    js has lot of catching up to do wrt to laravel

  • @aheendwhz1

    @aheendwhz1

    2 ай бұрын

    Is Eloquent typed? I thought it just uses unchecked strings for property and even class names, just like Doctrine or any other ORM.

  • @medilies

    @medilies

    2 ай бұрын

    @@aheendwhz1 it has explicit casting

  • @hamadaelwarky3640
    @hamadaelwarky36402 ай бұрын

    Drizzle seems like a banger!

  • @your_anium
    @your_anium2 ай бұрын

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

  • @PhillipTTruong

    @PhillipTTruong

    2 ай бұрын

    Please stop being like this

  • @LuisSierra42

    @LuisSierra42

    2 ай бұрын

    AI is our present, past and future

  • @robrider838

    @robrider838

    2 ай бұрын

    AI writes my EF code for me when I ask nicely.

  • @radimhof
    @radimhof2 ай бұрын

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

  • @oscarljimenez5717

    @oscarljimenez5717

    2 ай бұрын

    Kysely es better than Drizzle by far. But it seems that the syntax don't like it to a lot of devs.

  • @desiassassin3268
    @desiassassin32682 ай бұрын

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

  • @vrnvorona

    @vrnvorona

    2 ай бұрын

    10 seconds only also sponsor block

  • @somedooby

    @somedooby

    2 ай бұрын

    There's always KZread Premium

  • @Flame_Dev

    @Flame_Dev

    2 ай бұрын

    Why are you not using an adblocker?

  • @Ajay-kz9ns

    @Ajay-kz9ns

    2 ай бұрын

    ​@@somedoobynize joke

  • @jerseyse410
    @jerseyse410Ай бұрын

    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

  • @adnandev_
    @adnandev_2 ай бұрын

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

  • @soadsam
    @soadsam2 ай бұрын

    man i love how fast youve been releasing new videos lately

  • @soadsam

    @soadsam

    2 ай бұрын

    @@btw_i_use_arch the future is so bright

  • @jsoncarr
    @jsoncarr2 ай бұрын

    I just started looking into drizzle yesterday. What perfect timing

  • @ElGnomistico
    @ElGnomistico2 ай бұрын

    Would love a video comparing Drizzle and Kysely

  • @saadhabashneh5587

    @saadhabashneh5587

    2 ай бұрын

    +1

  • @eduardourias8379

    @eduardourias8379

    2 ай бұрын

    Kysely ftw

  • @nadanke2268

    @nadanke2268

    2 ай бұрын

    kysely is great, don't know why everyone fawns over drizzle

  • @anonAcc575

    @anonAcc575

    2 ай бұрын

    I think it fills the typesafety promise better.

  • @ElGnomistico

    @ElGnomistico

    2 ай бұрын

    @@anonAcc575 not my major concern with it atm, I basically want less abstraction between me and SQL, but still some ergonomics. Kysely seems like a great strike at that balance

  • @NeatMemesDotCom
    @NeatMemesDotCom2 ай бұрын

    Zero days without the nodejs community reinventing the wheel

  • @KiteHigh-dz7rh

    @KiteHigh-dz7rh

    2 ай бұрын

    *JS community

  • @everythingisfine9988

    @everythingisfine9988

    2 ай бұрын

    Na, more like conquering the backend services. Still waiting on BE languages to gain "significant" market share in the front end.

  • @xIcarus227

    @xIcarus227

    2 ай бұрын

    @@everythingisfine9988 that's not gonna happen anytime soon, we've relied so much on JS that adoption for something else will take a long time. It doesn't help that the people in charge of WASM are stubborn and won't add direct DOM bindings so we can completely do away with JS. Every time you want to update the DOM you're going through JS so you have to build your own wrappers. Not a huge deal, but annoying.

  • @faraazjan
    @faraazjan2 ай бұрын

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

  • @RobertMcGovernTarasis
    @RobertMcGovernTarasis2 ай бұрын

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

  • @asedtf
    @asedtf2 ай бұрын

    Huh, EntityFramework

  • @lot.bajrami

    @lot.bajrami

    2 ай бұрын

    Yeah plus entity framewokr is mature and much better

  • @dotValkyrie

    @dotValkyrie

    2 ай бұрын

    The difference is that this is for TypeScript

  • @Malix_off

    @Malix_off

    2 ай бұрын

    Show us how the fuck can you use EntityFramework in JavaScript

  • @_tonypacheco

    @_tonypacheco

    2 ай бұрын

    ​@@Malix_off I file this under "problems you wouldn't have if you didn't feel the need to use JS/TS everywhere" There are mature backend frameworks with awesome ORMs.

  • @everythingisfine9988

    @everythingisfine9988

    2 ай бұрын

    Sorry bro, I've used both and Drizzle is far better

  • @gregou9885
    @gregou98852 ай бұрын

    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

  • @kelvindimson
    @kelvindimson2 ай бұрын

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

  • @Exzyte
    @Exzyte2 ай бұрын

    You learn new things every day. Insane

  • @WillDelish
    @WillDelish2 ай бұрын

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

  • @K.Huynh.
    @K.Huynh.2 ай бұрын

    Thank for sharing! I'll try this!

  • @crowse3200
    @crowse32002 ай бұрын

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

  • @kashanghori6952
    @kashanghori69522 ай бұрын

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

  • @FeckOffTeaCup
    @FeckOffTeaCup2 ай бұрын

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

  • @artichokehandler

    @artichokehandler

    2 ай бұрын

    be prepared to use that “magic sql” feature. The project is so unfinished and not production ready you end up having to write raw SQL half the time.

  • @IngwiePhoenix
    @IngwiePhoenix2 ай бұрын

    Awesome tool, thanks for the recommendation!

  • @PapaJuan
    @PapaJuan2 ай бұрын

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

  • @TerenceKearns
    @TerenceKearns2 ай бұрын

    That looks seriously dope

  • @ohheyos
    @ohheyos2 ай бұрын

    New fireship video 🎉

  • @fingerstyledojo
    @fingerstyledojo2 ай бұрын

    oh my god this is exactly what i needed

  • @desireco
    @desireco2 ай бұрын

    On the other note... Love Neon!

  • @3dxspx703
    @3dxspx7032 ай бұрын

    Once again, eloquent orm, thanks.

  • @todddelozier8172
    @todddelozier81722 ай бұрын

    Fireship be spoiling us with content this week 😊

  • @ivlis.w8630
    @ivlis.w86302 ай бұрын

    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

  • @cl4rk_sh
    @cl4rk_sh2 ай бұрын

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

  • @Bliss467
    @Bliss4672 ай бұрын

    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

  • @user-sl4vq9yg1r
    @user-sl4vq9yg1r2 ай бұрын

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

  • @mukiibipeter07

    @mukiibipeter07

    2 ай бұрын

    fuck, that's cool.

  • @aheendwhz1

    @aheendwhz1

    2 ай бұрын

    That's the opposite of cool. It means you have to either use wrong grammar (like child => childs) or implement a never-ending list of plural forms, for all languages in the world, where some will still have to use wrong grammar because certain words are not supported or their language is badly supported because there are not so many developers of this language or plural forms are so irregular that you need every single word to be specifically supported in order to generate a plural form. Symfony is trying to do this. After 15 years, they have an English and a French pluralization inflector, and they still receive issues with certain words not being supported. This should teach you that you should never attempt to do natural language pluralisation in code! But does Drizzle do such form of "automatic" pluralisation? I didn't see that one in the video.

  • @user-fr2fm3ri3w

    @user-fr2fm3ri3w

    2 ай бұрын

    @@aheendwhz1buzzkill

  • @danielkehlibarov

    @danielkehlibarov

    Ай бұрын

    ​@aheendwhz1 I don't think you even watched the video or read the docs, what you wrote is pure nonsense and totally irrelevant. :) And it's `one(horses) ` btw...

  • @negativerfan
    @negativerfan2 ай бұрын

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

  • @federicomontesdeoca8977

    @federicomontesdeoca8977

    2 ай бұрын

    explain

  • @markovcd
    @markovcd2 ай бұрын

    Revolutionary! If we ignore all other ORMs.

  • @aheendwhz1

    @aheendwhz1

    2 ай бұрын

    How many ORMs actually support a type system to check for the correct property names and types?

  • @RodrigoGonzalezAbate

    @RodrigoGonzalezAbate

    2 ай бұрын

    ​​@@aheendwhz1hibernate has supported Criteria Queries since 2004, it arrived 20 years late... I understand paid content, and that there wasn't something like this in JS, but... But coincidentally because JS is not typed, why would you want to type the queries? Now it just lacks 20 years of development to offer everything that Hibernate already does, not to mention the integration with Spring, like the auto-generated DAOs and REST controllers.

  • @nro337
    @nro3372 ай бұрын

    Loving Drizzle, really nice Prisma alt

  • @ibendover4817
    @ibendover48172 ай бұрын

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

  • @xulqarnaen
    @xulqarnaen2 ай бұрын

    the earliest ive been to any video ever

  • @ajzack983
    @ajzack9832 ай бұрын

    neon is great indeed, I used it with laravel

  • @hashbrown777
    @hashbrown7772 ай бұрын

    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)

  • @ayaanqui
    @ayaanqui2 ай бұрын

    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.

  • @kiss-liava
    @kiss-liava2 ай бұрын

    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

  • @imxd9698
    @imxd96982 ай бұрын

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

  • @dejancavic8649
    @dejancavic86492 ай бұрын

    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! 🎉

  • @NicolasSilvaVasault
    @NicolasSilvaVasault2 ай бұрын

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

  • @floriankohler6064
    @floriankohler60642 ай бұрын

    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

  • @ivandariogye
    @ivandariogye2 ай бұрын

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

  • @David-oc8yt
    @David-oc8yt2 ай бұрын

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

  • @thesigma8508
    @thesigma85082 ай бұрын

    Idk shit about coding, yet I still watch your videos

  • @maacpiash
    @maacpiash2 ай бұрын

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

  • @bacharelkarni
    @bacharelkarni2 ай бұрын

    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

  • @richardyoshioka2501
    @richardyoshioka25012 ай бұрын

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

  • @rafaelveronezi8730
    @rafaelveronezi87302 ай бұрын

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

  • @samuelwittlinger7790
    @samuelwittlinger77902 ай бұрын

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

  • @presi3005
    @presi30052 ай бұрын

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

  • @stardrake691
    @stardrake6912 ай бұрын

    Entity framework core: finally a worthy opponent.

  • @NawfalHasan

    @NawfalHasan

    2 ай бұрын

    Nowhere as ergonomic as Linq still. Linq is goat query language in terms of typesafe-ness and intuitiveness.

  • @EikeSchwass

    @EikeSchwass

    2 ай бұрын

    @@NawfalHasanuntil you run into runtime exceptions because EF Core couldn't map LINQ to SQL and you didn't get any compiler warnings/errors beforehand. It still requires you to know what you are doing and how SQL actually works. It's still amazing of course

  • @NawfalHasan

    @NawfalHasan

    2 ай бұрын

    @@EikeSchwass as opposed to typescript and drizzle wouldn't run into? My point is Linq IMO is still the 🐐 query language, regardless of how flaky the implementations like EF are. Linq just flows naturally, using the idioms of the language (mostly). While drizzle requires functions like eq for something as primitive as equality.

  • @EikeSchwass

    @EikeSchwass

    2 ай бұрын

    @@NawfalHasan Yeah 100% agree. LINQ-2-Entities just gives you a false sense of security (although Roslyn-Analyzers help a lot). To know when, where and how Linq to Sql translation actually occurs is important and it might appear more trivial than it is (simply because LINQ flows so great). You can't just use any IEnumerable-extension-method, although it reads as if you could/should. But I really don't disagree with your point, just that the magic doesn't prevent you from knowing your stuff

  • @NawfalHasan

    @NawfalHasan

    2 ай бұрын

    @@EikeSchwass agree.

  • @redakcjaTheBased
    @redakcjaTheBased2 ай бұрын

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

  • @Muzzino
    @Muzzino2 ай бұрын

    Reminds me of ReQL, this is fantastic

  • @WewasKangs-bd9eb
    @WewasKangs-bd9eb2 ай бұрын

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

  • @andrewmanninen1244
    @andrewmanninen12442 ай бұрын

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

  • @isaacfink123
    @isaacfink1232 ай бұрын

    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

  • @20hawkar10
    @20hawkar102 ай бұрын

    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.

  • @PanzrKunst
    @PanzrKunst2 ай бұрын

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

  • @graypsi
    @graypsi2 ай бұрын

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

  • @name_my_name
    @name_my_name2 ай бұрын

    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.

  • @HellDarkknight

    @HellDarkknight

    2 ай бұрын

    The sanest comment so far. People don't know the pain before ORMs where one had to use data adapter and dataset to map query results. And most of them don't have enough traffic or query complexity to feel the pain of ORM issues like n+1 queries or just plain bad generated queries.

  • @HellDarkknight

    @HellDarkknight

    2 ай бұрын

    It's also beyond me on why someone would use ORM in typescript. The whole purpose of typescript is to cover the burning pile of shit called javascript. At least nowadays javascript is solid(shit), unlike diarrhea from 20 years ago.

  • @Keisuki

    @Keisuki

    2 ай бұрын

    @@HellDarkknight The first years of my career were working on applications that directly used JDBC and mapped the result set to objects manually using methods in Java. It's really very easy to do. We didn't have a single bug in the object mapping part of the code, during the entire 4 years, until a senior developer got creative and wrote his own pseudo-ORM using Java's reflection API, and then we had bugs.

  • @petersteel7735
    @petersteel77352 ай бұрын

    0:15 I liked the Cassandra reference right there!

  • @YeasinRafio
    @YeasinRafio2 ай бұрын

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

  • @neociber24

    @neociber24

    2 ай бұрын

    Don't worry about it, he is AI

  • @dmitriylevy7865
    @dmitriylevy78652 ай бұрын

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

  • @re.liable
    @re.liable2 ай бұрын

    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.

  • @huuhhhhhhh

    @huuhhhhhhh

    2 ай бұрын

    Would changing the types outside directly have a knock on for any ORM/non-ORM? Even in VanillaJS, you'd likely still have to deal with the underlying types changing

  • @re.liable

    @re.liable

    2 ай бұрын

    @@huuhhhhhhh That's true

  • @jmac732
    @jmac7322 ай бұрын

    first ever readable database framework

  • @thecastiel69
    @thecastiel692 ай бұрын

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

  • @jakescott1234
    @jakescott12342 ай бұрын

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

  • @Nexzore
    @Nexzore2 ай бұрын

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

  • @RSWDev
    @RSWDev2 ай бұрын

    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.

  • @tyronebiggums957
    @tyronebiggums9572 ай бұрын

    Do a video about Spark/Databricks

  • @syntaxerror831
    @syntaxerror8312 ай бұрын

    I'd love to see a video about Odoo

  • @WeeklyMeat
    @WeeklyMeat2 ай бұрын

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

  • @theneedytechie2468
    @theneedytechie24682 ай бұрын

    Drizzle website has your video placed at top

  • @tranceyy
    @tranceyy2 ай бұрын

    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.

  • @jotim7191
    @jotim71912 ай бұрын

    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.

  • @tenj
    @tenj2 ай бұрын

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

  • @moldeecheese
    @moldeecheese2 ай бұрын

    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.

  • @DominicMarx
    @DominicMarx2 ай бұрын

    hmm... I am using knex for years. this drizzle shizzle looks very neat.

  • @sciencegeeks1370
    @sciencegeeks13702 ай бұрын

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

  • @elliot_yoyo
    @elliot_yoyo2 ай бұрын

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

  • @nirnulls
    @nirnulls2 ай бұрын

    Seems like i will use drizzle for node/bun projects next. Those query function with join - where is really good. Not many ORM support those basic functions 😂 Also the db migration also seems solid. In java land we need liquibase or flyaway which is it’s own beast 😅

  • @kylemalloy
    @kylemalloy2 ай бұрын

    100 Seconds of Hono 🔥 next!

  • @Rundik
    @Rundik2 ай бұрын

    Looks more like a query builder

Келесі