News for hackers. Stuff that matters.
Re:REPL: To JSON what Excel is to CSV by micheljansen on Wednesday February 19, 2014 @04:06AM (#7262651)
Pretty clever, but pretty obscure compared to Excel.

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).

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)
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.
Re:REPL: To JSON what Excel is to CSV by mton on Wednesday February 19, 2014 @09:50AM (#7263837)
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?
Re:REPL: To JSON what Excel is to CSV by spolu on Wednesday February 19, 2014 @05:36AM (#7262941)
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!