4 ms·
> self-rendered cells, processed in place as collections of data sharing the same structure Isn't this .. the spreadsheet? I was entertained watching this dri
by pjc50 4y ago
> self-rendered cells, processed in place as collections of data sharing the same structure
Isn't this .. the spreadsheet? I was entertained watching this drift towards a set of cells in a grid some of which contain formulae and some of which contain data, used for accounting purposes, and wondering when the lightbulb was going to come on.
(Funnily enough I've written my own transaction-annotating system lately. It's in python and stores the data in CSV, having got it from the Nordigen bank interface. EEA programmers may find Nordigen extremely useful: https://nordigen.com/en/coverage/ https://nordigen.com/en/coverage/)
- TuringTest 4y ago> Isn't this .. the spreadsheet? You nailed it, it's a spreadsheet - but one that doesn't constraint all data to live on the same application window, but could access and transform it throughout the whole system - just like copy/paste can transfer data from one program to another, where it can be transformed with a different toolset. Copy/paste is the most fundamental tool in the toolbox of the end user, since it's the only universal* way to transfer data between apps without accessing an API programmatically, so I think it's undeservedly neglected as a tool to build real life practical workflows. Incidentally, spreadsheets are one of the most versatile and successful End-User Development tools, allowing users to build information systems tailored to their business purposes. A system combining those design capabilities with the flexibility of building system-wide workflows could transcend the current model of siloed apps. * Intents on mobile devices are similar, but they are not universal - many times the app to which you want to transfer data is not recognized as a valid target for the shared data.
- the_other 4y agoThe Unix pipe seems like scriptable copy & paste.
- TeMPOraL 4y agoIt's not, because you can't easily spawn transient pipes between running processes. The OS probably allows this, but I've never seen it exposed in the UI layer. Pipes are primarily used to build ad-hoc pipelines that run in batch mode. Copy&paste is a tool for moving specific bits of data on demand between two running programs, or within the same program. Copy&paste interaction model is "please take this and put it there", and the ability to select the this and the there is just as important as transferring the data itself.
- pjc50 4y ago> can't easily spawn transient pipes between running processes. Yeah, while this is theoretically possible it's unmanageable in practice (the "washing line" protocol allows you to send a UNIX pipe file descriptor to another process over a socket). I suspect the nearest thing that made it into production was OLE.
- TuringTest 4y agoI'd say the closest thing in modern systems would be the Stream metaphor (a.k.a. Observer design pattern) in functional reactive programming. This is the construct used to program the spreadsheet's reactive behavior, after all. You could think of users creating spreadsheet formulas as declaring a pipeline at runtime between two datasets, the origin range and the target range. What is missing is a way to create "spreadsheet functions" among different applications. Online computational notebooks a la Jupyter are almost there, but they still need to share the same runtime kernel to transfer data between different books. A combination of notebooks and web hooks should do the trick, methinks, but it needs someone to assemble this brittle system into a robust product.
- agumonkey 4y agoit's one of the next thing in computing IMO
- Izkata 4y agoMaybe by manipulating /proc/12345/fd/* ? Can these be manipulated or are they read-only?
- TeMPOraL 4y ago> Isn't this .. the spreadsheet? As long as by "spreadsheet" you don't mean specifically a 2D grid of cells, but rather a reactive computational graph that just happens to be rendered as 2D grid, in order to not waste so much screen space the way reactive notebooks do :). OK, the waste thing is not that clear-cut. Spreadsheets give you 2D instead of 1D workflow, but then all spreadsheets I know aren't able to store an array of values in a cell, leading to lots of space waste from every array element taking its own cell. I hope one day someone will figure out how to merge reactive notebooks (Observable-style, not Jupyter-style) and spreadsheets - both are the same thing underneath, it's just the presentation layer that's different, with complementary pros and cons.
- TuringTest 4y ago> I hope one day someone will figure out how to merge reactive notebooks (Observable-style, not Jupyter-style) and spreadsheet I'm working on that exactly - I have several conceptual designs for presentation and interaction, that's where my wit concept comes from as an abstraction to represent cells in the reactive graph, which can be seen either as an array or as a single cell with a label and a prototypic value. Once you liberate the concept from the 2D grid, dependencies between variables create lots of interesting navigation and presentation problems and expanded possibilities. Unfortunately I don't have much time for side projects and my programming skills are a bit rusty, so I haven't advanced much in terms of actual implementation. Moreover, my 'universal' requirement of having it available as a system-wide background service would take a lot of work :-(
- projektfu 4y agohttps://en.wikipedia.org/wiki/Lotus_Improv https://en.wikipedia.org/wiki/Lotus_Improv I'm still not sure why this model didn't win out, aside from entrenched use of other spreadsheets.
- TuringTest 4y agoMS Excel has largely replicated the Improv model as an optional mode within formulas, allowing you to create Ranges as names for groups of cells and allowing you to use the names as variables in formulas instead of coordinates. However, it lacks the flexibility of a true dataflow model. They incorporated the full model into the Power Pivot plugin, and later migrated it to a standalone app as Power BI. It's a reasonably complete paradigm, but much less well-known than the spreadsheet. https://spreadsheeto.com/power-pivot-vs-bi/ https://spreadsheeto.com/power-pivot-vs-bi/