4 ms·

There's also Teapot, with FLTK or ncurses-based UI: https://kmandla.wordpress.com/2010/08/11/how-to-use-teapot-like-a-pro/ https://kmandla.wordpress.com/2010/08

by marttt 5y ago

There's also Teapot, with FLTK or ncurses-based UI: https://kmandla.wordpress.com/2010/08/11/how-to-use-teapot-like-a-pro/ https://kmandla.wordpress.com/2010/08/11/how-to-use-teapot-l... Archived homepage of the project: https://web.archive.org/web/20211124073408/https://www.syntax-k.de/projekte/teapot/ https://web.archive.org/web/20211124073408/https://www.synta... Its most relevant feature seems to be 3-dimensional tables. From the home page: "Instead of the unflexible and complicated syntax used to address the values of cells in traditional spread sheets ("B1" or "R1C2"), teapot uses for a more functional approach: "@(1,2,0)". This results in an easily understandable syntax and despite the very few basic functions, very powerful semantics." Haven't used it myself but I was quite curious about it a few years ago. EDIT: Has anybody succeeded in entirely replacing his/her spreadsheet needs with e.g. awk scripts? Seems like a nice exercise in the "first simplify your data structures, then analyze" paradigm.

somat 5y ago
I have pretty much replaced my spreadsheets with postgres(sqlite would have worked as well, but... I really like postgres) simple calculations end up as views, more complicated ones end up as an external script. a postgres function would work, but I find external scripts easier to manage. Once, as a sort of programing kata, I wanted to see if I could turn a simple spreadsheet I found on the internet into a view. transformer calculator: https://ludens.cl/Electron/trafos/trafos.html https://ludens.cl/Electron/trafos/trafos.html I was successful in that I was able to put the logic in what would have been a ten line program into, well, this 150 line monstrosity. same transformer calculator as a view: https://pastebin.com/xyDeAV7R https://pastebin.com/xyDeAV7R Takeaway: the relational database works well to replace the spreadsheet when the spreadsheet is used as a data store, not so much when the spreadsheet is used as a programing language. but for that, the purpose built programing language is far superior.

by marttt 5y ago

somat 5y ago

I have pretty much replaced my spreadsheets with postgres(sqlite would have worked as well, but... I really like postgres) simple calculations end up as views, more complicated ones end up as an external script. a postgres function would work, but I find external scripts easier to manage. Once, as a sort of programing kata, I wanted to see if I could turn a simple spreadsheet I found on the internet into a view. transformer calculator: https://ludens.cl/Electron/trafos/trafos.html https://ludens.cl/Electron/trafos/trafos.html I was successful in that I was able to put the logic in what would have been a ten line program into, well, this 150 line monstrosity. same transformer calculator as a view: https://pastebin.com/xyDeAV7R https://pastebin.com/xyDeAV7R Takeaway: the relational database works well to replace the spreadsheet when the spreadsheet is used as a data store, not so much when the spreadsheet is used as a programing language. but for that, the purpose built programing language is far superior.