Historical Gallery
Digital Archive Platform



An organization's institutional memory lived across thousands of photos, scanned documents, videos, and audio recordings - stored in Google Drive folders with inconsistent naming and no way to search across them. The goal was to build a system that could ingest that entire corpus, enrich it with machine-generated metadata, and surface it through a polished research interface.
What Was Built
A full-stack platform where files flow in automatically. When a new file lands in Google Drive, a webhook triggers a processing pipeline: a Python microservice generates smart-cropped thumbnails (with portrait-aware cropping to preserve faces), a second service renders PDFs to images, text is extracted via a hybrid approach that tries native parsing first and falls back to Google Cloud Vision OCR for scanned documents, and finally OpenAI generates 15-20 contextual tags per item - covering topics, people, places, organizations, events, and time periods - with no manual effort required.
Research Interface
Built in Next.js with TypeScript. Editors can search full text across filenames, captions, and extracted PDF content simultaneously. Filtering stacks across media type, year, folder, and tags, with an interactive word cloud and year-distribution bar chart providing visual entry points into the collection. A three-tier RBAC system (admin, editor, public) ensures confidential materials are never exposed to the wrong audience, and every metadata change is recorded in a full audit log.
Infrastructure
Microservices run on Google Cloud Run (auto-scaling, containerized), the database lives on Supabase PostgreSQL with a dedicated schema and soft-delete architecture, and Terraform provisions AWS Lambda + S3 for automated daily backups with 30-day retention and Slack alerting.
Outcome
An unstructured archive became a fully searchable, AI-tagged, access-controlled research tool - with zero ongoing manual metadata work required for new ingestion.









