Build a SQLite Notes Project — Smartphone Academy

Mission

Create a small database application with parameterised queries, export and tested restoration.

Required work

Create schema with constraints
Use parameterised queries
Export records to JSON
Restore into a clean database and compare counts

Evidence to produce

A schema, CLI or API, backup file and restoration proof.

Quality checks

The result must name its sources, separate observation from assumption, preserve originals and explain limitations.

Prepare the lab

Run these commands inside the Smartphone Academy folder in Termux.

python Smartphone-Academy.py prepare phone-sqlite-project
cd ~/.dedsec-smartphone-academy/workspaces/phone-sqlite-project
python Smartphone-Academy.py check phone-sqlite-project
python Smartphone-Academy.py complete phone-sqlite-project

Local and safe

Use only the supplied fictional samples or data from your own device.