Writing · Tagged
#warehouse-logistics
4 articles
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.
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.
Three Generations of a Warehouse Routing Engine
From a Node.js solver built on npm libraries to a 144 KB Rust/WASM binary with Jump Point Search, compile-time code generation, and a nearest-neighbor + 2-opt solver that closes within 1% of the ILP optimum.
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.