PIP Install Psycopg2 - Python Connect to Postgresql - Postgresql Python - Don't Miss the Description

🔖👇 Book a FREE 15-Min Doubt Clearance Session on Zoom with Me.

Hi Coders, welcome to Code Jana. If you have come up to the point where you need to save some data to your Python project then you might have come across several database libraries for Python, like:

1. Sqlite
2. Mysql
3. Postgresql

SQLite is for beginners & should only be used for practice. But if you want to make your project live, then Mysql & Postgresql should be your choices.
Among them, it's completely upto you, to go either with Mysql or Postgresql.

I've created a flask application & I had gone with Postgresql. So in this video, I am going to take you step by step on how to pip install Psycopg2 (which install postgres adapter for Python) and then, we'll take a look at how to connect to Postgresql.

I'll also show you how to download PGAdmin4 (current version), & visually look at the database tables & queries as you work with it. So... let's have some fun.

But if you truly want to scale your skills to the next level & become a master in Python programming then, these books will help you do just that.

🧑‍💻 Gadgets that a Programmer Absolutely Needs 👇:

Also, if you have gained something valuable from this video then please like, share & subscribe to Code Jana.
Thanks for Watching. 😎

Resources:

[CodeJana]

🔖👇 Book a FREE 15-Min Doubt Clearance Session on Zoom with Me.

[abdulahadrauf]

i know how to write the codes, but dont know how to pronounce the psy co pg 2

[marksog]

I am having problems installing Postgres module for python. I have used "pip install psycopg2" and pip install psycopg2-binary. Yet I have this error among many (ERROR: No matching distribution found for psycopg2). how can I go around this. or get it working fine.

[kyc]

i've already installed psycopg2 but when i execute the script this error comes out:
psycopg2.OperationalError. i don't know what it is