Aperture Analytics

Real-time product analytics at billion-event scale

Client

Series B SaaS

Role

Product & Platform Engineering

Year

2024

Duration

6 months

Challenge

The client was hitting query latency walls at 10B+ events with their existing warehouse. Dashboards took 30+ seconds and blocked product decisions.

Solution

We re-architected the ingestion pipeline on Kafka + ClickHouse, introduced pre-aggregated materialized views, and rebuilt the app on Next.js 14 with server components and streaming. Query p95 dropped from 28s to 680ms.

41x

faster dashboards

10B+

events / day

99.99%

ingestion SLA

Tech stack

Next.jsClickHouseKafkaTailwindtRPC

Have a similar product in mind?

Let's explore how we can help you ship faster.

More work

View all

Mobile

Northwind Mobile

Field-service mobile app used daily by 20k technicians across 14 countries.

Web

Vertex Commerce

Headless commerce platform powering 1M+ monthly orders for a D2C fashion brand.

SaaS

Lumen Health

HIPAA-compliant telehealth platform connecting specialists with patients worldwide.