4 ms·
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 m
by micheljansen 13y ago
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).
- cousin_it 13y agoYeah, 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?
- _delirium 13y agoIt doesn't have very SQLish syntax, but there are various JSON ports of XPath and XQuery from the XML world.
- cousin_it 13y agoOoh, that's exactly what I was looking for. Thanks!
- schrodinger 13y agolinq 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.
- antfarm 13y agohttp://stedolan.github.io/jq/ http://stedolan.github.io/jq/
- spolu 13y agoYep 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!
- RaphiePS 13y agoDoes 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.
- clhodapp 13y agoHave you looked at the spreadsheets in Google Drive?
- mton 13y agoGoogle 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 http://www.youtube.com/watch?v=INHh3EN3jfI Here's a link : https://docs.google.com/spreadsheet/ccc?key=0Ak0Zu3w86Ux5dEtYZkpuV1Y5dWpfRG1KTTNKSEZ1RXc&usp=drive_web#gid=4 https://docs.google.com/spreadsheet/ccc?key=0Ak0Zu3w86Ux5dEt...