Creative Optimizer Web

Delivered scope

• Batch converts and optimizes JPEG, PNG, MP4, MOV, and first-page PDF creatives.
• Supports 1920px and 720px maximum-edge presets with aspect ratio preservation.
• Features resumable chunk uploads, SHA checksums, and media probing before processing.
• Includes durable SQLite batch/job state tracking, verified preview outputs, and selective ZIP downloads.

Technology

System approach

• Frontend: React 19 with Vite, Tailwind CSS, Lucide icons, multi-file drag-and-drop, and real-time job progress polling.
• API & Worker Queue: Express 5 backend with concurrent media processing queues powered by Sharp, FFmpeg, and Poppler.
• Persistence Layer: SQLite database storing immutable job snapshots, batch histories, retry states, and operational health metrics.
• Ingestion Engine: Resumable chunk upload handler with SHA checksums, media probing, and temporary asset lifecycle cleanup.

Challenges

• Handling massive batch uploads of mixed media (gigabytes of 4K video, RAW photos, multi-page PDFs) without client browser timeouts or server memory spikes.
• Guaranteeing that invalid or corrupted files in a batch do not abort remaining conversions.
• Maintaining exact aspect ratios while conforming images and video loops to digital screen resolution thresholds.

Solutions

• Engineered a resumable chunk upload protocol with client-side hash validation and streaming media probes.
• Implemented isolated worker queue jobs with immutable SQLite status snapshots and individual retry capabilities.
• Built multi-stage Sharp and FFmpeg transformation pipelines enforcing maximum-edge constraints with proportional scaling.

Key outcomes