Learn Sequelize - A NodeJS ORM | The Best Way to Write Database Queries

[@programmercouple]

If you're a read/write learner, don't worry we got you covered as well, with our articles/newsletters www.theimmigrantprogrammers.com/p/can-you-communicate-with-databases

[@zirace3934]

Honestly! I have been roaming around net, searching for sequelize solutions. Unfortunately I found none. Here I am, landed in your channel. I have no more words but appreciation for unconditional distribution of your knowledge. Thanks a lot. You have earn my subscription

[@programmercouple]

Glad I could help! Thanks a lot for your kind words!:)

[@rudradityajalan2188]

Finally a short and nice guide on sequelize, thanks a lot for it!!

[@programmercouple]

Thanks for your comment! We're happy to help!:)

[@Android-17]

This is the best introductory tutorial on Sequelize. PERIOD.

[@programmercouple]

Thanks so much! Appreciate the comment!:)

[@techexec]

I learnt about sequelize for the first time today, then came across your tutorial this evening, and I must say, 22mins here have replaced hours I spent earlier understanding the concepts. Thank you.

[@programmercouple]

Thanks a lot for your kind words, comments like these encourage us to keep creating more videos

[@blueshadesable]

Fantastic tutorial. You explain everything so clearly before you take actions and begin to code. You give the viewers enough time to follow. Too many times in tutorials on You Tube, content creators will quickly click on other screens, making it hard to follow if we are either taking notes or coding along with you. This video was very well-paced. Thanks so much for sharing this. This vid made me subscribe to the channel :)

[@programmercouple]

Glad it was helpful! Your wonderful comment made my day :)

[@alwayslernin6033]

I'm not sure if I have ever given feedback on a video before. But, everything about your style of teaching is just so good and so refreshing, that I had to comment! You are so easy to listen to and you do such a good job of explaining why you do at each step, often tying it back to the documentation rather than jus trying to fly through a bunch of high level stuff. I can't say it enough - You are really good at this and so helpful! Thank you and keep it up!

[@programmercouple]

Wow, this comment made my day!

[@deepakchawla1105]

thanks , really helped me , i wish you had a complete series of sequelize

[@programmercouple]

One day

[@ianvieira283]

In love with your teaching skills, subscribed.

[@programmercouple]

Awesome, thank you!:)

[@ocoocososococosooooosoococoso]

this is the best tutorial I've seen about sequelize ever.

[@programmercouple]

That's so kind! Thanks, we're very happy to help!:)

[@rakeshg9057]

This is the best ever video on sequelize. All examples on sequelize on net are usually integrated with express server, it was difficult to differentiate sequelize code with server code bcoz they are messed up. Now this video resolved all my doubts. Thanks a lot. Love you couple.

[@programmercouple]

Glad it helped! Thanks for your comment Rakesh 😀

[@ampagetech2624]

Great tutorial , the screen was very clear and readable - an easy to follow tutorials , keep it up and thanks

[@programmercouple]

Glad it helped!

[@MilaValentine]

Thank you for the help, I spent so much time trying to add data to the relationship tables, although it's not what you covered in the video, with the example you gave I was finally able to do it!

[@programmercouple]

Glad it helped!

[@BlackZero880]

I spent a day and came here with successfully creating tables❤ Thanks you very much! Subscribed you as well🎉

[@programmercouple]

Glad to hear this! Appreciate the feedback!:)

[@Randomize-md3bt]

Thank you, I was struggling with Sequelize but I found your video and it helps me a lot

[@programmercouple]

You're very welcome! Happy to help!:)

[@adityasoni3218]

Wow, what a fantastic tutorial! 🙌 I've been struggling to wrap my head around Sequelize with Node.js, but this video made it incredibly easy to understand. The explanations were clear, and the step-by-step guidance was just what I needed to get started. Thanks to this tutorial, I feel much more confident in using Sequelize in my projects. Keep up the great work, and I'll definitely be checking out more of your content!" 👏📚🚀

[@programmercouple]

Appreciate the honest feedback! Cheers!

[@superman1337H]

I am very grateful to you, because you explain it very well and easy to understand.

[@programmercouple]

