← All projects

Part 4 of this project

Data Layer

Create notes and notebooks tables and seed samples

Goal for this part

Create notes and notebooks tables and seed samples.

Treat 04-Data-Layer as the source of truth for this checkpoint. If your local tree drifted, re-clone that folder rather than mixing files from neighbors.

What you should already know

You do not need prior Tkinter experience for part 1. Later parts assume you finished the earlier snapshots on the same machine.

  • You can open a terminal and run python3
  • You are comfortable editing a .py file and saving it
  • You have a desktop session (not a headless SSH box without display forwarding)

Why Tkinter fits Leafbind

Tkinter ships with Python, so a notes desk teaches widgets and SQLite without a GUI installer.

A list of notes beside a Text widget is the classic notes layout. Keep SQL in a small db helper.

Checkpoint

After you run the snapshot, you should recognize the behavior described in the goal—before you move on. If the window (or server) never appears, stop and fix the run steps.

Code shape

Snapshots stay small on purpose. Look for this kind of core call as you read the folder:

conn.execute("CREATE TABLE notes(id INTEGER PRIMARY KEY, title TEXT, body TEXT, updated_at TEXT)")

How to run it

Clone the teaching repo, open 04-Data-Layer, install what the README asks for, then run python3 app.py.

git clone https://github.com/michaeldunga1/fcc-tkinter-notes.git
cd fcc-tkinter-notes/04-Data-Layer
# stdlib — no pip packages required for the teaching snapshots
python3 app.py

Common mistakes

  • Ignoring platform-specific install notes in the snapshot README
  • Creating tables twice with conflicting schemas
  • Forgetting to commit/close the database connection in long sessions
  • Looking for seed data in part 3 before the data layer exists

Related tutorials