Using Databases With TKinter - Python Tkinter GUI Tutorial #19

How to Use Use Databases With TKinter. In this video I'll start to show you how to use the SQLite3 database with Tkinter. Sqlite is a cool free database that comes with Python and is pretty easy to use!
In this series I'll show you how to create graphical user interfaces for Python with Tkinter.
✅ Watch The Other Videos In This Python Playlist:
bit.ly/2UFLKgj
▶️ See More At:
Codemy.com
✅ Join My Facebook Group:
bit.ly/2GFmOBz
✅ Subscribe To My KZbin Channel:
bit.ly/2IGzvOR
▶️ Learn to Code at Codemy.com
Take $22 off with coupon code: youtube

[@Codemycom]

▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My KZbin Channel: bit.ly/2UFLKgj bit.ly/2IGzvOR ▶️ See More At: ✅ Join My Facebook Group: Codemy.com bit.ly/2GFmOBz ▶️ Learn to Code at Codemy.com ✅ Buy a Codemy T-Shirt! Take $30 off with coupon code: youtube1 bit.ly/2VC9WUN

[@ninjatribble7961]

Wooo, database stuff! This is what I've been looking forward to. Makes me feel like I'm starting to build something bordering on useful.

[@Codemycom]

For sure!

[@softinfo2541]

I have been going through many videos on youtube and came across many youtubers but my search stopped because I found simply the best!!! I really appreciate and your way to teach is simply WOW. for sure I will subscribe. which is INSANELY CHEAP :)

[@Codemycom]

Thanks so much! I really appreciate your words!

[@christophechouinard7619]

4:45 this man just made me understand something so simple, but that nobody explains it this simple. Thanks man !

[@Codemycom]

Happy to hear it!

[@dragans5624]

I hope u get rich with doing things like sharing this knowledge :). Thanks for sharing

[@Codemycom]

That'd be great :-p

[@saicharanchitti66]

wow, literally this is the wonderful series of videos that i am really searching for. thank you sir you are sharing your knowledge a lot. it was really helping for my project.

[@Codemycom]

Happy to hear it!

[@anasbhih5114]

I love the way you simplify things! bless you

[@Codemycom]

Glad you like them!

[@abhishekrathore5611]

I just love the way u ask "What's going on guys?!!!"😂😂❤️ Keep up the good work

[@Codemycom]

Ha Thanks!

[@xzex2609]

your videos are one of the few bests in YT , Bro code is awsome in detailed but fast learning and you make it as easy as possible i want to knopw how your work are meant to us , i really thank you

[@Codemycom]

I appreciate it!

[@kaushallyadealwis8192]

Thank you so much John for the amazing tutorial; it was really helpful.

[@Codemycom]

Glad you liked it!

[@DownToEngineer]

Thanks John, these courses helped a great deal.

[@Codemycom]

Glad you liked them!

[@senorviglione4925]

I am a high school Spanish teacher that is learning Python. You have the best videos on KZbin and I'm addicted to this Tkinter series. I like that you periodically run the code for each project. In my experience, not a lot of coding KZbinrs implement that. Thank you for everything.

[@Codemycom]

Glad you're enjoying the videos!

[@williamkidwell1504]

This series, like most all your tuts is well explained, but I found myself dallying over it. I've got DB experience in other areas, but this didn't really sink in right away for some reason. What I found to be the problem was, the db kept getting "lost" after I closed out the browser, which you address when you speak of it getting placed in the c:/gui directory you use. But I use different notebooks in different directories under Anaconda/Jupyter, which unfortunately makes things more complex sometimes, so the data would get "lost", change around, etc., once I moved to another notebook or tutorial. FWIW, if anyone has a similar problem, I found it helpful to use os.getcwd() and os.listdir() before setting up the db, so you know where you are working and what's there; and, then, run a simplified (non-tkinter) script to setup, and finally run os.listdir() a second time to ensure the creation of the db file. Then you can just use tkinter to browse the db, make updates, etc.. This technique also lend itself to browsing the db itself with sqlite3 sans tkinter, so - when you return to work in tkinter - you can know the db better, check your work, etc... $.02 HTH... :)

[@uriyahhodge4268]

since the database connection is before mainloop() does this mean that the connection to your database is happening every iteration? or is this not a while loop type situation?

