hidden · · 5 min read
`ORDER BY random()` still has to see every row
Ask PostgreSQL for 100 random rows and it may still score every candidate. `LIMIT 100` shrinks the result, not the work needed to choose it.
Writing · Tagged
SQL
0 articles
hidden · · 7 min read · Part 3 of 2
The Excel round trip that kept warehouse data safe
The data pipeline behind the warehouse system: spreadsheet exports, safe imports, gRPC streaming, typed validation errors, staging tables, and an atomic swap against the ERP database.
No articles with this tag yet.