Connect to PostgreSQL from Python (Using SQL in Python) | Python to PostgreSQL
Вставка
- Опубліковано 14 лип 2024
- Connect to PostgreSQL from Python (Using SQL in Python) | Python to PostgreSQL
In this video, we shall understand how to connect to PostgreSQL Database from Python. We shall write a python program which will use the Psycopg2 module to connect to the PostgreSQL database and then perform some database or SQL transactions such as creating a table and then insert data to the table, updating a table data and delete records from the table using python code. We shall also see how to fetch table data from postgres database to python program.
At the end of the video, I will also cover how to use Context Manager to perform all of the above SQL operations. That is, we will use the WITH clause to connect to the database and also use the WITH clause to open the cursor. I will also mention what are the advantages of using WITH clause and why it is recommended to always use context manager or WITH clause when working with database in python.
Download the Python script used in this video from my blog. Link below:
techtfq.com/video/connect-to-...
Timeline:
00:00 Intro
00:42 Prerequisites for connecting to PostgreSQL from Python
02:18 Connecting to PostgreSQL from Python
05:33 Opening a cursor to perform database operations
07:52 CREATE Table in PostgreSQL database from Python program
10:37 INSERT single record to a table in PostgreSQL from Python program
12:23 INSERT multiple records to PostgreSQL table from Python program
14:30 FETCH data from PostgreSQL Table and display in Python program
17:23 UPDATE Table data in PostgreSQL database from Python program
18:50 DELETE Table record in PostgreSQL database from Python program
20:14 Using Context Manager to connect to PostgreSQL database from Python
We shall be using psycopg2 module to connect to PostgreSQL database from python, which is considered to be one of the best libraries to connect to postgres from python.
We shall start the video by covering the couple of pre-requisites which is to first install the psycopg2 module and then finding the credentials or information required to connect to the postgres database.
After this we shall write the python program which will initially connect to the PostgreSQL database and then open a cursor which will be then used to perform the database operations like CREATE TABLE, INSERT INTO Table, UPDATE Table data, DELETE table record and also how to fetch or retrieve table records or table data from the database to Python program.
Finally, we shall end the video by talking about context manager way of connecting to the database and also how to use context manager to open a cursor. Using context manager is simply using the WITH clause while connecting to the database and then also using the WITH clause while opening the cursor.
I will also mention the advantages of using a context manager over the traditional method or connecting to data and opening the cursor. And also mention why is it recommended to always use context manager when connecting to database in python.
Hopefully this video helped and gave you some useful information of using SQL within python program. If you liked it then please make sure to like the video and also subscribe to the channel.
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
• SQL Tutorial - Basic c...
✅ SQL Tutorial - Intermediate concepts:
• SQL Tutorial - Interme...
✅ SQL Tutorial - Advance concepts:
• SQL Tutorial - Advance...
✅ Practice Solving Basic SQL Queries:
• Practice Solving BASIC...
✅ Practice Solving Intermediate SQL Queries:
• Practice Solving INTER...
✅ Practice Solving Complex SQL Queries:
• Practice Solving COMPL...
✅ Data Analytics Career guidance:
• Data Analytics career ...
✅ SQL Course, SQL Training Platform Recommendations:
• SQL Course / Training
✅ Python Tutorial:
• Python Tutorial
✅ Git and GitHub Tutorial:
• Git and GitHub
✅ Data Analytics Projects:
• Data Analytics Projects
THANK YOU,
Thoufiq
As a old woman learning to upgrade, I found your videos handy and very clear to catch up.I am one of your subscriber.I watched your SQL contents and simply loved it. So are your python concepts. Thank you for all your hardwork and is not easy to deliver.God bless and keep teaching people like me and others🙏
Hi Girija,
This is such a beautiful feedback… I cannot express my happiness hearing that my videos have helped you ..
Each video takes a lot of effort to make and it’s all worth it when I get to hear such beautiful words from you guys..
I am so great full that you took your time to leave me this feedback..
THANK YOU 🙏🏼
And I wish you all the best in your learning journey 🙂
installed paycopg2 for python pycharm and imported to the project.But the functions like curson() execute() are not autopopulated when I calling with the connection object
This is really great stuff!
I'm a math, ml, guy and I feel like I'm learning great python techniques here
THANK YOU
Morgan
Such a comprehensive and quick tutorial to get the basics! I recommend this tutorial after watching neural nine crash course for python and postgres. This really gives you more efficient and clean solutions for writting code.
Instantly subscribed!
You mentioned all the details like preventing sql injection, using the 'with' clause, and so on (unlike other youtube tutors who just skip these ), so it's really helpful and you're a fantastic teacher! 💯
This video is pure gold!!! Thank you for doing such a great job on this.
This video was quite helpful. Saved me a lot of time and very comprehensive too. Thank you🙏
Very quick, clear and easy to catch. Thanks:)
Dude. Love this video. demystifying postgres with python. Great work!!! this video goes in the vault. Thank you.
Very clear and instructions where easy to follow! Thanks for this video.
You taught this fantastically! With your teaching I am able to immediately go away and use this knowledge on my own project - it's rare that anyone teaches me something that can enable me to do this with such ease. Look forward to watching more of your videos!
Thank you . Glad it helped
Very Nicely explained...Clarity was maintained from the beginning till the end of the video. Thank you so much!
Thank you Dimple :)
This a fantastic video....Pure gold!
Excellent !!!
Thank you
Morgan
Thx for the video, very useful and easy to understand! great job!
woooo man THANK YOU SO MUCH you helped me a lot bro, you literally made this so easy to understand and spot on
I just started learning python and my manager is like I need results , you made my life easy by posting this video !!!!
🙏🙏🙏
You saved me today. Thanks, awesome video. Can you do more videos like this one, please? I love your method of teaching you are a natural teacher. Thank you! Absolutely a fantastic video!!!!!
Thank you so much Santos and sure will do
Gran video, acarreando el proyecto. Un grande Thoufiq
Great video, well explained, organized and efficient
short and concise. thank you!
Thank you! Absolutely a fantastic video!!!!!. I love your teaching method.
Thank you 🙏🏼
Glad this helped
Brilliant video bro…I am learning python now. Your videos are crisp and self explanatory. Subscribed❤
Thank you so much for the video, I was having problems with rollback, any single mistake that I made, I had to start all over, but your video showed me a better approach.
THanks Bro Luv From India❤️
Very nice video. Not only showing how to get things done but also details like the try block, the little scripts (to reuse code) and stuff.
Very helpful video.... Thank you so much😊😊
Very informative and very clear. Thank you for sharing your knowledge.
Your welcome Anura,
Glad this helped
Please continue making more dedicated videos in Python just like SQL.
THANKS IN ADVANCE
Great tutorial, very helpful. Thank you for posting it.
Glad this helped
The explanation is really clear! It is easy to understand what you are doing. Great job!
Super helpful thank you!
Thank you sir for everything! It's really appreciated!
Glad you like them
Very nice explanation! 👏
Excellent video.
Awesome video
just brilliant!
very useful video. Thanks a lot.
Really. You covered the basic table with DDL, DML along with try, except, format string, tuple very understandable way. I heard using of iterators instead of for loop.
Great stuff, Thank You.
Really helpful 👌🏻 Keep up the good work🙌🏻👍🏻
Thank you hero ❤️🙏🏼
This was very helpful man, thanks a lot.
Very informative! Thanks!
Glad you liked it
Thank you for this great video
Thank you so much, really it’s very helpful to me to understand how it’s working together . Thanks a lot.😊😊
Thank you so much for your efforts!!!
you are my life saver...
Attracted to subscribe,Thank you
very help video for me as I am new to python programming
great video! thanks a lot
buenísimo loko
Awesome..
I have been watching your tutorials and really awesome.. Thank you for your time and effort..
Wow,just one watch i could grasp most of the content.Havent felt boring at any point of time.great job!
Glad you liked it Sampath
this video was really helpful, thank you
Thx for the video, very useful and easy to understand! great job!😀😀😀😀😀😀😀😀SUPER VIDEO
Glad you liked it!!
Great tutorial bro
Superb.. You have an amazing explaining skills👍👍👍
Thank you ❤️
on first blush this seems quite good :) subscribed.
Thank you!
thank you for useful content
Superb
Thanks Bro!
love this one!
Thoufiq, it is a very clear, easy and helpful tutorial, you covered a lot. Thank you.
Welcome:)
very clear. thanks a lot.
You are welcome Akash!
Great job Mr. Thoufiq.
Thank you Hafed 🙏🏼
suggestion : make a video explaining what goes into a config file and where to find all that information. I have trouble understanding how to switch from database administration to the rest of my code. thanks, great video !!!
Thanks for the video TFQ..I want more python tutorial and sql as well
Noted bro , I’ll get to python soon
top one
Bro thank you a lot for the info . I love your method simple and easy.
Keep the good work pls you a live saver. In programing I mean hh
Great tutorial..👏👏
Thank you Anil 🙏🏼
Super
Great sir
Thank you ☺️
thank you
clear one
Thank you :)
Thank you Thoufiq
Your welcome 🙏🏼
tysm!
This was 22 minutes and 57 seconds of pure AWESOME! Thank you so much! Python & PostgreSQL 101.
Super explanation really helpful… please cover ‘csv’ module in python
Thank you so much 🙏🏼
Really glad you found this helpful 🙂
Sure will consider your feedback to make a video on csv module..
Thank you sir
Welcome
111,000th Subscriber
very good video. You could have also covered how to use config file for database connection parameters
You did great job and explained in simple steps.can you please prepare a video on exporting CSV from postgreySQL to python in pipeline?
thank you Naik and sure will consider it for the future
Thx buddy
Glad you liked it
thanks
Excellent video!!! One thing to clarify, what’s the difference between connecting this through SQLAlchemy with psycopg2 driver and connecting via psycopg2 driver straight away.
This is amazing stuff. Thank you, brother. I am trying to send the outputs I got in python to the database. Like I am reading valves from my plc using the OPC UA server via python. Now I want to send those values to my PostgreSQL database. Any help would be appreciated. Thank you very much again.
Excellent Python Tutorials keep it up!!! @techTFQ
Thank you so much. Your video was really helpful. Do you have similar videos on pandas data frame using PostgreSQL? Thanks again.
es lindo
Great video. How does one go about creating, storing, and using the config file?
As a token of gratitude, I can buy your Udemy course or give a 5satr rating... God bless you. Create a video on polar with postgres
Thank you very much, can you please show as how to connect our model machine learning application to python?
Your welcome 🙏🏼
I am planning to make videos on machine learning using python in the near future so hopefully I will cover this at that point in time..
Thank you for the suggestion, will definitely consider this 🙂
@@techTFQ thank you for responding please for especially deep learning.. good luck
Your welcome 🙏🏼
Sure focusing on data science concepts for the next few months and then will move on to machine learning and then deep learning..
Thanks again for the suggestion and the support. Truly appreciate it ☺️
please create a video how to import data from CSV or excel file (of MB or GB data size) in tables automatically using python.
This is awesome, But can we print the column names also in the Console/Output? Your code is just displaying the data.
@techTFQ Thanks for the video.
Please provide the updated link for the script.
given that the context manager does not close the connection, is there any advantage of putting the connection under a contex manager?
Question. When creating the table, for the PRIMARY KEY which is id. Can you use SERIAL instead of INT? Asking since
SERIAL will automatically address this as the PRIMARY KEY and the id will always be unique? I am assuming since the id will not have duplicates.
Yea you can use SERIAL as the data type for the primary key ID column..
I just used INT for this particular example
Hello, can you please explain how to fetch million rows from postgresql with backend API and pass to frontend framework. Thanks in advance
How would we insert a dataframe into a pg database?
Could you please also explain how to call postgresql file from python? instead of just executing DDL or DML statement directly