Using SQLite3 Database With Kivy - Python Kivy GUI Tutorial #55

In this video I'll show you how to start using the SQLite3 Database with your Kivy Apps!

We'll start by learning how to add SQLite3, the built in database that comes with python to your Kivy app.

We'll create a very basic app that lets us add a name to the database, and then show all the database records on the screen.

#kivy #codemy #JohnElder

Timecodes

0:00​​ - Introduction
1:53 - Create .kv GUI
4:21 - Import SQLite3 Into Kivy
4:47 - Define Submit and Show_Records Function
5:40 - Create Or Connect To Database
6:50 - Create Database Table If Not Exists
8:54 - Submit Record To Database
10:56 - Add Submission Message
11:38 - Clear The Input Box
12:14 - Show Records From Database
13:30 - Loop Thru Records And Output To Screen
14:36 - Fix Errors
15:35 - Output Text Instead of Tuple
16:01 - Conclusion

[Codemycom]

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

[jonathanguy]

You are my hero Mr Elder you always seem to put what i need since the time started doing tkinter amd even now in kivy you are the best God Bless You

[erickstephen]

I just blame my self for not knowing this channel earlier
I would have been a developer already. Bro if there is anyone know how to teach is you, ,you are a big help to me 🙏

[claudineievangelistanascim]

Thanks John! You are really help me a lot! Success for you man!

[BatMan-mktf]

Now I am Learning flask from ur videos😃😃😃😃😃😇😇☺☺

[NetNuggets]

Hey john thanks a lot for your videos they are great! im very happy anytime i can find a video of yours revelant to something im working on.

[xballer]

Yes!! I have been waiting for this video for so long! Thanks! :D

[josiasferia]

Thanks John, here is a little something to implement Update. clue = self.root.ids.word_input.text.split(', ') and then, use the clue list to obtain both values, the old one and the new. c.execute("UPDATE na SET n=:n WHERE n=:u", {'u': clue[0], 'n': clue[1]})

[borneoviral]

Hey John can you please make a similar tutorial but using postgresql and online server for the db. Would love to learn that from you. I learned alot from your kivi tutorial.

[Diq_Yoda]

Appreciate the video, is there a source where i could learn how to delete this type of data? Ive looked around and I can only find how to delete data in a different format.

[heinoplaatjies]

Hi, thanks for this great video. Tell me, which would you prefer, sqlite or msql? Which of the two is more resource intensive, and which can easily be bundled with python kivy apps in an install file. I assume is sqlite since it is coming with python already?

[BatMan-mktf]

Wonderful sir in next video put how to connect kivy with MySQL database it is best than sqlite

[aavalos]

Great tutorial. Thank you for sharing. But I turned this app into apk and it keeps crashing on my phone. Any suggestions?

[rskhome]

Hi John, Thanks for your tutorial. This is very much helpful in my python kivy learning process. I have written a same script along with your tutorial and it runs well in my ubuntu. but when i create apk and try to install in my samsung mobile. it will not run. it closed immediately after my click. what goes wrong in my side, if possible please help me

[zemljopisac]

Hi, always great lectures! Whole thing with SQLite3 works smoothly but I experience one flaw. When I create table with 2 columns, first row is always empty. Do you know why?

[totaamin]

How to call function in second window?

[marcelolino]

"Thank you for the quality content. I have a form, and after deploying with Buildozer, I cannot locate the .db file on Android. The app installs correctly. It works perfectly on Windows or Linux. How can I solve this?"

[TheRadiant]

HI, can you explane how can I put numpy array noise to Image widget in Kivy app??

[shunyeve]

Thank you so much for this! Can you please make a video about JsonStore?

[catalinacalveramaldonado]

HI! I love all of your videos and I signed up to codemy but I can't find anything on kivy on there?