4 ms·
I'm absolutely, unequivocally not trying to be snarky, but isn't CSV itself perfect for this use-case?
by stdbrouw 9y ago
I'm absolutely, unequivocally not trying to be snarky, but isn't CSV itself perfect for this use-case?
- lukechilds 9y agoOnly if you want the entire dataset. Datasette allows you to query for a subset of data.
- _wmd 9y agoCSV files have a single order and no support for indexes. Even if you sort your CSV on one or more interesting columns and use binary search to locate an interesting range, you can still only do this along a single dimension, any remaining queries must scan the entire file. You'd also have to write all the code for this yourself. SQLite is a much better solution
- simonw 9y agoCSV is a pretty terrible format for storing and transmitting data: it only supports string types, the escaping rules are poorly understood, and it can only model a single flat table.