Using Postgres Cloud Database With Tkinter - Python Tkinter GUI Tutorial 187

preview_player
Показать описание
In this video I'll show you how to use the Postgres database in the cloud with your Tkinter app!

Connect your tkinter app to a postgres database in the cloud! We'll use heroku to host our postgresql database and connect to it from our Tkinter app.

#tkinter #codemy #JohnElder

0:00​​ - Introduction
2:53 - Download and Install Heroku CLI
3:24 - Create and Start Virtual Environment
4:00 - Pip Install psycopg2
4:38 - Connect To Heroku In Terminal
5:38 - Create Heroku App In Terminal
6:03 - Create Postgres Heroku Addon
6:42 - Configure and Connect To PostGres Database
7:43 - Get Postgres Credentials From Heroku
9:37 - Create Postgres Cursor
10:26 - Create Postgres Table
12:25 - Submit Data To Postgres Table
14:44 - Query Postgres Database
15:25 - Output Query To Screen
16:50 - Test It Out!
18:02 - Clear Entry Boxes On Submit
18:55 - Conclusion
Рекомендации по теме
Комментарии
Автор

▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My YouTube Channel:
▶️ See More At: ✅ Join My Facebook Group:
▶️ Get The Code

Codemycom
Автор

Amazing content! Really Helpful, thank you, man!
One quick question: what could be the solution if we still want to create a local DB for a single user application but at the same tame create like a backup online when updated or when an online connection is available?

bladimirmarmolejo
Автор

John, thanks so much for the awesome simple tips video on connecting to a remote Postgres db. This was exactly what I was looking for. I guess sqlite3 is very similar. Love the TKinter videos. Thanks again !

scott
Автор

Can you make an .exe of this and when given to end users will it still connect to the cloud DB?

AmanVerma-qjrt
Автор

i feared about cloud, u make it simple. awesome.

pc-knkt
Автор

please do a video for how save/update/delete records on network system (server base)
i don't know how should i ask that (I mean... i want to save records on another computer...like network connection)

nihalthannegedarapremaratn
Автор

Don't forget to make django table pagination with Ajax

webseries
Автор

I've been trying to import the psycopg2 library to my GUI, but it keeps giving me " ModuleNotFoundError: No module named 'psycopg2'
" error. I've looked at many solutions, asked my friend and so on, still stucked. Please help!!!

UtarkOyun
Автор

Hell sir, I have 1 question
how to integrate email system like outlook with Django application. The application should able to send email and receive email. Any email sent via Django app appears in outlook and vice versa.

shubhamarya
Автор

Waah kya seen he.good job thanks for spreading free education.vey less people understand that education is not a business.

bhoomikashakya
Автор

Can we build our own postgres server without using the server from amazon aws?

robodev
Автор

Hey man, Love the channel, can you please do a series on pygaze? I like the way you break stuff down and can't find a lot of resources for it.

canyousee
Автор

Hey John! is there any way to change the color of the UI ( the bar that has the minimise button) in tkinter ?

armedjaquar
Автор

Great video! Gives me an idea for Hadoop and Spark, thanks for sharing.

rodolfoblasser
Автор

Thanks John I'm gonna use this to my Final year project.
Thanks man 😍

nabeelshoukat
Автор

Things are going real now hhhh thanks John for the video

labialkosta
Автор

after this we may hope to get firebase

tuhinbhowmick