3 ms·
Yes, CSV is superior to JSON for tabular data, but has it's own issues. One issue is that the standard is not consistently applied. Another is the approach to e
by hermitcrab 4y ago
Yes, CSV is superior to JSON for tabular data, but has it's own issues. One issue is that the standard is not consistently applied. Another is the approach to escaping means that it is hard to parse a CSV file with multiple threads. You have to parse the entire file before you can be sure which " characters escape other characters.
I wrote an article about tabular formats and their strengths and weaknesses here:
https://successfulsoftware.net/2022/04/30/why-isnt-there-a-decent-file-format-for-tabular-data/ https://successfulsoftware.net/2022/04/30/why-isnt-there-a-d...
The resulting HN discussion is here:
https://news.ycombinator.com/item?id=31220841 https://news.ycombinator.com/item?id=31220841
- _dain_ 4y ago>CSV is superior to JSON for tabular data Can't you just do this? { "columns": ["col1", "col2", "col3"], "data": [ [1, 2, 3], [4, 5, 6], [7, 8, 9] ] } That's valid JSON but it's human-readable and human-editable rows of comma-separated data, just like CSV.
- hermitcrab 4y agoYou can. But I don't see how that is superior to the equivalent CSV.
- foul 4y agoUntil you try to either cram it into Excel, work with different encodings or pass it around different software platforms (even your lang vs JS), no difference. CSV has been abused a lot to make it work on conflicting use-cases, JSON handles a lot of misshaps happened with delimiter-separated record formats, like new-lines or bring-your-own-character encoding.