4 ms·
This gets me thinking. I wonder if why spreadsheets become something like programming-lite is that it allows for rapid prototyping and iterating. This because
by digi_owl 11y ago
This gets me thinking.
I wonder if why spreadsheets become something like programming-lite is that it allows for rapid prototyping and iterating.
This because the user can manipulate the content of variables directly, and watch the result change as they do. This then allows them to test smaller parts of the logic before aiming the result at another piece of logic and thus building a larger structure piece by piece.
The problem with using spreadsheets for this is that as you move stuff around the logic parts break.
So what if we had something like a variable grid and a logic sheet? So that any variable read or written was up in a grid like that of a spreadsheet, for easy reference and manipulation, while the logic was of somewhere else. Thus moving things around to make room for more logic didn't influence the variables etc.
And to take a step back, i wonder if this ease of prototyping was one of the things that made micro-computers so potent. This because they booted directly into a Basic interpreter (prototyping), while at the same time there was no persistent storage you could screw up with crap code (just flick the power and get back to it).
- notduncansmith 11y agoI think flow-based programming was supposed to be something like that. As spreadsheets show us, we haven't really figured out how to scale this approach to more complex applications.
- swsieber 11y agoSpreadsheets show us that 2d grids and a lack of other programming concepts make it very hard - it's a distinct subset of flow programming: A unit of code an take an arbitrary number of inputs from a 2d grid and give you 1 output. Real Flow programming lets you have multiple inputs and outputs and aren't constrained to 2d. I think the biggest constraint is representing the dimensionality and interaction ... but we have classes and deep package structure in Java, so it's probably more of a effect than cause, but still a blocker to wide adoption.