Treeview Primary Key With SQLite3 - Python Tkinter GUI Tutorial

Published: 04 May 2021
on channel: Codemy.com

18,644

415

In this video we'll update our treeview to use the SQLite3 Primary Key ID number for each record instead of the dummy ID number we created earlier.

Primary keys are unique ID numbers that SQLite3 creates for each record in the database. It's important to use those ID's when referencing a record because they are unique. There may be 10 John Elder's in the database, but there is only one John Elder with Primary Key 12 (or whatever).

In this video we'll update our treeview to use those Primary Key ID Numbers.

#tkinter #codemy

Timecodes
0:00 - Introduction
1:19 - What is a Database Primary Key
2:32 - What is the Database Returning?
3:23 - Print Database Table To Terminal
4:20 - Query rowid From Database Table
5:34 - Update Treeview App With Primary Key
8:44 - Confirm Entry Boxes Still Work As Expected
10:33 - Conclusion

On this page of the site you can watch the video online Treeview Primary Key With SQLite3 - Python Tkinter GUI Tutorial with a duration of hours minute second in good quality, which was uploaded by the user Codemy.com 04 May 2021, share the link with friends and acquaintances, this video has already been watched 18,644 times on youtube and it was liked by 415 viewers. Enjoy your viewing!