Focaloid Engineering Case Study

Archive and Sync Services

An enterprise client in the automotive safety manufacturing sector now runs two backend services in production: an Archive Service that automates the full lifecycle of closing out an OpenProject project, and a Sync Service that replaced a legacy cron-based sync with a modern ETL pipeline.

Fastify
TypeScript
Apache Airflow
Docker
Live in production

On real production volume of 1.1 million-plus records, the rebuilt sync dropped from roughly 90 minutes to 17-20, using a quarter of the memory it used to.

Live inProduction
3x
faster sync throughput
75%
lower peak memory
1.1M+
records per sync workflow
8
phase automated archive workflow