Glad to hear that

[@codekicks2171]

you have explained really well, please make videos on more topics, it really helps a lot

[@programmercouple]

Thank you for saying that, it boosts our will to make more content

[@swuh87]

Thank you so much for the tutorial. You explain it so well. Was able to get through the part of my project I was stuck on for a couple of days. Thanks again

[@programmercouple]

Thanks for your feedback! I’m glad it was helpful:)

[@emanuelacosta2541]

Hello! I love your content and your way of explaining things! Keep up the good work!

[@ibraheemhajjar91]

thank you so much for simplicity and direct explanation, keep up the good work!

[@programmercouple]

Glad to hear that! Thanks!

[@mddawoodalam6283]

Thank you for this amazing tutorial. Loved it and your way of teaching/explaining is very exciting to watch the video till the end. Thanks

[@programmercouple]

You're very welcome!

[@qanol]

best Sequelize on youtube , crystal clear

[@programmercouple]

Thank you 😃

[@charlesfreitas2092]

Such a great tutorial, perfect. Thank you so much. Greetings from Brazil. ❤️

[@namansingh8081]

Thank you so much for this tutorial, it was really helpful for understanding the syntax and working of sequelize.

[@programmercouple]

Great to hear!

[@amityadav-or2ys]

really helpful, I would like to see more videos on sequelize.

[@programmercouple]

More to come!

[@viekva]

Best sequelize tutorial EVER

[@programmercouple]

Thanks, glad it helped!:)

[@cesarpintos8418]

Great explanation! Thank you very much, please use async await in next videos, promise chaining looks awful

[@programmercouple]

Thanks for your comment!:)

[@akulateja9011]

super awesome explanation mam 😍😍😍😍🤩🤩🤩🤩

[@programmercouple]

Glad it was helpful!:)

[@rshekhar11]

By the way force sync is not always used, it is used only when you are planning to recreate the tables. If you see in the console it clearly states the drop table command and created it again. There is no need to drop tables for adding new records

[@programmercouple]

If only you'd watched the video a little more, I did explain all of that in the video, in addition, to explaining why I am going to keep on using it in the video for demo purposes, so that we start fresh every time I re-run my script! Nevermind, thanks for your comment! Keep learning:)

[@EpicToEdge]

@@programmercouple with v6 force true does not work, instead we are now using alter

[@reanibutani9555]

Easy to understand explaination, I subscribed... Please make more tutorials.

[@programmercouple]

Thanks!!! Anything in particular that you would like to learn??

[@sameera-dananjaya-wijerathna]

really helpful resource. from Sri lanka

[@programmercouple]

Hello there, thanks for your comment! Happy to help!:)

[@saimanish3385]

Hi Madam.Thank you very much for sharing the knowledge with us.Please make a video on creating a model for already existing table structure which is managed by DBA people in production environment.

[@programmercouple]

Noted

[@SavageStar245]

Amazing Tutorial, it gave me a smile when u mentioned Chandler Bing 😁 #FriendsFan

[@programmercouple]

😁

[@parthokr]

Wow so professional. Thank you.

[@kirthisa8674]

Hi krithika Thanku for excellent explanation on sequelize, I'm a Beginner,I need to know Is hasmany works on Innerjoin concept,I need to Innerjoin two tables

[@rahulk7348]

For Production Ready application we have to use Transaction concept. Could you please cover in your future video.

[@akshaybisht2660]

What a lovely tutorial. Loved the content just did not understood how did you made foreign key by customer id on order table from customer id field? Explain me this and you have new subscriber as well. Appreciate your lovely content 💖

[@programmercouple]

This might help you better understand the concept: sequelize.org/master/manual/assocs.html#special-methods-mixins-added-to-instances

[@beautifularabic5886]

Thank you for the amazing video! Amazing explanation! Excellent teaching skills.

[@programmercouple]

Glad you liked it!

[@surajgadage6004]

Great explanation Thank you ☺️

[@programmercouple]

You’re welcome 😊

[@mouri_p]

Nice and clean👏

[@programmercouple]

Thank you! Cheers!

[@chavvobimbo5474]

