Live data from Hacker News

Stencila – Spreadsheet-like live reactive programming environment

stenci.la

91–100 of 101 posts

Re: Stencila – Spreadsheet-like live reactive programming environment

#91

I am personally a fan of Calca, not only does it do live coding, it can also do some powerful math: http://calca.io/

Calca is a beast — one of the most unique and useful OS X apps on my machine. FYI, the iOS version is free right now. (EDIT: I see that the author switched to a pay-if-you-want model for the iOS version.)

Re: Stencila – Spreadsheet-like live reactive programming environment

#92

This article reminded me of an interesting video by Chris Granger, co-author of the Light Table code editor, titled "In Search of Tomorrow: What does programming look like in 10 years?" He's designing a visual/code block hybrid editor. https://www.youtube.com/watch?v=VZQoAKJPbh8

Came here to say this. 'Eve' seems to have a nice future ahead of it..

Re: Stencila – Spreadsheet-like live reactive programming environment

#93

I've been shifting a bunch of data analysis out of spreadsheets (and some adhoc SQL) to Jupyter/Pandas, and we've found some unexpected tradeoffs on both sides. The lack of testability and version control (and really, long-term maintainability) is what drove us out of spreadsheets into Jupyter. We've found though that the workflow in Jupyter, even with Pandas, is not great for exploring and getting a feel for data --…

Matt, check out my EasyMorph (http://easymorph.com) -- it's like Excel for tabular data with a comprehensive set of pre-built transformations to replace Python scripting. It's intended for both "quick poking around" and doing complex analysis.

Re: Stencila – Spreadsheet-like live reactive programming environment

#94

Off-topic: how do people make those animated gifs like the one in the blog post ( https://stenci.la/stencila/blog/introducing-sheets/screencas... )?

Hey, author here. I used byzanz for this one: https://www.maketecheasier.com/record-screen-as-animated-gif... . For snazzier stuff, Screenflow is good.

Re: Stencila – Spreadsheet-like live reactive programming environment

#96
post #18

Earlier quoted context omitted.

Sooner or later, all project management ends up in Excel. Doesn't matter what ticket or tracking tool you've paid for.

My experience has been that it always ends up in Google Docs. Collaboration in Docs is just so stupidly easy compared to emailing spreadsheets around. And yeah I've been through several cycles of this: start tracking in google docs, we'll get a system eventually. -> OK we have bought a new PM system, let's start using it. -> Everyone please start using the new system. Move your google docs there today. -> I ... why i…

Purpose-built software systems allow you to ask a lot of important questions, but they don't allow you to ask all of the important questions. It's useful to have a tool that you can fall back on that gives you a basic representation of the data that you can manipulate with simple tools. For most people that will be a spreadsheet. You can also do it with *nix tools but they're really unapproachable for the uninitiated.

Re: Stencila – Spreadsheet-like live reactive programming environment

#97
hi - quick question. Is your Dockerfile open source ? We have been building an R powered backend for one of our analytics services and it's been a struggle getting a scalable R-based infrastructure going.

BTW - another killer usecase would be an easy way to build database backed spreadsheets. instead of the TSV, it would be cool to figure out how to interface to postgresql for example.

Re: Stencila – Spreadsheet-like live reactive programming environment

#98

hi - quick question. Is your Dockerfile open source ? We have been building an R powered backend for one of our analytics services and it's been a struggle getting a scalable R-based infrastructure going. BTW - another killer usecase would be an easy way to build database backed spreadsheets. instead of the TSV, it would be cool to figure out how to interface to postgresql for example.

Hey, yeah it's all open. The Dockerfile is here: https://github.com/stencila/stencila/blob/master/docker/ubun... I'm no expert, but it seems to be doing the job. Would appreciate any suggestions you might have! I'd like to make it smaller i.e. use a smaller base image.

Re: Stencila – Spreadsheet-like live reactive programming environment

#99
post #64
post #8

Iteration on spreadsheets is great, and there's opportunity for tons of innovation in this space. But this suffers from the same problems that most spreadsheets have. Errors like not averaging over the right set of data (which you pointed out) don't come up because the code can't be diffed in git. They come up because there's not enough clarity in whether a set of cells are consistent or not. Making this text-based d…

Yes, you're right this doesn't solve all the issues with spreadsheets as a programming environment. The "averaging over the right data" is a big one, and yes, being able to diff a text file won't help that. Thanks a lot for the suggested syntax - it's really good to get some feedback. I need more time to think it through and work out exactly how this would work. In the meantime, one solution to the problem, that I wo…

An interesting extension would be to use the now easily parsable text-based format, and apply static analysis checks to it.

eg.

Warning: C10 has a range from A1:A9 but C9 only has B1:B8

Re: Stencila – Spreadsheet-like live reactive programming environment

#100
post #98

hi - quick question. Is your Dockerfile open source ? We have been building an R powered backend for one of our analytics services and it's been a struggle getting a scalable R-based infrastructure going. BTW - another killer usecase would be an easy way to build database backed spreadsheets. instead of the TSV, it would be cool to figure out how to interface to postgresql for example.

Hey, yeah it's all open. The Dockerfile is here: https://github.com/stencila/stencila/blob/master/docker/ubun... I'm no expert, but it seems to be doing the job. Would appreciate any suggestions you might have! I'd like to make it smaller i.e. use a smaller base image.

just one comment - your entire js is basically building a reactive workflow through vanilla js. it is a very commendable piece of work!

however, I'm wondering if using Reactjs+Redux would not reduce the amount of js by many orders of magnitude. You would get all your reactive processing for free.

EDIT: your CPP code is quite cool ! But same comment there, you could probably use nodejs and npm packages to get this out of the box for free. for example - git.cpp -> https://www.npmjs.com/package/git, frame.cpp -> https://www.npmjs.com/package/dataframe, http-client -> https://github.com/mzabriskie/axios + https://github.com/petkaantonov/bluebird, etc.

Post reply on HN