Deno & PostgreSQL (Crash Course Part 2)

We will add a PostgreSQL database to the REST API that we created in the Deno crash course. We will also implement Denon

Code:

Original Crash Course:

💖 Become a Patron: Show support & get perks!

Website & Udemy Course Links:

Follow Traversy Media:

[vortex]

Upvoted without watching because I already know its awesome

[omerfkgoze]

i made a great start to web dev, thanks to all your YouTube and Udemy tutorial videos and of course you. it's so fun to write code with you every day. i found the job i love. and it's great pleasure to writing code together with someone great :) greetings from Germany

[ThiagoVieira]

Me, just yesterday: "Phew! This Deno Crash Course was nice. Time to focus in some C#"

Brad Traversy, just now:

[backendfyi]

Thank you for time. Thank you for all the tutorials. You’re an amazing person. Thank you and God Bless you for your efforts.

[ahmad-murery]

I'm sure if one can set a like for each good part in the video then you'll end up with a "likes overflow" error message.

With Brad you can learn more than just how to code, in general you'll learn how to organize your thoughts, how to explain things and most importantly how to keep yourself motivated
.

Thanks Brad for every second you spent making everyone happy.

[kov]

Thanks for another great video. I've used this to also play around with docker-compose a bit to set up postgres in a container. Great additional exercise. I'm looking forward to the next part in this series!

[UpTballA]

@Traversy Media
Brad thank you so much for taking the time to update your Node Masterclass and css courses on udemy. Your the best

[vikasni]

Legend is back again...Brad ur the Most loved person on the earth when it comes to programming YouTuber 😍😍

[blinkkeebs]

You and Ben Awad are the best youtuber tutors that I’ve seen! 😻

[AlbertsJohann]

You truly are a legend, Brad! Thank you so much for providing quality content like this. I always do my part by supporting you on Udemy, and will continue to do so.

[carloseugeniotorres]

Nice course!
Just as an improvement. On the updateProduct method, it's good to add this to avoid updating the fields with null value if you don't pass them in the request body:

const newData: Product = body.value // the new data coming from the request body
const product: Product = response.body.data // comes from the getProduct response we did above
product.name = newData.name ? newData.name : product.name
product.description = newData.description ? newData.description : product.description
product.price = newData.price ? newData.price : product.price

Thanks.

[koodauskanava]

map method with push can't be right @24:00 mark. Just use return and assign result to a new variable. Use literals like [] and {} and not new Array or new Object.

[Bingbongbing]

Just finished the Crash Course yesterday, thanks Brad!

[Italya]

Many thanks Brad! Looking for the DERN crach course!

[mathemagicalmonk]

A web-scraper in deno would be useful in showing-off deno

[neerajveeranki]

Very good video and explanation is as clear as it gets.

[SunnyVakil]

Hi Brad, I love to watch your videos to learn new things. You have almost every crash course what I’m using in Front End Development. You have syntactically sugar in your voice. I would like to suggest you that, Can you make one udemy course on JavaScript Algorithm and data structure that covering all aspects. It would be helpful for your students to get more grip on Javascript. Thank you :) for being a great mentor 👍🏻

[mohammadshweiki]

Should we expect “Deno front to Back” course? I hope we should “fingers crossed”

[davidsaracini]

Nice video. Here are some comments. Why are you checking for the existence of the product? Is there no "rowCount" value that is returned when updating or deleting? If rowCount = 0, then return 404. There should be no need for 2 calls to the database. Also, you really should be returning the id to the client when inserting a record. That should be easily done by using the syntax "INSERT INTO <table_name> (cols...) VALUES (values...) RETURNING id" I'm not sure that deno-postgres supports that but it seems to be based on node-postgres and it does.

[champorado]

I hope you do an updated tutorial using the fresh framework of deno. thank you and more power to your channel.