No video

NestJS, MySQL, TypeORM Crash Course

Covering the basics from creating, reading, updating, and deleting data from our MySQL database, all the way to one-to-one relationships and one-to-many and many-to-one. By the end of this video, you will become more comfortable with working with TypeORM entities and repositories to build persistent applications!
Code: github.com/stu...
Support the Channel:
Become a Member: www.youtube.co...
Become a Patreon: / stuyy
Buy me a Coffee: ko-fi.com/anson
Donate on Streamlabs: streamlabs.com...
Donate on PayPal: paypal.me/anso...
Connect with me:
Twitter: / ansonthedev
Discord: / discord
GitHub: github.com/stuyy
Twitch: / stuy

Пікірлер: 96

  • @ansonthedev
    @ansonthedev Жыл бұрын

    Should I do a course with MongoDB & Mongoose?

  • @houssincarnelian9562

    @houssincarnelian9562

    Жыл бұрын

    can you make a 2fa with nestjs how to send email verification after user register

  • @adityafitriansyah97

    @adityafitriansyah97

    Жыл бұрын

    Letsgo

  • @szymon2806

    @szymon2806

    Жыл бұрын

    Yes!

  • @SystemDV

    @SystemDV

    Жыл бұрын

    Yea!

  • @TruongNguyen-ix1mr

    @TruongNguyen-ix1mr

    Жыл бұрын

    yes

  • @alexandreluiz6182
    @alexandreluiz618211 ай бұрын

    30 minutes of this tutorial and I was able to finally implement the typeorm in my nestjs backend. The explanation is very simple to understand. Thank you, very much!

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

    @ansonthedev thanks for this tutorial, I 've been a laravel developer for 6 years and going through your Nes'tJS tutorials have been a breeze, Thank you again!!!

  • @Charles_001
    @Charles_001 Жыл бұрын

    Thank you so much for learning all over again, even though I'm still unemployed.

  • @SYEDAAMANSHERAZI
    @SYEDAAMANSHERAZI6 ай бұрын

    I was so lucky i got these lectures .It is really really good . 😍😇

  • @alessandrop.6755
    @alessandrop.67552 ай бұрын

    Hey Anson, I'm really enjoying your NestJS tutorials, I can't find many videos with similar quality. So far you've been able to explain how to best use Nest in many contexts, I've already watched how you implemented it with Mongoose and MongoDB, and after this I'll watch how to implement GraphQL. You are great, thank you for your work and your content. 💯

  • @AliAliOxenFree
    @AliAliOxenFree Жыл бұрын

    WIthout a doubt the best guide videos on KZread. I have watched many other content creators and tried to follow along, none offer explanations like this guy. If i ever get good enough to earn a living doing this, it would be, to a large extent, due to these videos.

  • @borknagarchile
    @borknagarchile8 ай бұрын

    Your teaching is amazing! You know what you are talking about and u are very aware of all the elements involved

  • @ansonthedev

    @ansonthedev

    8 ай бұрын

    Thank you very much!

  • @vardgesmovsesyan3967
    @vardgesmovsesyan3967 Жыл бұрын

    The best CRUD example in nestJS using database

  • @andrejkling3886
    @andrejkling38866 ай бұрын

    Just amazing…. Thank you so much 💯

  • @ansonthedev

    @ansonthedev

    6 ай бұрын

    Thank you and you're welcome! :)

  • @marvinxu2950
    @marvinxu2950 Жыл бұрын

    Thank you! Great course! I can always learn from the little details like PUT vs PATCH

  • @raulgarcia3614
    @raulgarcia36142 жыл бұрын

    Whats your thoughts on Prisma?

  • @JaTeaGee
    @JaTeaGee11 ай бұрын

    Thanks sir, because of this tutorial I can now create my own api, great job for this wonderful tutorial.

  • @waseemusman421
    @waseemusman42110 ай бұрын

    Anson, your way of teaching and explaining core concepts is amazing. if youtube has million thumbs up option then Definitly i will give you millions of thumbs up. Just keep it up. Also did subscribe your channel

  • @mamlzy
    @mamlzy Жыл бұрын

    Thank you so much for teaching me about nest js, it really helped me alot!

  • @jairocket
    @jairocket Жыл бұрын

    Thank you very much for this tutorial! I had a lot of fun watching this video and the crash course and sure will be pretty helpful on my job

  • @adhy612000151
    @adhy6120001513 ай бұрын

    Thanks, i just finish this course!

  • @hoxlabs4038
    @hoxlabs40382 ай бұрын

    hey loved the tutorial but one question why didn't you add manytomany relationship example??

  • @aymenchandra8655
    @aymenchandra86554 ай бұрын

    Thank you for this amazing tutorial

  • @ansonthedev

    @ansonthedev

    3 ай бұрын

    You are welcome!

  • @aymenkhanfir2000
    @aymenkhanfir20004 ай бұрын

    Nice course, Good job and thank you ❤👏

  • @masadamsahid
    @masadamsahid Жыл бұрын

    The crash course is "to the point". I like it. Picassoooo~

  • @addis_ababa_university
    @addis_ababa_university Жыл бұрын

    what about ManyToMany TypeORM Relations?

  • @yonatan9867
    @yonatan9867 Жыл бұрын

    Thanks Anson! your videos are amazing!!

  • @realtirtha
    @realtirtha Жыл бұрын

    completed twice to understand better. it's great xD

  • @lucduong9871
    @lucduong9871 Жыл бұрын

    thank you so much anson, best wishes to you

  • @PetriikVx
    @PetriikVx9 ай бұрын

    Amazing, all clear. God bless.

  • @SiciidQaran
    @SiciidQaran Жыл бұрын

    Thanks for sharing, I have one question. How can I call stored procedures instead of using entities. I have developed the database and its procedures first. Now I want to call those stored procedures using nestjs. any help please. Thanks and regards.

  • @wilschoy78
    @wilschoy78 Жыл бұрын

    This is a lifesaver. Thanks.

  • @nhaccuathinh9629
    @nhaccuathinh962911 ай бұрын

    Great course! Could you share the extensions you use for NestJS or your course? Thanks

  • @sathishkumars373
    @sathishkumars3739 ай бұрын

    lot of thanks @Anson💟 after watched your video now i have confident in nestJS

  • @lingadurai5805
    @lingadurai58057 күн бұрын

    Thank you so much broooooo

  • @umrzoqtoshkentov2223
    @umrzoqtoshkentov2223 Жыл бұрын

    Awesome course ever I watched

  • @saimi03
    @saimi03 Жыл бұрын

    DO you have the same thing on Many to Many?

  • @umairqamar2672
    @umairqamar2672 Жыл бұрын

    You are super dooper amazing dude !

  • @samrat131
    @samrat131 Жыл бұрын

    hi, can we achieve one-to-many/many-to-one relation using TypeORM: select table1.*, table2.* from table1 left join table2 on table1.pk_id=table2.fk_id and table1.status=1 , here main concern is to join table with multiple condition , thanks

  • @thathsarasenanayaka8872
    @thathsarasenanayaka8872 Жыл бұрын

    Thank you my friend

  • @sakibthetech
    @sakibthetech5 ай бұрын

    Great!!

  • @linhohoang8023
    @linhohoang80232 ай бұрын

    I want to know your snippet extension, i have tried some but it didn't do as yours in video :((

  • @linhohoang8023

    @linhohoang8023

    2 ай бұрын

    anyway, thank you so much for a very very useful video

  • @user-fg6ww3bu7o
    @user-fg6ww3bu7o5 ай бұрын

    when i restart the app after creating the entity , i did not get any table in mysql .

  • @ansonthedev

    @ansonthedev

    5 ай бұрын

    You need to have synchronize: true in the TypeormModule config options.

  • @prateek4-yearb.tech.chemic511
    @prateek4-yearb.tech.chemic511 Жыл бұрын

    thanks man best tutorial

  • @nivcohen7534
    @nivcohen7534 Жыл бұрын

    Great video!

  • @benjaminguma9962
    @benjaminguma99622 жыл бұрын

    Can you share a link to the resource for using typeorm please?

  • @14gamerx
    @14gamerx Жыл бұрын

    Can you make a video of creating a testing database Mysql for E2E testing?

  • @EhteshamShahzad
    @EhteshamShahzad2 жыл бұрын

    Video on query builder in NestJS?

  • @mohamedaminetrigui9535
    @mohamedaminetrigui9535 Жыл бұрын

    Thanks, man, really appreciate your explaining .

  • @danielvaleriobroncano9677
    @danielvaleriobroncano9677 Жыл бұрын

    thanks!!! i love your video

  • @AbdulRahmanShamair
    @AbdulRahmanShamair Жыл бұрын

    Great Content !!!

  • @muhammedsinan3897
    @muhammedsinan38972 жыл бұрын

    amazing class..thanks..

  • @nikoladzoni6432
    @nikoladzoni6432 Жыл бұрын

    Great content but how would we add relations in find one by and then pass the id so that we could get a specific user ? :)

  • @nikoladzoni6432

    @nikoladzoni6432

    Жыл бұрын

    fetchUserById(id: number) { return this.userRepository.find({ where: { id }, relations: { profile: true, }, }); }

  • @JOJO-mc3kc
    @JOJO-mc3kc7 ай бұрын

    Thank you

  • @ansonthedev

    @ansonthedev

    7 ай бұрын

    You're welcome

  • @larswolter669
    @larswolter669 Жыл бұрын

    Can't the TypeORM CLI create the database? Sorta like sequelize migrate db:drop?

  • @ansonthedev

    @ansonthedev

    Жыл бұрын

    I’m sure it can

  • @Cognitoman
    @Cognitoman Жыл бұрын

    Dude how can I make my own validation for the entity ?

  • @mr_ehmed
    @mr_ehmed Жыл бұрын

    what are your themes and extension for vs code?

  • @curtiscrentsil2836
    @curtiscrentsil28365 ай бұрын

    please add time stamps, i use your video as a reference and it is always difficult to look for what i want, please add time stamps, thanks for your amazing work👊💪

  • @arnaudroncari2468
    @arnaudroncari2468 Жыл бұрын

    Great video 😉

  • @PedroHMelo
    @PedroHMelo8 ай бұрын

    Great!

  • @JaswanthPappala
    @JaswanthPappala Жыл бұрын

    how open mysql in command prompt

  • @falyarivelo7068
    @falyarivelo70686 ай бұрын

    thanks men

  • @EuropeanLord
    @EuropeanLord Жыл бұрын

    Followed it 1:1 and when trying to use postman I get MySQL DB error "QueryFailedError: Field 'username' doesn't have a default value". I send both username and password and Postman returns 201 but nothings get written into db. Can't run POST in Postman again due to "Error: socket hang up" and have to restart the whole nest so its hard to debug. Any ideas whats wrong? Im sending username/password in Postman properly but it tries to save DEFAULT values into the db. [SOLVED] Data type in Postman was set to "raw" but dropdown next to it was set to "text" instead of "JSON" :) So basically POSTMAN was sending data in a wrong format. All good, thank you for a great tutorial.

  • @PedroHMelo

    @PedroHMelo

    10 ай бұрын

    goat

  • @marufhasanmunna8193
    @marufhasanmunna8193 Жыл бұрын

    Please give custom repository example

  • @ihorploskodnyak1294
    @ihorploskodnyak12942 жыл бұрын

    Can you push code to github please? Thanks

  • @ansonthedev

    @ansonthedev

    2 жыл бұрын

    github.com/stuyy/nestjs-typeorm-mysql-course-repository

  • @az910
    @az910 Жыл бұрын

    Amazing 🎉

  • @salahadindinsafa7657
    @salahadindinsafa76572 жыл бұрын

    Thank you !!!!!!

  • @codingneko
    @codingneko Жыл бұрын

    I am pretty sure, it's bad sql practice (according to conventions) to use pluralized names for tables, but it won't make your application crash, so seems good 👌😂

  • @vuxuanhuy9079
    @vuxuanhuy9079 Жыл бұрын

    done!

  • @hafiz2047
    @hafiz20479 ай бұрын

    Please make tutorial using sequelize

  • @Easyman01
    @Easyman01 Жыл бұрын

    GREAT contents!!!! Thank you so much!! I have a question. How can I create save a POST array of images upload to amazon S3 into MYSQL images table? How would the Repository file look like? I had something going on, but my issue is, whenever I upload like 2 images it saves the first image twice in my DB. I'm tried images.forEach() and images.map(). still the same issue. Your example on here talked about "post" and that's a POST object, but my case is POST array.

  • @taggincrewz8855
    @taggincrewz8855 Жыл бұрын

    Hi Brother , your video is very great and is easy to understand. But I encountered a huge issue when running POST request. It was the very first request at 30:54 of video . Please help me provoiding any suggestion to fix error below as I could not find solution at all. /Users/aashishsapkota/Desktop/nestjs-mysql/src/driver/mysql/MysqlQueryRunner.ts:222 new QueryFailedError(query, parameters, err), ^ QueryFailedError: Field 'username' doesn't have a default value I even tried setting default value to null in our entities but that would only push null username and password. Even if I provided new one. I also tried disabling safe mode but that did not worked at all . I know you might be busy but I could really appreciate your help on this if possible.

  • @PedroHMelo

    @PedroHMelo

    10 ай бұрын

    i am in the same error...

  • @NguyenLong-ob9fc
    @NguyenLong-ob9fc Жыл бұрын

    after finishing this crash course I literally want to marry you

  • @user-jt2zf1lc3v
    @user-jt2zf1lc3v10 күн бұрын

    I need sequelize and MySQL

  • @ansonthedev

    @ansonthedev

    10 күн бұрын

    @@user-jt2zf1lc3v Ok..?

  • @user-br8kr3qj6y
    @user-br8kr3qj6y2 ай бұрын

    Дякую

  • @bobbysihalath8993
    @bobbysihalath8993 Жыл бұрын

    olo

  • @anstbt
    @anstbt Жыл бұрын

    thank you sir

  • @berkcan3475
    @berkcan3475 Жыл бұрын

    repository. create doesnt create entity in sql u should use save

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

    @Column({ default:()=> 'CURRENT_TIMESTAMP', }) createdAt: Date;

  • @AsToNlele
    @AsToNlele Жыл бұрын

    Really enjoying this whole NestJS playlist, thank you for making it! I've found in the docs that for the "createdAt" we can use @CreateDateColumn() createdAt: Date;