[@mmhgarcia]

Thanks so much !!! Clear & Well explained. Regards.

[@Codemycom]

You are welcome!

[@parsabahrambeik4381]

Hi, thank you very much for your video. I just followed your video to connect to the database ... but you did not continue with MySQL or SQL. This is very unfortunate

[@padhiyarkunalalk6342]

Sir you are great. #sir can you make a video on,how to store data in pandas using GUI. #only pandas and tkintrr Don't use SQL database #thank you For teaching #from india

[@sameerkhanna2051]

Thanks for this great tutorial

[@Codemycom]

Welcome!

[@luntyyy3033]

Really helpful!

[@Codemycom]

Glad it was helpful!

[@jakespeers6835]

Hey there, just came across this video in a google search and subscribed to you. I have a couple questions I'm hoping you can answer. I've just recently started learning python and have a decent grip on most of the basics. I'm currently working on a personal project and wondering if sqlite will work for this function. I've created a python program that scrapes web pages and converts the needed data to a clean json file. I'm now looking to add all json file data to sqlite database that I can query from my website. Is this possible to do with sqlite? I have about 5000 files (which would be index) and each file only contains text, with about 30 columns of data. Sorry for the long post, just wondering if I will be able to learn this within these videos. Also do you happen to have any videos about querying sqlite databases from websites? Thanks!

[@parsabahrambeik4381]

Hi, thank you very much for your video.

[@Codemycom]

Thank you too

[@raa1403]

Hey Baldy bro TNX.for this stuff

[@Codemycom]

Sure thing

[@walidramdani3953]

thanks for this tuto :)

[@Codemycom]

Sure thing!

[@didierleprince6106]

Un big merci (:

[@vachanjinu942]

Thanks a lot sir.you are the best

[@Codemycom]

Thanks!

[@Lennardish]

Hello John, With the help of this Sqlite3 tutorial and one video of yours in which to switch between windows, I succeeded to produce a "Menu" window in which two buttons. One button asking for a "def" to add data to a database, and one button, asking for a "def" to query. I just now have to find out how to make disappear the "menu" window, when I move to the add data window, and how to make the "menu" window reappear by clicking some button in the add window. But. I am thrilled because you showed me the way. Thanks. I continue my quest :) Paul

[@Codemycom]

Awesome, I have videos on that in the playlist :-p

[@Lennardish]

@@Codemycom your explanation is very very clear, and to the point. You produced splendid study tutorials that more or less pave the way for better insight. Consider me to be your greatest fan 🙂

[@Codemycom]

@@Lennardish Thanks!

[@timyoung8839]

Really good tutorial! One question - regarding the need to comment out the 'create table' code after it has been run once since the table has been created. How would you go about doing this if you made a program that was to be run by the public. Would you make an if statement to check if the table already exist and only create a table if it doesn't? Thanks heaps!

[@INSANE_-nj4xh]

Just use. , if exists It is command of database , will create a table if it does not exist and will not create if it exists, it will help u as we don't want multiple tables and error. See more for how to use if exists on utube or google

[@cofeeee77]

Why this channel has only 38k subs this channel deserves more and yes Be sure to smash the like button

[@Codemycom]

I agree! Tell your friends about it ;-)

[@medmabrouki1034]

Sir I need to get messagebox error if identity already exists in database with aded function

[@raniduharshana5238]

Thanks a lot

[@Codemycom]

Happy to help

[@khizarkhan8252]

i m facing this issue when create connection kindly provide solution for it mysql.connector.error.interface:2003 : can't connect to mysql server on ' localhost:3306' (10061 np connection could be made because the target machine actively refused it)

[@Bleu-en2bf]

Thank you😊

[@Codemycom]

You're welcome!

[@sumbulk.8135]

Hello, do we still have to write code for creating tables and stuff if we have already created a table and inserted values in SQLite Studio? Or would it be okay if we only write the connect,sqlite3 code etc?

[@Codemycom]

Once you create all that stuff once, you need to remove that code and not create them again.

[@bazareta6936]

By the way zipcode should be treated as text As no math applied to it Any way keep going man I like your videos 👍

[@elizatreglown3826]

