How to Connect Node js to PostgreSQL Database and Fetch data
HTML-код
- Опубликовано: 14 окт 2024
- This video explains how to connect Node.js to PostgreSQL database and fetch data step by step
Node.js Tutorials Steps - www.kindsonthe...
Node.js Tutorial Videos - bit.ly/2Qmyp0o
How to Connect Node.js to MySQL here - • How to Connect Node js...
My websites
www.kindsontheg...
www.munonye.com
www.datarmatics...
Learn Programming by joining International Computer Programmers here:
👉 / 1447709731988533
Feel free to connect with me
❤️ Facebook: / kindsonm
❤️ Instagram: / kindsonthegius
❤️ LinkedIn: / kindson
❤️ Twitter: / kindsonm
Your support can help me improve my content:
✅ Buy me a coffee: www.buymeacoff...
✅ Support me on Patreon: / kindsonthegenius
Simple and quick without unnecessary talking. Thank you, love it :)
You're welcome! 😊😊
This just saved me a whole load of time and stress, thanks for the great little tutorial!
Simple & quick. Thanks 🎉
You're welcome!
Thank you. Appreciate how well you were able to explain this so simply.
You are most welcome 😊
Thank you very much, I was looking for this information for almost a day
You are welcome!
Man, I Like your videos, appreciate your work.
Glad to hear it😊
Thank you. I love you go straight to the point, really great tutorial.
Many thanks 😊
Thanks for the concise and relevant explanation 🙏
Many thanks!
Perfect man, Thank you.
😊
Thank you, looked on some other they overcomplicated stuff. This is right to the point. !
Thank you, great video 🙏
You are most welcome 😊
This was a great video. Thank you!
Glad it was helpful!
bad boy, you just got a subscriber
great tutorial thank you soo much! very much appreciated.
Thank you so much! Huge help.
awesome video it worked, could i have the link of the video where you show how to remove and add data in database?
Yes, sure ruclips.net/video/HO5iiDaZO2E/видео.html
@@KindsonTheTechPro thanks
Thank you Kindson!
Great tutorial, thanks man! Straight to the point!
Using your example, how would you save the res.rows to a variable that is accessible through an export?
Hi Josh, did you ever figure this out? Im a student working on a full stack project and had this exact same question.
@@duckblast unfortunately not. I was doing it to check on alternative solutions. I never got a response on this comment
@@duckblast not sure this is still useful but, Ideally, you should export an async function that runs this query and returns the rows.
The returned rows are an array of row objects, you should make an async function which returns this array and then you can use parsing to separate and use the rows accordingly
What to do if I have installed postgres on azure vm and I want to connect from nodejs?
Hello, do you have a playist for this? Thank you
How do I specify the.env in the environment variable for GitHub actions for the postgreSQL db instance on AWS!
hello sir, I have an error said that client.connect is not function i tried to fix it but then i have another error says that "Cannot read properties of undefined (reading 'query')" I couldnt found any solution
Did you connect to a table you created on your local machine or is that a remote mock table that postgres has on their website?
I connected to a table I created on my local machine. But the same applies to remote db as well. Why do you ask?
@@KindsonTheTechPro Because I tried what you did and get "relation "users" does not exist"
thank you so much!
I want my data(audio, video,text formats) from Postgres DB to save on google drive, how can I do it? any reference you can give, will be very helpful
Hi sir can you explain how to compare Excel data and database data whether both have same records or not using pg database
thank you.
You're welcome 😄
really great !
Many thanks!
Well done. Thank you!
Perfect. Thanks sir...
for those confused why the code wont end its "client.end();"
Thanks buddy 😊
When installing pg I get "6 high severity vulnerabilities" while "npm audit fix --force" command wont work.
Absolute legend, thank you for this video. Subscribed :)
Thanks for the sub!😊
instead of showing the results in console can please tell how to display in browser?
Yes...but that is a different topic as you need an UI engine (Angular, React, Thymeleaf)...You can check through this playlist ruclips.net/video/FzNqL3dxEwc/видео.html
Thank you
Welcome!
Hi, will this work for React too? If not, can you please make a video for connecting React to Postgresql pleasee
How can I call/execute pgpsql script file (*sql) in node js?
holy shit, you just made my auth error disappear. Thank you!
For once, the software is actually really useful
Hi Sir I am getting issue for the host in connecting to postgres
What is the error message?
client.end() is the right way to end connection
Agreed 😊
Alright your method is so much easier but what about who use "sequelize" what's the difference
My results is undefined what did I do???
How Do I use that data within a search bar ?
What do you mean 'within a search bar'?
Error: The server does not support SSL connections. i keep getting this error
Man I get the ECONNRESET error, I don't know how to fix it
think you think you think you
moving from sqlserver/mysql to postgresql I think postgresql is complicated for no reason
okay so it's easy to console.log the data. So far i've not found a way to output the data to a variable.
The returned rows are an array of row objects, you should make an async function which returns this array and then you can use parsing to separate and use the rows accordingly
I fucking love you
man you really have to work on your typing skills rather than coding! :/
I guess they are all the same 😊
Feedback noted though. Thanks.
広めてください」、
Hi Looking for the help: Error: Not run migration 1686731015110_table-comment is preceding already run migration 1685564807291_table-comments
Great Job! Thank you
Glad it was helpful!
Thank you
I am getting Error: Connection terminated everytime.
thank you