News for hackers. Stuff that matters.
Re:REPL: To JSON what Excel is to CSV by cousin_it on Wednesday February 19, 2014 @04:53AM (#7262812)
Yeah, I don't understand the comparison to Excel either.

What I really want is SQL for JSON. Regular SQL is a declarative language for transforming flat lists of records into other flat lists of records, and the challenge is extending it to allow nested records. Has that been done?

Re:REPL: To JSON what Excel is to CSV by _delirium on Wednesday February 19, 2014 @09:06AM (#7263649)
It doesn't have very SQLish syntax, but there are various JSON ports of XPath and XQuery from the XML world.
Re:REPL: To JSON what Excel is to CSV by cousin_it on Wednesday February 19, 2014 @09:37AM (#7263773)
Ooh, that's exactly what I was looking for. Thanks!
Re:REPL: To JSON what Excel is to CSV by schrodinger on Wednesday February 19, 2014 @09:26AM (#7263720)
linq in .Net does a pretty good job with SQL-like queries against nested records. Also, many SQL implementations support querying against XML data stored within the database, which is effectively a nested record.
Re:REPL: To JSON what Excel is to CSV by antfarm on Wednesday February 19, 2014 @02:55PM (#7265806)