about a year and a half ago i started learning Html , Css, Javascript, now i got hired as a React Native dev, im thanking all my learning channels. This is one of the best, keep the good work, and thanks, man!
Dear my FSJ. Thank you 1.000.000.000 times. This is my first video after many try/catch in Node world. It works also for me. Incredible. Thank you very much for sharing your knowledge. Best regards, Štefan.
Absolutely incredible tutorial. I've been a professional dev for 4 years and I'm working on migrating some legacy code. Even though I was planning on skimming to just see package use and connection details I ended up sitting through the whole thing. very well done!
🇲🇫 This is a beautiful, simple and clear tutorial as well as the well-established MVC architecture. Thank you very much for everything and especially good luck we will be there to follow you.
Thank you Sir for this wonderful Tutorial .I did not Know how to use oop concept in developing rest api . The code was just beautiful . Thank you ❣️❣️❣️
Not gonna watch it now but I benefitted so much for the shopping cart mern tutorial video that I just wanted to drop by and leave a like and a comment ASAP :D
i wish you could turn you mic volume up, cause right now my volume is at 100%, and i can barelly hear your voice....but besides that that this is a awesome great tutorial, thank you 😎👍
Great tutorial, thanks. Just one question. Is it not neccesarry to release / close the connection after db.execute(sql) ? Or is it handled in this case automaticly?
I'm also follow this kind of coding pattern from MVC. it's more maintainable. but what i'm thinking is, it may occur some memory leak issue because it just create new instance from Post model but not reuse any of instance. when we get ORM every ORM has some caching mechanism for reuse previous created instance.
Hello, Thank you so much for the video but just a quick question, if you are hosting your database locally would that mean your computer has to be running 24/7 If you plan on using this database for a live website?
MongoDB is much easier to work with in my opinion. Structuring your data is easier to understand most of the time. But again I have used and still use both. For some the one is better choice than the other. For me I would still give mongodb the lead specially when working with the rest of the JavaScript stack (MERN, MEVN, MEAN).
@@the_full_stack_junkie Yeah, I felt MongoDB was very intuitive, coming from frontend React and using Firebase. I see a lot more job postings for SQL however, so really appreciate you posting this video. Thanks! :D
Hey man I am not really familiar with microservices, yet. I have done one course on it but I hasn't been something I have been actively working with. Would really recoomend checking out udemy, stephan grinders course on microservices in nodejs.
Sir, can we stop connection after connection because for aws always needs to start server. How i do it. Please give hint by syntax..where i destroy the query and how to add prod database user name and password..if u reply soon that helps me alot..and for this video realy realy awesome..
So the models are made to represent the schema of the table in the database. And the controllers are then made to use the models and work with the database. So you can see it as such that a controllee can be for example for each one of the entities (posts, comments, users etc). But this in not always the case you can make controller methods for different things. But the controllers job is to work with the models and do some business logic
34:31 That would be a very poor practice in production. You're supposed to escape the values to prevent SQL injections: VALUES (?, ?, ?) and pass the actual values into the `execute` method: await pool.execute(sql, [this.title, this.body, createdAtDate]);
how do you the Updating part. static update(vorname, nachname, id) { let sql = `UPDATE Anbieter SET vorname = ${vorname}, nachname = ${nachname} WHERE Anbieter_id= ${id};`;
I'm looking forward to the update. I have code but it error in postman exports.updatePostById = async (req, res, next) => { try { let { title, body } = req.body; let postId = req.params.id; let [post, _] = await Post.updatearticlebyid(postId, title, body); res.status(200).json({ post: post[0] }); } catch (error) { console.log(error); next(error); } };
about a year and a half ago i started learning Html , Css, Javascript, now i got hired as a React Native dev, im thanking all my learning channels. This is one of the best, keep the good work, and thanks, man!
Congratulations champ
inspiring
Any advice on how to get a remote software Job?
@@hexparadusyoutube7428 i just upload a profile in LinkedIn and in the third interview got the job
@@historianooficialunofficia2085 Is it a remote one and did you apply by 'Easy Apply' on LinkedIn or was it a regular Apply?
Starter files: github.com/LloydJanseVanRensburg/Node-Express-starter
Ending files: github.com/LloydJanseVanRensburg/Node-MySQL-Tut
Thanks
Dear my FSJ. Thank you 1.000.000.000 times. This is my first video after many try/catch in Node world. It works also for me. Incredible. Thank you very much for sharing your knowledge. Best regards, Štefan.
To be honest, I'm astonished by how well you explain everything. I'm speechless. Great work!
Absolutely incredible tutorial. I've been a professional dev for 4 years and I'm working on migrating some legacy code. Even though I was planning on skimming to just see package use and connection details I ended up sitting through the whole thing. very well done!
🇲🇫
This is a beautiful, simple and clear tutorial as well as the well-established MVC architecture. Thank you very much for everything and especially good luck we will be there to follow you.
Thanks so much champ, very glad you found it helpful.
Keyboard tips are so cool man, thank you for that 😊
Thanks for these amazing videos. From nothing to be able to build my University project. I learned everything from your videos.
Awesome so glad it helped
@@the_full_stack_junkie Yes, It really helped me, even I still watch your videos when I stuck somewhere.
Thank you so much, You made the whole process seamless to follow along as I practice
great video sir cleared all of my consfusions about promises
Glad it helped
Thanks you so much I really needed a refresher :) Maybe a bigger project using mysql or an Orm would be great to follow :)
Will do
Thank you so much for this tutorial. You did an excellent job explaining things.
Glad it was helpful!
You are making my full stack journey amazing. Please try to upload videos frequently.
Literally Awesome explaination.🙌🙌
Thank you Sir for this wonderful Tutorial .I did not Know how to use oop concept in developing rest api .
The code was just beautiful .
Thank you ❣️❣️❣️
I just discovered your channel, and it's fantastic.
continue, and thank you
This video helped me so much thank you
This channel is really a gem!!
Thank you sir for all the knowledge transfer 🤩🙌
Thanks for your positivity really do appreciate it🙏🤓
Not gonna watch it now but I benefitted so much for the shopping cart mern tutorial video that I just wanted to drop by and leave a like and a comment ASAP :D
Thanks man. Just showing of the basics here nothing much just wanne show what I learned recently✌🤓 but thanks for the comment! And like
Thank you. This was quite helpful. Straight forward.
11k subs completed.👍👍👍
Thanks for the support will give you shout out in next video.
Question: do I need to use workbench or can I also use phpmyadmin without having to change any code? Nice video!
Great tutorial if you have some experience with this from before, but very tough if you're new.
Thank you very much, its really helpful for my project
i wish you could turn you mic volume up, cause right now my volume is at 100%, and i can barelly hear your voice....but besides that that this is a awesome great tutorial, thank you 😎👍
Ooo wow thanks man will definitely turn it up next time didnt know it was to soft my bad. Glad you found it helpful
Great tutorial, thanks. Just one question. Is it not neccesarry to release / close the connection after db.execute(sql) ? Or is it handled in this case automaticly?
Amazing video, thanks sir!
Thank you greetings from 🇨🇺
Thank you sir!🥸
I'm also follow this kind of coding pattern from MVC. it's more maintainable. but what i'm thinking is, it may occur some memory leak issue because it just create new instance from Post model but not reuse any of instance. when we get ORM every ORM has some caching mechanism for reuse previous created instance.
Hello, Thank you so much for the video but just a quick question, if you are hosting your database locally would that mean your computer has to be running 24/7 If you plan on using this database for a live website?
Yes you will need to keep you computer on
great video!!!!
Great Content😀
Good tutorial thank you sir
thank you so much. excellent work
it's what i was looking for but i don't understand what we have to manually create the database and table instead of just doing it with mysql2
You are always awesome thank you mate..... Hoping to see image upload in this video....
good tutorial, the volume cud be louder
Awesome! I learned node and mongo thanks to you. How do you like mongodb compared to SQL?
MongoDB is much easier to work with in my opinion. Structuring your data is easier to understand most of the time. But again I have used and still use both. For some the one is better choice than the other. For me I would still give mongodb the lead specially when working with the rest of the JavaScript stack (MERN, MEVN, MEAN).
@@the_full_stack_junkie Yeah, I felt MongoDB was very intuitive, coming from frontend React and using Firebase. I see a lot more job postings for SQL however, so really appreciate you posting this video. Thanks! :D
Always good to know SQL its not going anywhere. Glad you found the video insightful. More videos coming soon.
Hello thank you for this wandeful tuto.But i have this error during registration: TypeError: Post is not a constructor. How can i salve this please ?
Some nice SQL injections if you push this code to production.
Thank you the video is so good
Sir please make on one video microservices node js tutorial
Hey man I am not really familiar with microservices, yet. I have done one course on it but I hasn't been something I have been actively working with. Would really recoomend checking out udemy, stephan grinders course on microservices in nodejs.
Hey please make video on mysqul series.
much helpfull sir!
Thanks dear.
Hello! How i can use transactions?
Sir, can we stop connection after connection because for aws always needs to start server. How i do it. Please give hint by syntax..where i destroy the query and how to add prod database user name and password..if u reply soon that helps me alot..and for this video realy realy awesome..
Can you do some MERN Social media app
Thank you ;)
Thank You
good job .. keep uploading ...
Thanks man Reddit Clone (React, Redux Toolkit, Node, MySQL) coming soon
Can you also add update and delete operations?
do you make model and controller for each one and one, for example users , posts, etc...
So the models are made to represent the schema of the table in the database. And the controllers are then made to use the models and work with the database. So you can see it as such that a controllee can be for example for each one of the entities (posts, comments, users etc). But this in not always the case you can make controller methods for different things. But the controllers job is to work with the models and do some business logic
Hey i want video on hooks. Please make a one video on this
when you deploy your backend, what do you put in process.env.DB_HOST...obviously it is not localhost anymore
please continue mongodb series 🥺🥺
Waiting for Nodejs with postgress 👀
love
Awesome video ++++++++++++ 🙂🙂
which color theme do you have for vs code?
Cobalt
wich web server can I use to node.js and mysql?
i am having axios api issue in react native app, the axios api works fine in postman but not in the app, it send {} body to server.
Bro when will e-commerce tutorials be on page
Which Theme You Use in Vs Code Editor
34:31 That would be a very poor practice in production. You're supposed to escape the values to prevent SQL injections:
VALUES (?, ?, ?)
and pass the actual values into the `execute` method:
await pool.execute(sql, [this.title, this.body, createdAtDate]);
No doubt, this is only a proof of concept buddy. No need to be pedantic about things.
github link?
everything is good but why audio is so down?
how do you the Updating part.
static update(vorname, nachname, id) {
let sql = `UPDATE Anbieter SET vorname = ${vorname}, nachname = ${nachname} WHERE Anbieter_id= ${id};`;
return db.execute(sql);
}
this isn't working
I'm looking forward to the update. I have code but it error in postman
exports.updatePostById = async (req, res, next) => {
try {
let { title, body } = req.body;
let postId = req.params.id;
let [post, _] = await Post.updatearticlebyid(postId, title, body);
res.status(200).json({ post: post[0] });
} catch (error) {
console.log(error);
next(error);
}
};
🌻
SUBSCRIBED.
GREAT CHANNEL, THANK YOU FOR THE AMAZING CONTENT🙌
(please if you have a change make a PRISMA & GRAPHQL tutorial, that would be awesome)
please upload update api
In ur ecommerce series there is no search feature.😕
what is the dotenv module?
Basically helps us set env variable in our node app. Gives us access to process.env.
heyy can someone help me to fix that error # - access denied for user 'root'@'localhost' (using password no)
where is the git clone link ?
The post comment at the top.
@@the_full_stack_junkie not there
@@the_full_stack_junkie its not there bro
It's quite unusual to hear about NodeJS & MySQL being used together.
Why are all these people using it with Mongo DB ? Just a trend ?
Nodejs can be used with almost any db. Mongodb just has a very populate syntax which is JS like so just keeps things lookin like JS.
i can hear a mzansi accent...?....?....? ❤❤
Fo sho 🤙🏼