From the blog

Tagged · Engineering

3 articles on Engineering.

A fixed-width SSIM record transforming into typed, partitioned columnar rows ready for a data warehouse, in Active Flights brand violet on near-black.
·Engineering

From SSIM to your warehouse: normalizing schedule data for analytics

A fixed-width schedule file and an analytics warehouse want very different shapes. Getting from one to the other — typed, normalized, partitioned, columnar — is the unglamorous work that makes schedule data queryable at scale.

Read article →
A diagram contrasting data kept on a local machine against data uploaded to a cloud, with a determinism strip showing the same file always yielding the same answer, in Active Flights brand blue on near-black.
·Engineering

Why local-first, deterministic tooling matters for schedule data

Two properties do most of the work in trustworthy schedule tooling: the data stays on your machine, and the same file always produces the same answer. Here's why both matter more than they sound.

Read article →
Two cost curves over time — an in-house parser climbing steadily while a bought tool stays flat — in Active Flights brand cyan on near-black.
·Engineering

Build vs buy: the true cost of an in-house SSIM parser

Writing your own schedule parser looks cheap — one engineer, a week, done. The real cost is the maintenance treadmill that follows. Here's the total-cost-of-ownership case, honestly.

Read article →