Show HN: ZSV (Zip Separated Values) columnar data format

Post by modulus1 » Sat, Apr 13, 2024, 9:01 PM UTC

Post by [deleted] » Sat, Apr 13, 2024, 9:08 PM UTC

modulus1 wrote: post #2

Can't store tabs or newlines, odd choice.

Post by alexandreyc » Sat, Apr 13, 2024, 9:15 PM UTC

hafthor wrote: post #3

modulus1 wrote: post #2

Can't store tabs or newlines, odd choice.

yeah, this is a limitation from the TSV format this is based on - there is an extension to the format that supports storing binary blobs - ref: https://github.com/Hafthor/zsvutil?tab=readme-ov-file#nested...

Post by hafthor » Sat, Apr 13, 2024, 9:19 PM UTC

inimino wrote: post #7

hafthor wrote: post #3

Earlier quoted context omitted.

yeah, this is a limitation from the TSV format this is based on - there is an extension to the format that supports storing binary blobs - ref: https://github.com/Hafthor/zsvutil?tab=readme-ov-file#nested...

(Offtopic, but just FYI) it's tenet (principle) not tenant (building resident).

Post by tboerstad » Sat, Apr 13, 2024, 9:28 PM UTC

alexandreyc wrote: post #6

hafthor wrote: post #3

Earlier quoted context omitted.

yeah, this is a limitation from the TSV format this is based on - there is an extension to the format that supports storing binary blobs - ref: https://github.com/Hafthor/zsvutil?tab=readme-ov-file#nested...

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!