Using SQLite3 For Our ToDo List App part 2 - PyQt5 GUI Thursdays #15

In this video we'll finish adding the SQLite3 database to our Todo List App with PyQT5 and Python.

We'll use SQLite3 as the database to store all our to-do lists. That way the data will be saved even when we close the app. Every time we open it up, our todo list will be just how we left it.

#pyqt5 #codemy #JohnElder

Timecodes
0:00​​ - Introduction
1:45 - Import Sqlite3
1:57 - Create or Connect To Database
2:55 - Create Database Table
4:52 - Grab Data From Database
7:01 - Output Records To GUI List
8:02 - Save ToDo List To Database
9:00 - Delete Previous Data From Table
9:52 - Insert Data Into Table
11:08 - Test Out The Program
12:40 - Create Message Box Popup
15:33 - Conclusion

[Codemycom]

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

[RyanDanielG]

Great job, great python tutorials, great lessons
FEED that algorithm if you want more like this guys. Theres not any other ppl on youtube doing this so well

[rostislavbroz]

It's always such a pleasing moment when I see you published a new video. No matter the topic. :D

[azarsirdash]

Thank you very much for the excellent training

[protform]

Amazing course, I am going through your PYQT5 playlist and is incredible how well explained it is for such short videos. I am trying to create an app based on my PhD topic and it involves using PYQTGraph since my goal is to have interactive plots that change live with sliders. I did it before with Matlab's GUI but it was painfully slow.

Anyway, great vids! Sad the series ended.

[labialkosta]

Great video I will smash that like button before watching the video

[Fatima.senouci]

really is so amazing and thank you so much

[romeomalonzo]

Hi John,

This tutorial is amazing!

I have done it myself and even got to the point where I have converted this to an .exe file but my dilemna is when you save it to the database and close the program it does not really retain the input that I have entered previously.

This is just a slight concern but your effort on doing these videos are much appreciated.

Keep up the good work!

[shuvam]

Hello sir,
Will please make a video on PyQt5 licensing at the end of the this course. I tried to read the PyQt5 licensing documentation but I barely understood it .
And by the way these free courses of yours has helped me a lot.

[christressler]

Awesome vids thanks!
Question: is there a way to get rid of the (Windows?) chime when the pop up box appears?

[scott]

Exactly what I need SQLite3 db manipulation from a 'gui" interface video. Thanks so much. I did Informix SQL many many years back at a job. This was a great refresher video for me. Did I miss a video or something ? What happened to TKinter did it get changed to QT within python?

[ErenMC_]

Can you please make a vid on doing this with MySQL?

[jiakai]

how about saving the font of the text? because i created a done method to strike out tasks

[codeKeshav]

Sir John, looks at the side monitor while import QMessage

[teosmi]

Hi, very interresting. I a unique database table, it woks perfectly, but when I create a relation with another table, the new data are not written into the table.
Do you have any suggestion? Thank you

[riautechdev]

may i know what is the key difference between your courses on codemy and the tutorial you shared on youtube?

[satanthegamer]

Hey John quick question, why do we save msg.exec_() to a variable as in "x = msg.exec_()"?

[sanskargr]

can you show me how to make notpad in pyQt5

[augustusbatilojibba]

Hello! I have an issue with sqlite3 in production with pyqt5. I pushed the application to production in beta stage, if I do any changes it works but if I restart the application the changes I made initially are no longer there. Can you help me to fix this issue?

[hiwab]

if you would've added a search bar it would be even better.