Writing · Tagged
#systems-engineering
3 articles
· 28 min read · Part 4 of 4
Streaming Excel to a Database Without Losing a Single Row
The data pipeline behind a warehouse system: exporting snapshots to Excel, streaming bulk imports over gRPC with typed error codes, staging tables, atomic database swaps, and the SQL Server migration that made it all possible.
· 22 min read · Part 3 of 4
Running a Warehouse System on a 4 GB Server with No Docker
The architecture behind a production warehouse system: Koa.js over Express, gRPC for process isolation, Unix pipes for log forwarding, systemd instead of Docker, and a polyglot monorepo where a Rust/WASM binary is just another npm package.
· 14 min read · Part 1 of 4
Walking Is the Most Expensive Warehouse Operation
How one engineer built a custom route optimization system for a small Italian warehouse: the problem, the constraints, and why naive pick sequences waste half an operator's shift.