All work
Developer tool · 2026

Mockup Studio

A local-first mockup composer: stack screenshots in device frames on a designer canvas, export portfolio-grade PNGs or 5-second WebM loops — no subscription.

Type
Developer tool
Year
2026
Stack
Python · Flask · SQLAlchemy
PythonFlaskSQLAlchemyAlembicSQLite (WAL)
Mockup Studio
The problem

Presenting web work means placing screenshots in device frames on a polished canvas. The existing tools charge monthly subscriptions for what is, mechanically, a compositing job.

Constraints
  • 01

    Must run entirely locally — no accounts, no cloud, no uploads.

  • 02

    Canvas state evolves every release (new effects, new layer properties) — the data model must not require a migration treadmill.

  • 03

    Export must produce portfolio-grade PNG and short WebM video from the same composition.

What was built
  1. 01

    A Flask app serving a single-page canvas editor: drag screenshots into device frames, layer them, add background effects and shadow scenes.

  2. 02

    Two-table SQLAlchemy model (folders + drafts) where each draft stores the full canvas state as a versioned JSON blob (state.schema_version).

  3. 03

    An images API for uploading source screenshots and serving them back; drafts and folders fully CRUD.

  4. 04

    Alembic-managed migrations, pytest suite, and a fresh-clone-friendly setup (the runtime data directory is tracked so a clone boots with no manual steps).

Engineering decisions

JSON blob over wide tables

The editor's state shape changes every release, so drafts are stored as one versioned JSON blob instead of a column per property — schema_version gates future migrations instead of a migration per feature.

Local-first by architecture

No cloud dependencies in the request path — the app is designed to be run by the person using it, and the deployment story is a single container or process.

Result
  • ✓

    12/12 pytest suite passing.

  • ✓

    Boot verified end-to-end from a fresh clone: venv → install → alembic upgrade → server → full folders/drafts API (create and read verified).