Create GUI App with Tkinter and SQLite - Step by Step Python Tutorial for Beginners

This beginner tutorial builds a Tkinter desktop recipe picker connected to an SQLite database. It covers window and widget layout, callbacks, frame switching, SQL queries, record preprocessing, and custom fonts.

Syllabus

- intro
- starter files and wireframe
- create empty Tkinter window
- run Tkinter app
- set window title
- center window on the screen Eval method
- create Frame widget with custom width, height and background
- center window with Geometry method alternative approach
- create image widget
- center widgets in frame with pack propagate
- create Label widget
- fonts in Tkinter
- create Button widget
- change cursor to pointing hand
- button callback and why lambda is important
- add padding around widgets
- code refactoring
- connect SQLite database file
- database architecture walkthrough
- select all table names of a database with SQL
- fetch random database tables with SQL and NumPy
- fetch table records
- preprocess table name and records
- conditional list comprehension
- switch between frames
- remove widgets from frame
- sticky remove white corners
- label background in full window width
- use CUSTOM FONTS in Tkinter
- Pyglet
- Thanks for watching! :