# PIL Magic · UI/UX Replacement

The Magic/Hafill UI/UX analysis and the decision to replace the cockpit with a Postgres-backed system of record: 29 databases, 59 GB, 94M rows, zero screens documented, and a 44-second film.

**Status:** Private · Projects · 2026

- **Local checkout:** `/Users/simon/Developer/magic-uiux-video`
- **Watch the film:** https://ai-pricing.navonsimon.com/media/magic-uiux.mp4
- **Review #13:** https://ai-pricing.navonsimon.com/#/magic
- **Note:** Internal office work; the source systems were read-only and the replacement has not been built yet.

## Stack

Magic xpa 9.4 / Hafill 3.4.24 (source), SQL Server 2017 (source), PostgreSQL 17, HyperFrames 0.9.19, ffmpeg, React + Vite (planned)

## Start here

- `index.html` — HyperFrames root composition: six scenes, 44s, 1080p30, music and station ticks
- `compositions/s1.html … s6.html` — the six scenes: hook, engine, data, gap, plan, end
- `SPEC.md` — the director's brief: look, objects, motion, shots, bans and QA frames
- `renders/magic-uiux.mp4` — the delivered 44s film, 1080p30, H.264 + AAC
- `~/Developer/pil/office-refresh` — the analysis and transformation plan the film summarises
- `~/Developer/pil/observations/sql-schema-2026-11-06` — the read-only SQL Server schema scan
- `~/Developer/magic-copy` — on win01: copy_magic.py, sync_magic.py, manifest.json and the raw Postgres copy

## Commands

- **Render the film:** `cd ~/Developer/magic-uiux-video && npx hyperframes@0.9.19 render --quality delivery -o renders/magic-uiux.mp4`
- **Preview the film:** `cd ~/Developer/magic-uiux-video && npm run dev`
- **Check the composition:** `cd ~/Developer/magic-uiux-video && npx hyperframes@0.9.19 check --json`
- **Read the analysis:** `python3 ~/Developer/my-projects/tools/brief.py "pil magic"`

## Deploy and where it runs

- The film is served from https://ai-pricing.navonsimon.com/media/magic-uiux.mp4; the review is https://ai-pricing.navonsimon.com/#/magic; the project page is https://projects.navonsimon.com/p/pil-magic

## Current state

2026-11-06: the read-only copy is complete (29 DBs, 59 GB, 94,032,648 rows, zero failures). The UI inventory is not done (0 screens documented). The decision is a full, staged replacement on PostgreSQL; no new app code has been written yet. The 44s film is delivered and review #13 is live.

## Watch out

- Magic and Barak are read-only, always; never write to them.
- The raw Postgres copy stores Hebrew as cp1255 bytes decoded as latin-1, so every text column needs one normalization pass.
- The schema has no PK/FK; integrity is application-enforced and the business rules live in ~345 routines.
- The live year is not the stale INI value; confirm it before choosing SHDB<year>.
- Report formats (Excel/PDF/RTL) are the strictest parity test.
- The UI inventory is the missing evidence: 0 screens documented so far.

## Tags

Magic/Hafill, PostgreSQL, UI/UX, Hebrew RTL, HyperFrames

---

Brief generated 2026-11-08 from `~/Developer/my-projects/context/`. Canonical URL: https://projects.navonsimon.com/context/pil-magic.md
