Bridgeproof — Database Migration & Access Checks

Bridgeproof is an independent engineering study built with fictional data. It rehearses a database migration locally, then makes the integrity and access checks inspectable.

The working proof moves two owners, two projects and four tasks through an explicit legacy-ID mapping. It reconciles every compared field and relationship, repeats the import without duplicates, and rejects changed content under an existing ID rather than silently overwriting it.

All 21 local PostgreSQL checks passed. A task assigned to the wrong owner was rejected before any destination insert attempt. A separate injected write failure rolled back the new rows. Database row policies restricted cross-owner reads and writes while allowing the correct owner to create, read, update and delete a task.

The responsive report viewer exposes the saved evidence behind each check. This uses PGlite/PostgreSQL with a simulated identity context: hosted Supabase login, real Base44 exports, client code and live cutover have not been tested. This is a bounded rehearsal, not a production-security certification or client result.

Original AI-assisted engineering study. Source, fixtures and runnable implementation remain private. Planning an app migration? Message me on Contra with your current platform, data structure and target timeline.