h a l f b a k e r y
Where life imitates science.
add, search, annotate, link, view, overview, recent, by name, random
news, help, about, links, report a problem
or get an account
A special spreadsheet application implements web response
handling by integrating with a proprietary web server module.
It synchronises request parameters into specific cells B3-B15.
preparses the URL into fields and parameters in B5-B20.
I type SQL into a cell in the first Worksheet.
construct a web response by using functional programming:
map - apply a function to list of things getting a list of things
reduce - apply a function repeatedly to a list, reusing the same
In worksheet 2 (tab 2) you assign fields to the response.
A1 fills the screen and contains HTML on one side of the screen
I find a block of HTML I want to iterate over and select it and
type into the formula block =iterate
Somewhere after A1 I type =map(SQL cell, Worksheet3)
and I can map the SQL into a response HTML.
||I like APIs, spreadsheets and luxury apartments for all. Do you
have a problem with that sir?
||My best idea is lifestyle subscriptions. And Auto API Import.
||And the links to my 205 tech ideas in my profile. Check them
out, you'd have to be a developer to understand some of them
||Spreadsheets are underused technology. They are awesome
and functional programming!
||Parsing your idea I can see you're talking about spreadsheet-driven
website. I think, Google spreadsheets already have forms, you just want
to tear a few levels of abstraction down, to the level where you
how spreadsheet makes http responses, by defining that directly on the
||What an awkward way to get an accountant to make websites. Though,
you could say it's already baked, as pretty much every website works
based on a database, which if relational, is based on a bunch of tables,
for which you need just a spreadsheet UI, and a master sheet holding
||Named ranges might be your friends.
||I want the GUI of a speadsheet to be used to develop
backends. Functional programming and SQL type cells would
make mapping database responses easier. I think it would be
||The back end in question was not to a collection of web
services, but to a BI tool, but the development environment was
an Excel workbook, which was then compiled into something
||I worked with it for a while, and was quite glad to stop working