Your videos have been an absolute life saver for my Year 12 digital Technologies course. when I run this database it comes up with the error no module names 'PIL'. Do you have nay suggestions to how to fix this?

[@nickpavlou5023]

hi eliza. you've probably worked it out by now and graduated and moved on!! 😁 but just in case you haven't (joke) you need to import Pillow... Codemy talks about it here: kzbin.info/www/bejne/hKC3fmuAmM6Kl7M

[@ashikgrg4356]

Please make a video on "Fetching data from mysql database randomly"

[@krishnendhus6202]

Hey could anyone helps .. i am making a python project on tyre shop management... with python and sql.. other than tkinter does we need any other library to manage our project??

[@Codemycom]

No one can answer that, it depends entirely on what you're trying to do and what your needs are.

[@kaustubhkoshe1239]

Can you give us tutorial on modern UI design using python like for c# we use metro framework also tell us how to add animations and sound for click event of button like when I press button bee bee sound will buzz of error sound will buzz

[@Codemycom]

Not with TKinter

[@babybigeyes3918]

Sir how I can make a installer of python tkinter exe file which uses database

[@vagisangovindan7123]

can we add an entire values of a row from a table inside a label?. I am doing a Theatre management project using sql and python.

[@Codemycom]

Not really sure what you mean, but give it a try to see.

[@vagisangovindan7123]

@@Codemycom Got it figured out. Thanks a lot for your 6 hour tutorial. helped a ton.

[@pymust]

We have to do 'pip install pillow' before using PIL. Anyway I really appreciate your great videoes.

[@Codemycom]

Yes, of course.

[@AdelHaiba78]

Wonderful, I need help to connect to Xampp SQL, can you help me with this or point me to a video which already exist?, Thanks and regards.

[@luizportela2590]

Turn on the MySQL and Apache on your Xampp and ready.

[@rithiksaran]

sir, If i create a database in my system for my python app and send copies of my app to other systems, Will the systems connect with the database in my system when a 3rd user saves data in the database?

[@Codemycom]

no. how could it? Your database is on your computer. Their database is on their computer.

[@AbdoAhmed-vn1kt]

What if i want date datatype and want to sort records by date or something?

[@Codemycom]

Do it in the normal way

[@sanskargr9347]

how to do analogue clock in tkinter

[@diegobahamondezmunoz5840]

could this be done with postgreSQL instead of SQlite?

[@Codemycom]

Sure, fairly easily

[@mrci7821]

Please I want a possible solution for these error on c.fetchall..... AttributeError: 'sqlite3.Connection' object has no 'fetchall'

[@Codemycom]

you have a typo in your code

[@Cael901]

