Dextrac

client work

How I turned minute-long analytics into one-second loads for a blockchain indexer that processed 10M+ transactions a month.

Full stack developer Page loads from minutes to 1-2s, data at worst 5 minutes stale 2023-2024

Prism at a conference

Dextrac is a node operator for the Chainlink ecosystem. I started on the frontend and then worked on its indexer and data-processing pipelines.

Before Chainlink SmartCon in 2023, analytics views had grown slow enough to take minutes. I replaced cache warming with background jobs that precomputed daily aggregates per metric type. Queries that scanned millions of rows then read a few hundred. Loads fell to one or two seconds and current-day reports refreshed every few minutes.

← all projects