How to Connect to a Postgres Database in Python

Having trouble building your Python app? I can help:

Connect to a Postgres database and execute statements against the database in Python.

💻 Code written in video

[SIBUK]

OMG this is amazing!! I had no idea this was possible!! I have been given a horrific task of migrating a massive database with over 100 tables, many of which have over 100 columns, over to a new database after they re-wrote the app as a web app and the new database schema is completely different in every way. I have been wondering how the hell I would ever accomplish it in SQL but this could be my saviour!!

[Fumster]

Thank you! I don't know anything about SQL and Python, because of this video I can manipulate my database by Python!

[emj-music]

Straight to the point and concise, great tutorial. Thanks.

[xilllllix]

perfect for a newbie like me! straight to the point with no fluff...

[anibalgomezpr]

Excellent tutorial video. I''m .63 years old, and trying to learn python with postgresql.

[JanitteD]

Спасибо, даже учитывая что я не знаю английский я всё понял, ты лучший!

[laithal-zoubi]

Like before done with the video.
Clear, on-point & excellent overall presentation.

[ThienNguyen-hdsu]

Very good and funny videos bring a great sense of entertainment!

[proximacentauri]

So what if, hypothetically, you had no idea what those first 4 variables were and how to get them. Is there a tutorial on that?

[bulteauteo]

thanks you a lot for this great tutorial

[sourabhgupta]

I don't know what to do with 4 variables on top.

[Rave_Consolidated]

why do we have to import a library 'extras' that is within the original imported library

[dudeparak]

Hello
I have installed the psycopg2 package in my pycharm and functions like cursor(), execute() are not populated when I call with connection object.Could you please help me on this

[thenoobgamr]

What if I want a certain column from the database from multiple id's so like can you do cur.execute("SELECT * FROM feedback WHERE id = %s;", (1, )) => cur.execute("SELECT * FROM feedback WHERE id = %s;", (1, 2, 3, 4, 5, 6, 7))

[wallaceferreiradasilva]

Hi! Great video. The way you explain the concepts is awesome.

I'm trying to use psycopg2 on a Flask app, but I don't know how to handle database connections with the several routes in my application. Should I create a connection and close it for every route?

[Sam-hcel]

What if I downloaded some data to python via the API and I want to connect them to postgres to wrangle the data, how do I do that?

[reganmuthomi]

Hey man? I have been trying to achieve a connection with my heroku server but i keep getting this error : 'could not translate host name "host_name" to address: Unknown host'.
Any advice?

[hamidbakhtiari]

awesome video, I really learned a lot from this,

definitely suggested!

[AlisTDK]

excellent video my friend take your like and new subscriber

[sholuadeoluwakoredeolamide]

do i need to have postgres opened on my laptop?