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.