Each query/command is a single HTTP GET request. The spreadsheet is all done in pure canvas, and there's a JS equivalent for the backend, so it can work off-line and synch up.
If you take a cell and for its child you fill in just A1, you get back the scalar (x.A1 is the same as x in this case); but if you fill in A1, A2, A3 you get back the array [x,y,z] and can access it with an index; if you fill in A1, B1, C1, you get back the object: {A:"x",B:"y",C:"z"}; and of course, if you do both, you get an array of objects.
Also, I'm confused about "spreadsheet is all done in pure canvas". Are you talking about canvas of HTML5?
The UI is spreadsheet in HTML5 Canvas: http://kayia.org (but this is for development -- it's very early)
The project is hosted on Github: https://github.com/david927/Kayia
The spreadsheet is the data editor, but it's much more powerful than what you currently see. Otherwise, you're right, you can create what you want; one app I want to do is a better version of Google Wave once the authorization module is plugged in.
The stack: Python, Django, Backbone.js, MySQL, Solr, Redis, Nginx, Gunicorn.
The integration between Django and Backbone.js was a b*tch. I'll hopefully be osing two small apps that make it a breeze for others.
2) (attempting to) Revive a forum for SaaS builders I started a few months back: http://www.saasaholics.com
I bounced from SaaSaholics once I saw it was a generic message board. That won't cut it these days. Gotta have a more social UI.
LAMP stack - never touched any of them before building this and the only ever other code I wrote was a little ASP about 10 years ago (when I say little it was one recruitment site). So this has been a real learning experience.
It took 30 days to build and implement, I am pretty please with the results so far. Thoughts?
I'm also trying to find the time to go through Zed's Learn Python the Hard Way.
It started as an exercise to learn python (using the Flask micro-framework), but I have really fallen for the idea and love working on it.
What are you working on?
http://olekbeluga.com/notepad/notebook_mockup.html as a hobby.