Hi, are you also able to retrieve the customer name & email with the order details, depending on the customerId foreign key?

[@programmingwithnit5308]

Good for me

[@programmercouple]

Glad it was helpful:)

[@shravan.shandilya]

The force sync is going to dump data on restart. It works for this particular case or just for developer environment. Please make video about how migrations can be done using sequelize.

[@RahulGupta-pj1ux]

How can I perform select and insert queries on manually created tables? Do I need to define model for them? Or is there a way I can reference already existing table in my database?

[@programmercouple]

Great question! Yes, so in order to use Sequelize even with the manually created tables you need to define the structure of the model inside your code.

[@RahulGupta-pj1ux]

@@programmercouple Thank you. Can you also make a video about concepts like pooling and handling database connection error at production level using sequelize? It would be very helpful.

[@programmercouple]

Noted

[@mraja6654]

Hi, when i set force true it dropped every table. How to fix it and any idea about sequelize migration with typescript.

[@programmercouple]

You can just unset the force field, mark it as false.

[@mraja6654]

@@programmercouple Thanks for your reply, when i set force false it not add the new field in existing table.

[@akchelsea6635]

Thank you so much, that helps a lot

[@programmercouple]

Thanks, glad to hear that!:)

[@chris_ea]

Instead of Orders.findAll can you do findAllOrders on the ParentObject Customer?

[@mailercatch2424]

The final select query is querying by orderId and not customerId, where clause is wrong.

[@programmercouple]

Oops, made a mistake there! Thanks for letting us know 🙂

[@beautifularabic5886]

@@programmercouple what can we do to correct that where clause? what should we write instead?

[@programmercouple]

You could just say: Order.findAll( { where: { customerId } } )

[@karankate4838]

Thanks you soo much for the tutorial its very helpful for me 🥰

[@programmercouple]

Glad it helped 😊

[@siddheshmhatre2389]

best one💥

[@programmercouple]

Thank-you, we really appreciate it!:)

[@YishaiYT]

so clear. thanks a lot !

[@shihabudheen3]

Lovely tutorial😍

[@raulgogna3420]

Good video and clear knowledge. Do you recommend this language to connect as a backend with Flutter Front-End for an App mobile?

[@programmercouple]

Thanks! Any database can be used with Flutter. The real answer depends on the kind of application you're planning to build. That alone can decide if SQL or NoSQL is better for you.

[@abukhalidrifat3994]

Is it okay if I write my relations inside the model that is after creating the schema. Will it work?

[@toushikahmedpronoy667]

thanks for making it so simple

[@programmercouple]

Happy to help

[@abhisheksrivastava6659]

I need a help from your side ,,, I have one table which may be join with many table ,, so I can't use association.. with two field it join that table ,,, .. then how to implement join .. in this regard ...

[@virenkamra5050]

Just a suggestion in 15:20 this is not the right way to create an order and customer must be the one creating an order instead of tweaking the table directly via Order.create() when you return the customer promise with return Customer.create({ values }) on line number 12 you receive a customer sequelized value so in the next then block where youre adding the Order must be like customer.createOrder({ values if required }) where createOrder is a method developed by sequelize under the hood in relation to your second Tables named Order with preceding keyword create

[@oussemaayari4838]

you're awesome, keep going

[@programmercouple]

Thanks, will do!

[@janakiraman2482]

Good explanation. Thanks

[@programmercouple]

Glad it helped:)

[@akashaher1001]

Hello mam... I liked your content... 💯 How can I use one sequelize model for creating multiple tables? Because I just want to store records year wise in separate table. all the fields are same. I want to use same model instance for that

[@hablu]

Is there any option to query select data from tables of two different database

[@newagene8276]

How can I define a model for already existing tables which have tons of data and which I cannot manupilate?

[@venkateshe7506]

Simple and neat. Thank you

[@programmercouple]

You’re welcome 😃

[@bkcy18]

Any way to get the code from db itself? Like, I'm using vs as an ide and for .net applications there is an option to import the database as a model and we get c# classes for the tables. Is there a way to replicate that behavior with vscode (or any other ide) for sequelize

[@WilcoGroothand]

Perfect to start with. thx

[@mustafaagha8834]

