What I liked of your video is that you have followed proper folder structure with good coding principles. I liked this. Very few of the youtubers follow this in their videos! Along with teaching postgres and node, you are also taching use good ways of coding. Thanks a lot!!!
First week of my DB course in CS and this is exactly what I needed to understand how to connect postgreSQL and my express server. Thank you for a great video!
Hi for someone that has not done backend javascript stuff before this was an awesome introduction, picked it up after watching your video thank you so much brilliant delivery all through
Thanks for making this! It helped me not just DO the thing, but also understand the pieces and how they're supposed to go. Time to get back to my site :)
I come from the world of MongoDB / Mongoose, and now I think I need to learn PostgreSQL and Prisma usage, so I started looking for a PostgreSQL course. To be honest, you are amazing! Really amazing content, thank you so much. I can honestly say that I learned CRUD PostgreSQL in just 1 hour. Of course, there are more details, but you taught me fundamental PostgreSQL in 1 hour, and I'm writing this at the 30-minute mark of the video! Keep doing what you're doing, my friend. You get straight to the point concisely and clearly, which is great. You have a bit of a mid-level explanation style, but I am impressed.
Just wanted to say thank you. I followed along through the entire thing and did it all in ES6. Worked my way through some of the errors because of that but learned SO much. This was phenomenal. Thank you again!
Thank you so much for such a wonderful tutorial. I was searching for detailed tutorial from last 2 -3 days and finally I found it. Amazing stuff. Thanks a lot!!!
Great tutorial man, thanks for your time/effort. 10/10! @ 47:00 or so, adding an ELSE helped me get beyond that error. I also added to the ELSE to the update and delete code blocks.
Thank you for sharing your knowledge! This is great help for some of us to have persons like you who master their science and most important, you can pass it down to others Thanks a lot
This was a really informative video, easy to follow, I bumped into some errors that it got easily fixed with just restarting the server, now I understand why you have to create errorHandlers and all that stuff so everything works the way it's supposed to without anything crashing🤓☝
Awesome tutorial. Thank you very much. Very simple structure and easy to follow. It would be nice if you elaborated more on what Pool did, but I found this out in the documents myself.
Add an "ELSE" to the "IF" statements in the delete and update student controllers. that way the header only updates when needed based on the outcome of the initial IF statement. (in a real server crashing the server like that wont allow you the ability to reset it every single time someone queries it.)
Thanks for this amazing video. How do you handle the errors thrown in the controller functions ? For example, how does front end know the exact type of error so that it gives an appropriate error message?
Thank you very much, this helped me a lot. I'm new to node. But regarding postgres you should always use 'text' instead of 'varchar' and 'identity' instead of 'serial'. See postgres wiki, search for: don't do this
Thanks for this wonderful video. Can you please guide me to the right path to become a backend web developer? What are the most needed/trendy languages, tools or frameworks to start with? Any tips and advises are highly appreciated. Thanks in advance.
Thank you for this great tutorial. It was really helpfull. How should the Insert look like, if we want to instert multiple students in the same request (or how to insert json array into postgres)?
Amazing tutorial! Just what I was needing. I have a question: instead of checking if email already exists, couldn't we add the UNIQUE constraint to the email column when creating the students table?
Best tutorial on the topic... and like most folks, I probably watched too many to count! Well done @AustinBeaufort ! In your 'removeStudent' function, I notice the delete query is outside of a conditional statement and looks as though it will execute regardless of the noStudentFound value. Is that correct or should the delete query be inside an }else{ section?
Hi Austin, Your tutorial is wonderful. It is really easy to understand. Do you have the deployment process in a Server different to Heroku and Azure? Thanks a lot.
Thanks for your time, everything works fine for me. How do you update multiple fields at once? When I tried to edit 2 fields, other fields got saved with a null value.
Hey it’s been a while since I’ve done this tutorial, I’m not sure to be honest, but I’m glad you enjoyed the video! I’d recommend maybe asking stackoverflow or ChatGPT
Thanks for the tutorial. I have 2 questions. 1. You will notice that even though it says students alreay exists, it still adds the student in the database. Thats why you had 2 Joes. How do I stop this? 2. The ID is remembering to go up, but not from what is the last ID number, is there a way to do that or do i have to remove the SERIAL ID? Appreciate it. :)
Best back end thumbnail in the history of TH-cam.
Congratulations, after 2 years this tutorial is still one of the best!
Thank you! 🎉
This is a brilliant tutorial.
Had me up and running in minutes. Would love to see a much larger project with auth and all.
Thanks, will have more tutorials coming out in the future!
What I liked of your video is that you have followed proper folder structure with good coding principles. I liked this. Very few of the youtubers follow this in their videos!
Along with teaching postgres and node, you are also taching use good ways of coding.
Thanks a lot!!!
First week of my DB course in CS and this is exactly what I needed to understand how to connect postgreSQL and my express server. Thank you for a great video!
I'm not even halfway into this video and my guy has already explained this waaaayy better than any other tutorials I've seen.
Hi for someone that has not done backend javascript stuff before this was an awesome introduction, picked it up after watching your video thank you so much brilliant delivery all through
Thanks for making this! It helped me not just DO the thing, but also understand the pieces and how they're supposed to go.
Time to get back to my site :)
I come from the world of MongoDB / Mongoose, and now I think I need to learn PostgreSQL and Prisma usage, so I started looking for a PostgreSQL course. To be honest, you are amazing! Really amazing content, thank you so much. I can honestly say that I learned CRUD PostgreSQL in just 1 hour. Of course, there are more details, but you taught me fundamental PostgreSQL in 1 hour, and I'm writing this at the 30-minute mark of the video! Keep doing what you're doing, my friend. You get straight to the point concisely and clearly, which is great. You have a bit of a mid-level explanation style, but I am impressed.
Just wanted to say thank you. I followed along through the entire thing and did it all in ES6. Worked my way through some of the errors because of that but learned SO much. This was phenomenal. Thank you again!
Hey, you are welcome, glad you found it helpful!
Hands down the best tutorial I’ve seen on these topics. The explanations and pace of the video were perfect for me.
dude i'm rehashing my knowledge on psql and express, this video helped out perfectly. front to back thank you , excellent tutorial.
Also, tremendous explanation of combining these frameworks and such. Really good tempo, clear pronunciation, nice flow between concepts. Thanks!
one of the best videos for beginners to get started.
Looking for more videos like this ........
Thank you for taking your time to create this cool tutorial for us. Much appreciated.
This is one of the best tutorials I've ever taken...very well done!
One of the best tutorials I’ve ever seen in my life. Amazing work bro, thank you.
Phenomenal Tutorial, precisely what I was looking for!! Going to re-watch it entirely again and work through it! Brilliant!!
Thank you so much for such a wonderful tutorial. I was searching for detailed tutorial from last 2 -3 days and finally I found it. Amazing stuff. Thanks a lot!!!
Great tutorial man, thanks for your time/effort. 10/10!
@ 47:00 or so, adding an ELSE helped me get beyond that error. I also added to the ELSE to the update and delete code blocks.
Best video on the topic NodeJS and postgreSQL.
Thankyou so much! For this kong i used to do it with ORM and now I have task to do this without ORM and you just made my day sir
Thank you. This tutorial wiped all my confusions. It worked for my project.
You're welcome, glad it helped!
Damn, got to be one of the best Tutorial on that topic on youtube, clearly understood what you wanted to explain! Brilliant !
Thank you for sharing your knowledge!
This is great help for some of us to have persons like you who master their science and most important, you can pass it down to others
Thanks a lot
Awesome, clean, concise, valuable and knowledge packed❤❤
Thank you
This was a really informative video, easy to follow, I bumped into some errors that it got easily fixed with just restarting the server, now I understand why you have to create errorHandlers and all that stuff so everything works the way it's supposed to without anything crashing🤓☝
TERIMA KASIH PAK. PENJELASANNYA MUDAH DIPAHAMI
Great explanation !! Very detailed.
When I grow up I want to be like you. Thanks
amazing explanation. The pacing of this video is incredible holy shit. Absolutely at the right pace. Thanks a lot bro!
also great thumbnail😂
Your way of teaching is just Amazing!!!! Learnt alot in 1 hour. I wish to learn more from you :)
Thanks! New videos coming out soon!
Awesome tutorial. Thank you very much. Very simple structure and easy to follow. It would be nice if you elaborated more on what Pool did, but I found this out in the documents myself.
Thanks man, really well explained, no bloat just info, amazing
This video saved me so much time. It got me up and running so quickly. Thank you for this!
best tut i saw on this topic, everything is very well maintained and scructured
🙌
Add an "ELSE" to the "IF" statements in the delete and update student controllers. that way the header only updates when needed based on the outcome of the initial IF statement. (in a real server crashing the server like that wont allow you the ability to reset it every single time someone queries it.)
With enough of these comments this code could actually go to production
An amazing tutorial.
Great work!
Do make another video to build connection between different tables with postgreSQL
Thank you! This tutorial really helped me to do my test job ;)
This video is beyond expectations🔥
Awesome tutorial, super simple yet very thorough. Thanks dude.
That's brilliant. I really like how you structure your project!
I reply as Mr. Mahmoud Tokura,, greate Tutorial, excellente Sir.🤝
You explained every small thing.... excellent tutorial🔥🔥
Thank you!
Thank you so much. Very clear and easy to follow, Great tutorial!
I found this video very helpful and was able to follow smoothly.
Thank you very much! This was exactly what I needed
Very clean and clear explanation. I loved your video. Thank you.
🙌
Thanks for this amazing video. How do you handle the errors thrown in the controller functions ? For example, how does front end know the exact type of error so that it gives an appropriate error message?
Thank you very much, this helped me a lot. I'm new to node. But regarding postgres you should always use 'text' instead of 'varchar' and 'identity' instead of 'serial'. See postgres wiki, search for: don't do this
I’ve never spoken to 30 crows at once before, I wouldn’t even know which one to address first,
But glad you liked the video 🙏
@@AustinBeaufort 😅
Followed you through the video.
Built the RESTful apis along the way.
Thanks a lot for this. Shared!
🙏🙌
So easy to follow and so helpful
Thanks for this wonderful video.
Can you please guide me to the right path to become a backend web developer? What are the most needed/trendy languages, tools or frameworks to start with? Any tips and advises are highly appreciated. Thanks in advance.
Great folder structure
thak you, it awesome, could you plz, tell me what your theme you are using?!
You're welcome. I believe the theme is either "carbon owl" or "atom one dark" with "Fira Code" as the font and ligatures enabled
Very helpful Brother 👍😃
Thank you for this great tutorial. It was really helpfull.
How should the Insert look like, if we want to instert multiple students in the same request (or how to insert json array into postgres)?
You're welcome, glad you found it helpful!
Hello, to insert multiple students, just separate the data with a comma
good tutorial!
but i think student Joe created again because there is no throw or return exception after checking if email already exist
Best video.... Thank you sir🎉
Thanks bro ,very nice explicitly
Amazing tutorial! Just what I was needing.
I have a question: instead of checking if email already exists, couldn't we add the UNIQUE constraint to the email column when creating the students table?
Last video on yt on the topic Rest Api with NodeJS (JavaScript), Express, and PostgreSQL ,Found Very Helpful !
Beautiful. I would buy the Udemy course where you go deeper on this :)
I followed through and its Great!
Thank you!
really helpful! thank you so much for making this video :D
Best tutorial on the topic... and like most folks, I probably watched too many to count!
Well done @AustinBeaufort !
In your 'removeStudent' function, I notice the delete query is outside of a conditional statement and looks as though it will execute regardless of the noStudentFound value. Is that correct or should the delete query be inside an }else{ section?
Is there any source codes of project to download?
Great tutorial, so easy for me to study!
Thanks for helping man. It really was great!
Hi Austin,
Your tutorial is wonderful. It is really easy to understand.
Do you have the deployment process in a Server different to Heroku and Azure?
Thanks a lot.
ty for this vid !!!
Fabulous
Thanks for your time, everything works fine for me. How do you update multiple fields at once? When I tried to edit 2 fields, other fields got saved with a null value.
Hey it’s been a while since I’ve done this tutorial, I’m not sure to be honest, but I’m glad you enjoyed the video!
I’d recommend maybe asking stackoverflow or ChatGPT
Really helpful ❤❤
super tutorial for postgre!!
Thanks for the tutorial.
I have 2 questions.
1. You will notice that even though it says students alreay exists, it still adds the student in the database. Thats why you had 2 Joes. How do I stop this?
2. The ID is remembering to go up, but not from what is the last ID number, is there a way to do that or do i have to remove the SERIAL ID?
Appreciate it. :)
for your first question just add a return before rest.send()
Great video man! Thanks!!
Hey! I really like your vscode theme. May I ask what is it that you use?
I unfortunately don’t remember what this theme was 😅.
Fira is the font I believe.
this tutorial is very helpful thank you so much, bro.
Glad it helped!
Simple and Simple
Thank you So Much ! Awesome tutorial
Great video, very cool.
Very helpful - thank you! 🙏
great video.thanks
Awesome tutorial!!
Awesome tutorial , thanks a lot.
@wise guy i believe good 3 months
Thank u so much for this grate tutorial.
You're welcome, glad you found it helpful!
Thanks buddy , its is a good tutorial .thanks
You're welcome! Glad it was helpful for you!
great video
Best tutorial
under rated!!
Thanks for the amazing Tutorial ! How to proceed if i want to use MVC pattern ?
Most Vociferous Caribou (MVC) ? I mean if you want to try and tame Caribou that’s up to you bro 😂
@@AustinBeaufort That is not the right answer 😅
Awesome tutorial thank a lot
Great tutorial thanks
Thank you so much this video is awesome. help me a lot. thanks again
Can you mention the VS code theme that you have used? I liked it very much.
To be honest i don’t remember the theme 🤔.
For font I used Fira Code font.
I turned on ligatures to achieve the connected => arrows.
Great tutorial♥️
very good
thanks
This is a brilliant Tut! Thanks
omg, THANK YOU SIR🙏🙏🙏