HN Explorer

UK Covid App Drops 16000 results due to file truncation

2 points by nickdothutton ↗ HN
On the day we learned that the UK’s Covid app truncated 16000 results because the input file was too large, it feels like a good time to re-post this from 2017: https://blog.eutopian.io/the-age-of-invisible-disasters/

1 comment

[ 3.7 ms ] story [ 15.8 ms ] thread
codemusings
It's also important to be precise. No, not the App dropped 16000 results. The automation process that gathered the results into an Excel Workbook used the old XLS Format which has this limit and quietly fails when it is exceeded.

So while we can all joke about using Excel as a database this one's really on Microsoft.