Which is better from performance and security prospective - using ORMs or Knexjs (or a likes) or using raw queries. For large scale projects

[@programmercouple]

Hi Mustafa, thanks for your question. So, performance-wise RAW SQL will always be better hands down! ORMs are mostly used for the (abstraction) convenience they provide. For security, although, query builders and ORMs do offer some basic security, IMO that's something you need to take care of as a developer in all cases, no matter what you choose(Raw SQL/Query Builders/ORMs). You need to restrict as well as validate user inputs to avoid SQL Injection. However, most ORMs offer in-built support for Input/Schema Validation. Hope that answers your question!

[@mustafaagha8834]

@@programmercouple thank you this was really helpful

[@programmercouple]

We’re glad! Happy Programming:)

[@pavanshinde]

Great video... thanks

[@javierrusso9576]

Thanks a lot 4 this.tutorial!

[@devanshusharma9098]

There is a query -select a.id, b.id ,b.name from a.products,b.users where a.id=1 and b.id = a.user_id(foreignkey). How can we write this in sequelize?

[@programmercouple]

Please refer the docs :)

[@muhammadomarazhar8320]

Amazing, thank you

[@programmercouple]

Glad you found it helpful!🙌🏻

[@arihantjain8347]

Nice..🙌

[@programmercouple]

Thanks ✌️

[@beamer5404]

You need not use --save for saving in the dependency list, it's default now. For dev dependency, you need such explicit flag, like -D.

[@programmercouple]

That's good to know. Thank you!

[@cheeaunlee7530]

How to organize models using different schemas? Example: accounts.payments, sales.payments, same table name, different schema

[@prabhasinigiri9011]

Awesome video ..

[@programmercouple]

Glad you enjoyed it

[@mohamedyoussef8835]

Awesome video ++++++++++++++ 🙂

[@programmercouple]

Thank you!:)

[@sergeykiparenko1195]

You are the best

[@loribryant4999]

I thing id object is no need to add for the model

[@Infinite1]

Im new to Sequelize and the Video helped me a lot but I come to one question. What if I have multiple orders? Say if the same Person has 2 Orders howto associate the second with the rest?

[@kunalrajput4539]

great video

[@programmercouple]

Glad you enjoyed it!

[@habitzenglish5986]

please make new video about relational db

[@programmercouple]

That's the plan

[@abhisheksrivastava6659]

hmm .. can you please explain us how to sanitize data in standard form ... :( ...

[@vishtigote2450]

Thanks you so much for this. but I have noticed one thing in the util file you have accidently keep you phone number as password if it is genuine then please clear that password.

[@programmercouple]

Thanks, and the number’s fake 😊

[@tamaldas3544]

need tutorial from scratch ....how you have built the project structure ?

[@programmercouple]

You can google the best practices to create project structures in NodeJs. This is a really good article on this topic blog.logrocket.com/the-perfect-architecture-flow-for-your-next-node-js-project/

[@dorbenmoyal7639]

Thanks...!

[@programmercouple]

Glad I could help!:)

[@chris_ea]

Thanks!

[@pinnumishra4563]

Thanks 😊

[@programmercouple]

You're welcome!

[@programmingwithnit5308]

Thank you

[@programmercouple]

You're welcome!

[@csstudios7429]

thanks a lot mam

[@programmercouple]

Most welcome 😊

[@sriram-ze5dq]

Its shows as sequelize.define is not a function error

[@programmercouple]

Checkout this link - stackoverflow.com/questions/49470508/sequelize-define-is-not-a-function Also, check that you're not making any obvious mistakes.

[@codemoor]

How Can I Use Json

[@fiendsgaming7589]

thnx

[@s1nistr433]

Good video but createOrder does not work at all

[@sanjayism]

TypeError: Customer.hasMany is not a function at how get rid of this error

[@hovhannisyanprod9024]

!

[@balajic4684]

do upsert and then only this video will be true waste of time !

[@akashrajawat3004]

customer.createOrder didn't worked for me, It's giving me type error saying customer.createOrder is not a function

[@crypto.vip-class]

TypeError: sequelize.define is not a constructor ?? some help ??