Hello I know you have a great tutorial but I encounter some problem that I cannot understand and fixed it. I think i might miss out something very imporant while learning sql. Thank you in advance Traceback (most recent call last): File "G:\pythonprogramms\Project test.py", line 33, in c.execute('''CREATE TABLE addresses ( sqlite3.OperationalError: table addresses already exists

[@larslover6559]

Hey.. instead of just CREATE TABLE write CREATE TABLE IF NOT EXISTS. You are getting the error message because you are asking the computer to create something you already had created.

[@vipinpainuly9998]

on click button redirect to another page in python using tkiner library... how can it do sir????? ]

[@Codemycom]

What do you mean by page? Tkinter doesn't have pages

[@EnglishRoyalTea]

Could you make a video about Json with tkinter python please thanks

[@Codemycom]

I have videos where we deal with json from an API, just not with tkinter (but with python). Once you know how to deal with it in python, the tkinter part is irrelevant.

[@stephenaubreyantonio8110]

I just wanted to ask if you have a video about the user will input info and it will automatically be in the database. :)

[@Codemycom]

Of course

[@stephenaubreyantonio8110]

@@Codemycom by any do you know why this errorr keeps on appearing when i'm following your code. cannot import name 'imageTK' from 'PIL' (C:\Users\stephen antonio\anaconda3\lib\site-packages\PIL\__init__.py)

[@Codemycom]

@@stephenaubreyantonio8110 You're using Anaconda instead of regular python..could be because of that

[@stephenaubreyantonio8110]

@@Codemycom I already install pip and it works just fine now, thank youuuu!!

[@ebaadkhan8501]

how to connect our app to a server plz tell us sir if u know plz i am waiting for this video plz and you are our only true teacher on the inter plz teach us how to connect our apps to a server.

[@Codemycom]

connect to a server for what?

[@ebaadkhan8501]

@@Codemycom if i created a heavy app then i need a server for user authentication and more things

[@Codemycom]

@@ebaadkhan8501 what's a heavy app?

[@ebaadkhan8501]

@@Codemycom like i build a game which needs an update so ill have to connect it to server for updates if not then how? BTW you are great i have been asking questions to many teachers but u are the only good teacher who replies to their students

[@varman8048]

This video was very useful...but can you also do one with MySQL too

[@Codemycom]

I have a python mysql course

[@varman8048]

@@Codemycom oh okay didn't see that...thank you keep it up bro

[@Codemycom]

@@varman8048 will do

[@pranavguptaa]

I dont have any knowledge of databases,so can i continue with the course or should i learn about basics of Database?

[@KristoKorps]

I would recommend understanding SQL syntax, like the meaning of the different statements and run through a tutorial on that first. Then you could use SQLite to combine that and tkinter together.

[@pranavguptaa]

@@KristoKorps Yeah,sure🙂

[@kyanos-asteras]

"ImportError: DLL load failed while importing _sqlite3: The specific module could not be found." I have installed sqlite3.dll and all demanded files according to Python's site, but I still get the same error. I want to follow these database courses, but with this error I am forced to stay here. Any ideas?

[@Codemycom]

sqlite3 comes with python, there's nothing to install

[@kyanos-asteras]

@@Codemycom Alright, I didn't know. But why do I get this error? I need to fix this, because I definitely want to make this database and keep following these awesome courses. Thank you.

[@Codemycom]

@@kyanos-asteras I'd go back and watch the videos again and follow them exactly. I can't guess where you went wrong..

[@iliaspelekis1765]

hello while i am writing ..... c.execute("""CREATE TABLE addresses ( first_name text, last_name, text )""") all appears as text in the (""" """) no commands!! what Is my syntax problem?

[@Al-he6bs]

Same

[@iliaspelekis1765]

@@Al-he6bs i found the solution!!! There is NO problem . by writing 3 quotation marks you can write comments in the next line and generally . With 1 quotation mark you can write comments only in 1 row . There is no any command !!! you simple write comments and it is working ! see next video and do the same with the quy and you will figure out

[@Al-he6bs]

@@iliaspelekis1765 So basically, we just have to ignore them being a string. All green colors but working as what they are intended to.

[@iliaspelekis1765]

@@Al-he6bs basically just tested ! the program still working if I put them as comments (#). i think we write them down for future use .

[@binkyslife]

💯💯💯💯💯

[@Codemycom]

Thanks!

[@ryano699]

hi, im doing this on visual studio and its not working. is any one familiar with this issues and knows how to fix it?. the issue is with the create table section as it does not recognise the command?

[@Codemycom]

I never recommend visual studio

[@ryano699]

@@Codemycom what IDE do you use in these videos

[@Codemycom]

Sublime Text and the Git-scm.com terminal @@ryano699

[@generalpinochet9821]

how can you get the oid of any table?

[@Codemycom]

I think I have a video on that in the playlist somewhere...

[@generalpinochet9821]

@@Codemycom I don't see it, can you please tell the name of it?

[@roastedpeanuts1994]

Can you do one with SQL Server?

[@Codemycom]

No sorry, that's a Microsoft thing

[@four-xdimension2486]

Do I need to learn SQL before I learn database in Tkinter

[@Codemycom]

Not really, you can follow along in the videos...but it couldn't hurt.

[@four-xdimension2486]

@@Codemycom Ok Sir, Thanks for replying🙏

[@asf196]

Pls tell me what does the database does

[@Codemycom]

databases store data

[@asf196]

@@Codemycom thank you.

[@nimaojaghi2427]

Hi My Brother And My Good Teacher Who I Learned Many Lessons From Your Teaching Here And I Have One Question That Is About My New Program Thst Is A Phonebook I Am Writing And My Question Is About Checkbutton And Button That I Want To Make One List Of Numbers With Name And Familly And Address From Database That I Made That This List Have 1 Checkbutton For Each Number And Two Buttons For Edit And Delete Now I Am Looking One Way To Know How These All Checkbuttons And Buttons In List Have Conection To Each Other That This Mean Every Record From Database In List With One Checkbutton And To Buttons For That Be In One Conection That When That Checkbutton Is Selected These To Buttons For Edit And Delete Work For That Button So We Have To Conection Here Every Record In This List Need To Be Conect With Checkbutton And Buttons To Operate On It And This Change In Database Be In See. Thank You Very Much God Belesed You And Your Love And Your Familly .

[@pranalibansode3922]

It getting error as no module PIL.. what should I do ?

[@Codemycom]

pip install Pillow

[@pranalibansode3922]

@@CodemycomThank you so much for answering my doubt. But I have already installed pip even it's not working.

[@Codemycom]

@@pranalibansode3922 Some people just have trouble with it. You'll have to google it

[@pranalibansode3922]

@@CodemycomOk. Thank you so much. But your tutorials are excellent. Just thanks for sharing your knowledge heartly.

[@erzio1254]

Traceback (most recent call last): File "C:\gui\database.py", line 2, in from PIL import ImageTk,Image ModuleNotFoundError: No module named 'PIL' sorry im noob pls help how to get into the ternimal

[@Codemycom]

pip install pil pip install pillow

[@kurtauerbach5883]

same no module named pil

[@kurtauerbach5883]

@@Codemycom my windows environment cmd prompt yielded no love

[@kurtauerbach5883]

i just removed the pil and icon stuff more of a hassle than what its worth

[@BeerTrooper]

@@kurtauerbach5883 I had the same problem : Please try in terminal : "pip install Pillow" with capital "P", and then in head - "from PIL import ImageTK, Image It works for me, hope it will for you Have a good one

[@teguh7201]

what the purpose of root.iconbitmap('c:/gui/codemy.ico')? thanks later

[@Codemycom]

To add the icon to the top bar of the program

[@teguh7201]

@@Codemycom. But if I don't add that to the codings, will the codings make it to the end?

[@Codemycom]

@@teguh7201 You don't need to add an icon if you don't want to

[@teguh7201]

@@Codemycom Okay... Thank you. Your channel so helpful.

[@Codemycom]

@@teguh7201 Glad you like it!

[@holycow4889]

I don't completly got why it's better to use sqlite3 than using a simple .txt file to store data. Could anyone explain it in a few words? :D

[@Codemycom]

databases are better in every conceivable way.

[@holycow4889]

@@Codemycom Oh okay. Thanks for answering :)

[@ahmedelsayed3133]

Why do you use "from tkinter import *" instead of just typing "import tkinter"?

[@Codemycom]

Because that's how it needs to be.

[@ahmedelsayed3133]

@@Codemycom Does that apply to other internal functions like "os"?

[@Codemycom]

@@ahmedelsayed3133 no, everything has it's own rules.

[@teguh7201]

sorry, what is meant by PIL import ImageTk, image. program doesn't work because of that

[@Codemycom]

You must install Pillow from the terminal

[@teguh7201]

@@Codemycom and I also have a problem with root.iconbitmap

[@pranyajain2529]

is this error-checked?

[@Codemycom]

lol

[@leeganghalley6477]

I copied the same code.. There was an error

[@Codemycom]

then you don't have the same code...

[@dougedmunds]

You might have trouble with using integer for zipcode unless you can add leading zeros. Look at www.maphill.com/united-states/alaska/zip-codes-00001-00122/

[@leeganghalley6477]

It says PIL module not found

[@Codemycom]

did you pip install pillow?

[@leeganghalley6477]

Yes

[@Codemycom]

Are you sure? are you using a virtual environment? Is it installed in there? Do you see it when you type: pip freeze

[@leeganghalley6477]

I installed python 3.8..my friend told me that pip would be there already.

[@Codemycom]

@@leeganghalley6477 pip is there, but I asked about PIL not pip

[@ianlevitt6920]

CREATE TABLE IF NOT EXISTS addresses. then no need to comment out the code !

[@Codemycom]

Yep

[@timurbabadjanov9115]

So Walter White teaches Python?

[@Codemycom]

Apparently!

[@djha1257]

Walter

[@Codemycom]

lol