4 ms·
Wouldn't a relational database be better and faster-querying and more space efficient in most cases, e.g. sqlite? Wonder what use cases would favor large collec
by QuadrupleA 7y ago
Wouldn't a relational database be better and faster-querying and more space efficient in most cases, e.g. sqlite? Wonder what use cases would favor large collections of text / TSV files?
- perl4ever 7y agoPeople use delimited text files to transfer data from one database to another. I'm thinking of lawyers in particular. https://en.wikipedia.org/wiki/Load_file https://en.wikipedia.org/wiki/Load_file
- pletnes 7y agoIf you’re getting TSV files from an external source and are interested in just some aggregate results, you’ll get better performance by computing the smaller results and storing these than if you first import, then process, then delete the data in a SQL db. Also you don’t have to store the data twice.