#engineering
4 articles tagged #engineering.

Querying a schedule with SQL
Sometimes the fastest way to answer a schedule question is to write the query yourself. Here's what it means to treat a parsed SSIM schedule as read-only tables you can ask SQL against — locally, with your data staying on your machine.

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.

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.

Why Airplane Windows Are Round — a Deadly Lesson from 1954
Airplane windows have rounded corners for a reason written in tragedy. The story of the world's first jetliner and the physics of a sharp corner.