W3C home > Mailing lists > Public > public-rdf-dawg@w3.org > July to September 2011

Re: CSV/TSV comments

From: Steve Harris <steve.harris@garlik.com>
Date: Wed, 27 Jul 2011 20:40:45 +0100
Cc: SPARQL Working Group <public-rdf-dawg@w3.org>
Message-Id: <17C968F1-B8E3-4E9F-B650-12340092FB65@garlik.com>
To: Lee Feigenbaum <lee@thefigtrees.net>
Conversely, we are big fan of the TSV format, as written.

We've used a very similar format inside Garlik for 4-5 years, as it's very efficient for Javascript/Perl/Python to process, without losing any typing information, and also easy for humans to read.

The format has been supported in 4store since its public release, and it's reasonably widely used.

The way I look at it is: CSV is for loading into spreadsheets, TSV is for processing by bespoke software.

- Steve

On 2011-07-27, at 19:22, Lee Feigenbaum wrote:

> Danny Kahn, a colleague of mine at Cambridge Semantics, looked over http://www.w3.org/2009/sparql/docs/csv-tsv-results/results-csv-tsv.html . He compared it with how we currently implement CSV and TSV results to SPARQL in Anzo.
> Here are the differences:
> 1. Both our CSV and TSV formats do not serialize the details of RDF terms.
> 2. Our implementation optionally includes headers for CSV. We don't use the header=absent content type parameter to indicate this.
> 3. Our TSV implementation makes the header line optional, just as with CSV.
> I have not been that engaged in this discussion yet, but I'm surprised to see these significant differences between CSV and TSV, whereas I normally view these as basically the same format but with a different separating character. I'm not a big fan of the TSV format as currently specified.
> Looking briefly over the document, I think the section on serializing CSV needs a bit of work -- it seems to specify the order that solution bindings should emitted in terms of the header row, but the header row is optional. Even in cases where the header row is omitted, rows needs to emit variables in a consistent order, right?
> Lee

Steve Harris, CTO, Garlik Limited
1-3 Halford Road, Richmond, TW10 6AW, UK
+44 20 8439 8203  http://www.garlik.com/
Registered in England and Wales 535 7233 VAT # 849 0517 11
Registered office: Thames House, Portsmouth Road, Esher, Surrey, KT10 9AD
Received on Wednesday, 27 July 2011 19:41:16 UTC

This archive was generated by hypermail 2.3.1 : Wednesday, 7 January 2015 15:01:04 UTC