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 RaphiePS on Wednesday February 19, 2014 @09:38AM
(#7263779)
Does anyone know of a JavaScript-powered Excel clone? As in, roughly the same spreadsheet UI, but I could write custom functions in JS rather than having to write everything in Visual Basic.
Google Docs SpreadSheet supports javascript. And I manage to use it to build weekly memory reports when I was working on Halo 4 : http://www.youtube.com/watch?v=INHh3EN3jfI
Here's a link : https://docs.google.com/spreadsheet/ccc?key=0Ak0Zu3w86Ux5dEt...
Re:REPL: To JSON what Excel is to CSV
by clhodapp on Wednesday February 19, 2014 @09:42AM
(#7263799)
Have you looked at the spreadsheets in Google Drive?
Yep that's true. The main idea behind repl is to empower our bizdev to manipulate simple JSON data when Excel is not enough or whenever an API is required.
For now it's really at prototype stage of course and we still have to figure out if it's really useful and how we could make it more useful!
The power of Excel is that you can manipulate the data within the view itself, so for that comparison to make sense, I would expect to be able to add a node to the data, for example, and define its contents using a formula (function).