News for hackers. Stuff that matters.
Re:Show HN: ZSV (Zip Separated Values) columnar data format by alexandreyc on Saturday April 13, 2024 @05:15PM (#40026224)
Basically it's the same limitations as CSV.

At least you could use something less likely to appear in data as record sepator (like 0x1E)

Otherwise it's an interesting idea!

Re:Show HN: ZSV (Zip Separated Values) columnar data format by tboerstad on Saturday April 13, 2024 @05:28PM (#40026320)
0x1E is the record separator, in ASCII precisely for this purpose. Too bad it’s not popular, here we’re stuck with inferior TSV/CSV
Re:Show HN: ZSV (Zip Separated Values) columnar data format by mattnewton on Saturday April 13, 2024 @05:31PM (#40026340)
I can't easily type that out - and once the format can't be read / editing in a simple text editor, I'm starting to lean towards a nice binary format like protobuf.
Re:Show HN: ZSV (Zip Separated Values) columnar data format by orf on Saturday April 13, 2024 @05:30PM (#40026331)
Strings can contain 0x1E, so it has exactly the same issues as a tab character but with all the downsides of it not being an easy, “simple” character.
Re:Show HN: ZSV (Zip Separated Values) columnar data format by bobbylarrybobby on Saturday April 13, 2024 @05:50PM (#40026480)
As far as I know, thanks to quoting it is possible to put basically any data you want in a CSV.
Re:Show HN: ZSV (Zip Separated Values) columnar data format by layer8 on Saturday April 13, 2024 @08:08PM (#40027457)
The problem is there is no uniform standard for quoting and escaping in CSV, and different software uses different variants.
Re:Show HN: ZSV (Zip Separated Values) columnar data format by Dylan16807 on Saturday April 13, 2024 @08:21PM (#40027521)
There is a standard, and it is very simple and easy to use.

Different software uses different variants because we're not allowed to have nice things and devs are too lazy to use something slightly more complicated than .split(',')

Though if you're going to ban some common characters anyway like TSV, you might as well use CSV and ban commas, newlines, and quotation marks.