Python Backend script for Graphic User Interface (GUI) - SQL Functions

This is real world example how to design SQLite3 functions for Python application.

By this I try to answer to etudiant edutiand Youtube user.

In this video I demonstrate how to create functions for all GUI buttons (real world example). This is simple SQL type functions and requests to Python database.

For this purpose sqlite3 library is used.

Python GUI buttons that SQL request are created for:
- Add Entry (INSERT) : 4:05
- View (SELECT * from book) : 5:14
- Search (SELECT * from book WHERE ...) : 6:10
- Delete selected (DELETE from book WHERE ...) : 7:48
- Update selected (UPDATE book SET ...) : 8:46

Sorry for watermark in the video, for this time I used trial version of Camtasia...

Best regards
Vytautas

[paullong]

I wish you would have finished this tutorial. It was one of the best I've seen that was beginner friendly.

[jakovljevicdjordje]

That comma tip while deleting is a lifesaver
Thank you very much

[StingerSecSol]

Best explanation I have seen regarding sqlite3 yet. Thank you.

[harrythompson]

Hi, when will you upload the video off you showing how to integrate the back end functions into the application so it works as it should? Please could you upload it? Thank you

[zzssstt_]

Hi, it would be great of you to upload the following part of the video. Actually, I dont know how to show the different enries in the listbox.

[jmarusiak]

Thank you for this tuturial, helped me a lot. When will you have the next video uploaded??

[AnhTuan-vrld]

Hello, Could you help me find the final video which connect backend and frontend?

[venugopalm]

Hi, you did a wonderful work. Explained every detail in simple terms easy for us to understand - it shows you know the subject really well and have the skill to teach us. I know that you would be busy with other commitments, and could not upload the next video. Could you please let me know which book I should read to understand further steps in detail in simple terms the way you did... Thanks in advance...

[gayathrisiva]

Thanks a lot this is very useful !! you said to upload the last part this video, will please tell where can i find that?

[opiyosebastian]

Great tutorial, thanks for the good job Vytautas.

[fredrickmrema]

thanks for the video..real helpful..waiting for the next video of this project

[garrylane]

When is the next video to this tutorial going to be released?

[shraddhakshirsagar]

i have come Operational error:no such table:books..what can I do..plz help

[robmanda]

Where is the followup to this great tutorial

[aditya.singh]

how can we make this for multiple tables in database

[urbanwildcat]

Thank you for this videos, it helps a lot.

[baljeetkaur]

when you will upload the next part of this project?

[samirkhanra]

Hey, Vytautas Bielinskas plz upload the connection scripts of this series ASAP

[etudiantetudiant]

THANK YOU VERY MATCH IT IS HELP ME TO UNDRASTAND THE TKINTER

[trunks]

does any one have the third video or code?