Data Platform / May 29, 2026
Database-backed catalog and provenance foundation
The catalog moved from sample-only data toward a Drizzle/Postgres layer with migrations, search, provenance, and import tooling.
What is new
- Added Drizzle schema, migration runner, rollback flow, seed runner, and Supabase mirror policies.
- Moved catalog reads through server-side DB helpers with sample data fallback for local development.
- Added Postgres full-text search for bike and manufacturer records.
- Added field-level geometry provenance, versioned geometry ranges, and Wikipedia importer provenance backfill.
What got fixed
- Kept app routes usable without DATABASE_URL by falling back to the bundled sample catalog.
- Added offline migration status and rollback dry-run checks for safer handoff between agents.
- Separated source priority and verification state so newer imported rows can coexist with older seed rows.
What is coming
- Run live migrations and catalog smoke against an available Supabase/Postgres environment.
- Expand source coverage beyond Wikipedia into OEM spec pages and measured rider submissions.
- Use verified contribution data to promote provisional bike geometry over time.