How to Use Sequelize ORM in NodeJS - Tutorial

Checkout my discord for any questions: / discord
-
Hi guys, in this video I teach you guys how to use a SQL ORM called Sequelize. This will allow you guys to handle database queries using an object structure.
-
Please leave a comment on what topic you guys want me to cover next!
SUBSCRIBE!
Social
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Website: machadopedro.com
Twitter: / machadop1407
Instagram: / _pedro.machado_
Github: github.com/mac...
Email: [e-mail]

[@joshuahamann2075]

9:45 "You can see that its going to give an error" - How I always feel when I'm coding. Thanks for taking the time for this tutorial.

[@vieiratn]

The difference between mysql and mysql2 is basically promises. The package mysql2 allows you to work with asynchronous JS. Thanks for the video bro.

[@PedroTechnologies]

Thanks for sharing! I actually never realized this. This can be helpful cause ive been caught in callback 'hell' situations using mysql.

[@markokafor7432]

You didn’t need to install path and fs. They are built in node js modules

[@PedroTechnologies]

Yes

[@angelbythewings]

@@PedroTechnologies Also its not require, its request and response 😄

[@PedroTechnologies]

@@angelbythewings yep, i explained that in the past hahaha i used to call it required and response because thats how i said (in order to understand) back when i was learning. I shouldn’t have used that in the video but when i made this video i was grtting like 3 views per video so i didnt think it would matter hahaha nowadays i say request in my new videos

[@angelbythewings]

@@PedroTechnologies that's completely understandable. Sorry if you already knew, I shouldn't have pointed out. BTW it was a very nice tutorial

[@PedroTechnologies]

@@angelbythewings nahhh its good hahahha i really appreciate it cause other people can see it! I sometimes don’t like my old videos cause im scared that i used to say dumb stuff like this lmao

[@lucylu184]

Your videos helped me get an internship. I'm really grateful.

[@PedroTechnologies]

Wow thats amazingg! If you don't mind, where you going to work? This makes me very happy!

[@cooperathletics6278]

Concise and straight to the point! Beats these 3 hour crash course vids. Thanks for the tutorial.

[@PedroTechnologies]

Thank you! Really appreciate it!

[@tekhaven]

@@PedroTechnologies Awesome tutorial and very straight to the point

[@CourageousCreatives]

Another really great run-down on a topic! Thanks!

[@PedroTechnologies]

Glad you enjoyed it!

[@parasarora5869]

Amazing tutorial sir!!... you cleared my doubts regarding sequelize in one go 👍👍

[@PedroTechnologies]

Glad to hear that

[@Porrruh]

Pedro the way you explained it clicked really well thank you keep up the good work. Will look for more posts :-)

[@PedroTechnologies]

That makes me happy! Thank you so much!

[@aksaurooj838]

