News for hackers. Stuff that matters.
Re:People suck at technical interviews (2014) by tetromino_ on Friday June 10, 2016 @11:55AM (#11877272)
By implementing only that 1% of a real database's functionality that this task requires. Consider: you have only one table, no updates or deletes or transactions, fixed schema, and very, very simple queries.

So it's just a matter of parsing the CSV into some native data structure in your favorite language and then computing sort indices of the columns by which rows might be queried.

Re:People suck at technical interviews (2014) by infinite8s on Friday June 10, 2016 @12:00PM (#11877318)
And sadly you don't even need to create sort indices. Just reading the data into a list of tuples and a few list comprehensions would provide all the querying needed (it wouldn't be efficient but most candidates can't even get that far)