Phoenix Missing Persons Data Backend (historical)

This service is retired. Active development has moved to the phx_data_frontend monorepo, which now contains both the public application and the SQL data pipeline.

The original Express service performed multiple overlapping PostgreSQL aggregations for every page visit even though the underlying dataset was a fixed snapshot. This made the user experience dependent on a hosting cold start and ten concurrent database queries without providing fresher data.

The replacement architecture keeps SQL first-class while moving it out of the visitor request path:

• packages/data/sql contains the normalized materialized view and analytical queries.
• packages/data/scripts/export-snapshot.mjs executes those queries and validates the generated public data contract.
• apps/web prerenders the complete report and a static JSON API with Next.js.
• The checked-in snapshot makes deployments reproducible and independent of a database that cannot receive newer source data.

The Express implementation remains here for historical reference. It should not be deployed as part of the current project.

See the phx_data_frontend overhaul pull request for the migration, verification results, and deployment notes.