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.
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
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 ❣️❣️❣️
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?
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?
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); } };
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.
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
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 😎👍
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..
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?
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!
Keyboard tips are so cool man, thank you for that 😊
🇲🇫
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.
Starter files: github.com/LloydJanseVanRensburg/Node-Express-starter
Ending files: github.com/LloydJanseVanRensburg/Node-MySQL-Tut
Thanks
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
Literally Awesome explaination.🙌🙌
great video sir cleared all of my consfusions about promises
Glad it helped
I just discovered your channel, and it's fantastic.
continue, and thank you
Thank you so much for this tutorial. You did an excellent job explaining things.
Glad it was helpful!
This video helped me so much thank you
You are making my full stack journey amazing. Please try to upload videos frequently.
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
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
This channel is really a gem!!
Thank you sir for all the knowledge transfer 🤩🙌
Thanks for your positivity really do appreciate it🙏🤓
Thank you. This was quite helpful. Straight forward.
11k subs completed.👍👍👍
Thanks for the support will give you shout out in next video.
Amazing video, thanks sir!
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 ❣️❣️❣️
Thank you sir!🥸
Great Content😀
great video!!!!
Thank you very much, its really helpful for my project
Hello! How i can use transactions?
Thank you greetings from 🇨🇺
thank you so much. excellent work
Question: do I need to use workbench or can I also use phpmyadmin without having to change any code? Nice video!
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?
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 tutorial if you have some experience with this from before, but very tough if you're new.
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
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.
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 ?
Good tutorial thank you sir
much helpfull sir!
Thank you the video is so good
Hey please make video on mysqul series.
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);
}
};
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.
Can you also add update and delete operations?
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.
good tutorial, the volume cud be louder
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
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
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.
github link?
when you deploy your backend, what do you put in process.env.DB_HOST...obviously it is not localhost anymore
You are always awesome thank you mate..... Hoping to see image upload in this video....
wich web server can I use to node.js and mysql?
Can you do some MERN Social media app
which color theme do you have for vs code?
Cobalt
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.
Some nice SQL injections if you push this code to production.
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..
Thank you ;)
Thanks dear.
Which Theme You Use in Vs Code Editor
good job .. keep uploading ...
Thanks man Reddit Clone (React, Redux Toolkit, Node, MySQL) coming soon
heyy can someone help me to fix that error # - access denied for user 'root'@'localhost' (using password no)
everything is good but why audio is so down?
Hey i want video on hooks. Please make a one video on this
Awesome video ++++++++++++ 🙂🙂
In ur ecommerce series there is no search feature.😕
Thank You
Bro when will e-commerce tutorials be on page
Waiting for Nodejs with postgress 👀
please upload update api
what is the dotenv module?
Basically helps us set env variable in our node app. Gives us access to process.env.
please continue mongodb series 🥺🥺
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
SUBSCRIBED.
GREAT CHANNEL, THANK YOU FOR THE AMAZING CONTENT🙌
(please if you have a change make a PRISMA & GRAPHQL tutorial, that would be awesome)
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.
🌻
love
i can hear a mzansi accent...?....?....? ❤❤
Fo sho 🤙🏼