Case study

Fete Finder Operations

Work on the system behind the public programme: data management, publishing, backups, placements, analytics, and the launch controls that kept a cultural product dependable across 3,000+ registrations and 50,000+ unique visitors.

Context
Out Of Office Collective / 2025-26
Focus
Postgres, admin workflows, backups, revalidation, partner reporting, analytics
Link
fete.outofofficecollective.co.uk

The public experience could only feel calm if the operating model behind it was calm too. Event data changed, partners needed placements, hosts submitted updates, and launch traffic made manual recovery paths too risky to leave implicit.

Thread Work Signal
Runtime data Built a Postgres-backed event store, CSV import/export paths, backups, local fallback, validation, and revalidation controls. The public site could keep serving useful event data even when the live store needed recovery or republishing.
Admin workflow Built admin surfaces for content editing, operations, placements, insights, submissions moderation, runtime health, and rollback. The launch workflow became a set of explicit operational moves rather than a bundle of manual interventions.
Partner signal Built spotlight/promoted scheduling, partner activation queues, tokenized partner stats, engagement tracking, and reporting exports. Commercial placements could be operated with traceable performance without breaking the public discovery experience.
Layer Detail
Source chain Managed Postgres event store first, latest backup second, bundled CSV fallback last.
Data quality Event assembly, date normalization, event keys, field transformers, quality checks, and warning surfaces.
Publishing Event sheet editor, manual backups, save-and-revalidate flow, live runtime snapshot, and restore path.
Security Admin sessions, route-level authentication, cron secrets, deploy revalidation tokens, and rate-limit storage.
Placements Featured schedule, promoted schedule, Stripe activation ingestion, partner queues, and tokenized reporting pages.
Analytics Event engagement, discovery analytics, calendar-save signal, outbound clicks, partner rates, and CSV export.
  1. Event data enters through admin, import, or submission paths.
  2. Assembly and validation turn messy rows into stable public event objects.
  3. Operators back up, publish, revalidate, and inspect runtime status.
  4. Placements are scheduled and fulfilled without becoming hard-coded editorial state.
  5. Engagement and partner reports turn launch activity into a measurable signal.

The important work was making the launch less dependent on a single perfect path. A public campaign can absorb change when data, publishing, recovery, placements, and reporting each have explicit contracts.