when i write sequelize init i get an error The term 'sequelize' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At line:1 char:1 + sequelize init + ~~~~~~~~~ + CategoryInfo : ObjectNotFound: (sequelize:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException PLEASE HELP

[@fredrickemmanuel479]

am also getting same error

[@blakebard]

npm install -g sequelize-cli

[@uktech9432]

Honestly it was very well explained ❤.

[@triptisingla4897]

bestest video in the whole worldd, i am saying you are the best, I have been searching everywhere but here my search got results, thankksssssss

[@anonlegion9096]

11:50 req does not mean "require", it means "request", the req and res in (req, res) => {...} literally means request and response 13:55 that if(err) is redundant, the .catch() is called only if err is thrown... the only useful thing to do with conditionals inside the .catch() is handling different kinds of errors

[@tekhaven]

Please can you do a tutorial on Table relationship? Really need that with sequelize

[@PedroTechnologies]

Some people requested this, I plan on doing it!

[@xxfrizzzerxx6890]

Need it !

[@waynefaustorilla]

Yes please

[@MrChilo89]

yes please

[@unsolvedstories1016]

Beautiful and most required video 🙏

[@ibrahimacanada]

Always great thanks !!

[@gokulkurup1584]

Really Helpful. Thanks for the great tutorial !

[@PedroTechnologies]

Glad it was helpful!

[@Cynthia-cw6kd]

Love this, thanks!

[@k303k]

Thanks for the video Pedro!

[@danielkibby6601]

This is great, so I glad I found your video :D

[@austin96tig]

That was a really good explanation!

[@PedroTechnologies]

Glad you liked it!

[@TolaFoundationMw]

🔥🔥🔥

[@user-jr5ky9lv6g]

You can also use Postman to test different methods like post without frontend at all 14:40

[@jabezraja9383]

i really appreciate your effort... it was very usefull for me

[@PedroTechnologies]

Glad it was helpful!

[@ianpropst-campbell6028]

Thank you for this helpful tutorial!

[@Spmdiamond]

Love you bro thanks a lot it is best way to learn for beginners

[@Pareshbpatel]

An excellent introduction to using Sequilize to perform CRUD Operations on a mySQL database. Thanks, Pedro {2023-06-05}

[@stonecomstock]

this was very helpful! thank you

[@user-hb6vu3xu9c]

thank you sir, useful and easy to understand

[@shivarammuthukumaraswamy7164]

Thank You. Really helpful.

[@PedroTechnologies]

Glad it was helpful!

[@thesinged196]

sequelize: command not found help me pro plssssss!!!

[@Vir7uaLGameplays]

What about connection to multiple databases? What's the best approach? Btw if you could make an updated version of this video it would be great because sequelize is a bit implementation is a bit different now.

[@hyphenbruh7376]

Hi, I’m new to the Sequelize ORM utilities, but I imagine you would need to instantiate another instance of Sequelize and pass it your other databases’ configuration settings (i.e. name, port, password, username, etc.) The Sequelize instance in ./models/index.js in the video only creates one database object with its corresponding tables. Not sure how you would implement it using DBMS other than MySQL though. ps. Not sure if this is the best approach for making multiple database connections, or if this is even right at all, so take it with a grain of salt.

[@josesoltero6057]

thanks so much for this video!!!

[@aadarshaacharya267]

Why do we have to pass sequelize & DataTypes ad parameter in Models. Can't we directly import from sequelize ? like const { DataTypes, Sequelize } = require('sequelize');

[@PedroTechnologies]

You could do it both ways! Passing it as a parameter is a standard for the sequelize-cli, but if your not using it than you probably should just import it!

[@MarsTheProgrammer]

Thanks for the videos, i have a question. Is there a library for autocompleting sequelize syntax? I tried a few but they don't seem to work.

[@MarsTheProgrammer]

nvm, i found the solution, sequelize init imports it wrong for the models. It should be like this: const { Sequelize } = require("sequelize"); Not like this: const Sequelize = require("sequelize");

[@PedroTechnologies]

Awesome! Yeah, they are exporting Sequelize as a separate variable so to get the autocomplete you have to put the brackets. Glad you fixed it!

[@PanlasangMotour]

Thank you i learn a lot can you make it with front end an todo task application so that others can deep dive learn using with node js express pug integration

[@PedroTechnologies]

I have a an example of how to make a todo list application on my 3 part series called: CRUD Tutorial ReactJS ! I don't use sequelize on that series, but transferring the normal mysql logic to sequelize is pretty straightforward!

[@fedeabj]

Hi Pedro, how are you? I have a question, is this way of doing queries safe? Is this the frontend interfacing with the db directly? Im not sure about those things. Thank you!

[@tigranavagyan5922]

Thank you a LOT!!!

[@earlgrey8611]

You export your model function from User.js which is an anonymous function that takes 2 params - sequelize, DataTypes. I don't understand how when you then import this function as db you don't have to pass an instance of sequelize and Datatypes to it? How can you simply say db.sequelize.define (....) -- shouldn't you have to say db(sequelize, DataTypes).define ( ... ) ??

[@programmingwithnit5308]

Thank you brother

[@maelstrom57]

Bro, path and fs are native NodeJS modules.

[@Omkara2664]

Nice bro 👌👌

[@lg-25]

How to retrieve the data use sequelize mysql when we insert execl data in database of three tables

[@xbzq]

When I saw that you npm installed fs and path I realized you have no idea what you're talking about. These modules aren't packages. They are internal modules provided by nodejs itself. Thinking you need to install these demonstrates a great lack of experience with the platform.

[@yonatanshalev9428]

Great tutorial, thanks! Any chance to get the GitHub repository to clone?

[@DeveenRathnayake]

hello, I got an error when I coding with your video. const model = require(path.join(__dirname, file))(sequelize, Sequelize.DataTypes); ^ TypeError: Class constructor model cannot be invoked without 'new'

[@PedroTechnologies]

Did you install 'path'? This error occurs in the file generated by the cli so that is weird hahaha I would try restarting the server!

[@DeveenRathnayake]

Yes I installed it too. Now problem is okay. I figured it out

[@kishorep3376]

Cannot read properties of undefined (reading 'findAll') what can I do!

[@mr.hassaan7785]

please zoom the screen or increase font size. ur screen is too big, does not mean that others have the same... if i watch it on mobile, the font is too small. barely reading

[@7gsReef]

what is the application you use to see your database and know whats inside it?

[@theverybestdev]

please upload about associations in sequelize

[@PedroTechnologies]

This should be an interesting video idea! I will make one!

[@theverybestdev]

@@PedroTechnologies awesome thanks

[@tekhaven]

@@PedroTechnologies i really need the association because i am having problems with table relationships

[@davidanwar6996]

what should i use, pure SQL or Sequelize?

[@PedroTechnologies]

It depends on what is your application. However in a Job or an advanced project, usually you would use Sequelize. Its a lot more handy to use an ORM like Sequelize because then you don't need to write actual SQL. It is a way to convert SQL to normal JavaScript, so thats why almost every company uses it.

[@davidanwar6996]

@@PedroTechnologies thank's .

[@premalatha5182]

Hi very helpful video but i have an doubt could you pls help me to update the record using sequelize

[@navinwadhwa595]

Why app. Get for inserting.. It should be app.post??

[@HHHanant]

Hi great video, need your help in one question. I have two DBs in mysql. In DB1 we have person table and DB2 we have gender table. I have to do association between DB1.person and DB2.gender. can you help me with this.

[@MrChilo89]

i had to use this command on bash "powershell Set-ExecutionPolicy RemoteSigned" on VS to skip the problem "cannot be loaded because running scripts is disabled on this system."

[@saladin_advanced]

Thank you.

[@QuickTuts]

Isn't fs and path built-in Nodejs? Why are you installing them?

[@aakarshanthapa889]

Hello Pedro, I wanted to use ES6 modules for importing, but can't figure out how to change the require imports to es6 inside models/index.js file

[@govinda399]

use "type" : "module" in your script file

[@sang4005]

I run into same error

[@sridharkatta3461]

i think path and fs are inbuilt packages in nodejs so we dont need to install them

[@jtcheng1805]

I failed at step: sequelize init, return "sequelize : unrecognizable. previous step: npm install... seems ok with npm warning server@1.0.0 no description. help please

[@jtcheng1805]

fix it with npx sequelize init help from previous comments,

[@hichamamroussi9087]

thank you !@@jtcheng1805

[@nathansantos4197]

how can I read a database.sql file in node js? I need to read this in my React js project using node Anyone can help me?

[@PedroTechnologies]

What do you mean? You want to use an existing database or create a new one?

[@nathansantos4197]

@@PedroTechnologies I want to use a existing database file. I need to read this database to get some data

[@alexdev5734]

Why would you want to install fs when its built-in to nodejs

[@sang4005]

I wonder too, both path and fs are built-in to nodejs

[@instant-code]

where is next tutorial

[@PedroTechnologies]

This was a long time ago, but I should probably create a new series! Sorry about that!

[@matthewclarke1926]

The ORM dream. Just write SQL.

[@ibrahimmainge]

You don't need to install fs and path.... It's core modules!

[@kishore2398]

How to update pls tell me brother

[@note_to_you]

how to make SELECT * FROM posts join users on posts.UserId = users.id in sequelize.

[@pankajsuryavanshi8332]

Build once again project.