Jun 2021Learning1 min read

Schema-Driven School CRUD GUI

A desktop GUI that introspects a SQLite schema at runtime and generates navigation, CRUD forms and tables from it: a compact low-code engine instead of hand-built screens.

Add a SQLite table: get navigation, forms, and grids for free

Python / Tkinter / SQLite

What made it interesting

Most school projects hardcode one form per table. This one reads the schema on boot and builds the UI from columns and types. Adding a bus-routes table meant updating SQL: the nav and forms appeared without new Tkinter code.

Caveats (on purpose)

Early project: string-built SQL in places, pickle session file, desktop-only. Treat it as a pattern demo (runtime UI from schema), not a production admin.

What it demonstrates

  • Preferring data-driven UI over copy-paste screens
  • How far a small introspection loop can go for CRUD
  • Knowing which corners were cut and why they mattered later