News for hackers. Stuff that matters.
Re:Loglo: Experimental spreadsheet and stack language for ve... by robocat on Wednesday June 17, 2020 @05:48PM (#23557179)
I developed but never completed a similar idea for custom business rules:

* each spreadsheet defined one function

* one sheet for inputs, each input labeled (i.e. function parameters)

* one sheet for outputs, each output labelled (i.e. function results)

* sheets for test data for inputs and expected output (examples of correct function parameters and results)

* cell values could be result tables from SQL statements, with cell formulas that could act on tables (where, join, etc) i.e. a single cell could contain a table value

* the idea was to allow consultants to naturally design business rules in a functional manner, and intuitively see how values flowed through a calculation. Debugging is natural, and test driven design is built in to the design. Business rules are often driven by examples in my experience.

* Because all calculations are a graph, I believed that the results of complex business rules could be computed efficiently as updates occur.

There was more to it of course.

Re:Loglo: Experimental spreadsheet and stack language for ve... by dgudkov on Thursday June 18, 2020 @02:38AM (#23560400)
We've made a tool for graph calculations on tabular datasets where the results update immediately on changes. Check it out https://easymorph.com. (Disclaimer: I'm the founder).
Re:Loglo: Experimental spreadsheet and stack language for ve... by Recursing on Wednesday June 17, 2020 @07:10PM (#23557931)
You might want to look into tools like knime, for graph based data processing