Hacker News new | ask | show | jobs
by s_dev 2087 days ago
A normalised correctly structured SQL DB?
1 comments

I'm not a backend developer, but isn't that likely to be in the terabytes? This seems to be issues around tens of thousands of rows.
A normalised SQL DB will have zero redundancy. It would also easily handle these data set sizes. The only reason Excel was chosen was because clearly some clerk just felt more familiar with the tool and didn't have the experience to know better.

The reality is though for storing this kind of relational data -- it's a solved problem -- SQL would have been the correct tool to employ.