Mesh is still very much an alpha. Since the last public commit I have been experimenting with:
- different text representations of the sheet (to make diffs as readable as possible)
- ways to compress more functionality into the 'boilerplate' included with each sheet.
On the to-do list are:
- persistence (including fixing "save sheet as URL" and local load/save)
- selecting input cells with a keyboard while editing a formula
- a way to include 'standard' spreadsheet formulas such as 'SUM' on-demand in the sheet file
- case-insensitive cell references
- much more polish...
JavaScript's lack of a built-in parser is a real bummer, and it means that while Mesh's backend logic can be written as a spreadsheet, in Mesh [1], the file has to include a third-party JS parser, which significantly slows down the editing process. I'd also like a proper SQL and first-class table support, but we work with what is supported by Internet Explorer 11.
I remain confident that we can substantially improve the status quo of spreadsheets and, by extension, programming.
The only two projects I know regarding "visual programming" that I think "are on the money" are Mesh Spreadsheet and Hyperfiddle. Luna-lang, even if in theory is great, didn't click with me. Observablehq is also interesting but I don't have a use case for it.
Keep the good work!
edit - some remarks to "get there": it must be/feel fast like native Excel, Sublime Text or at least VS code. In another phase, to be a real "programming editor" it would be great if you could use any programming language you want, not just JS. Clojurescript or Elm/Purescript could be a good start.
edit2 > ways to compress more functionality into the 'boilerplate' included with each sheet. I think the boilerplate should be somehow hidden from the end user.
Is your compiler running on an interpreted language? I think to make this sort of product fast requires JIT compiling the users expressions, and doing some sort of whole program analysis to pull out the dependencies between cells.
I do whole program analysis, and the host is not interpreted. The costs are mostly about the data structures used to store the intermediate values. Automatically selecting whether to make some values contiguous or not is difficult, and the types are a bit complex (basically option types).
The sheets I'm working with have around a million expressions, and there are large sparse regions, so the data structures have to be a bit compact.
I also think it would be valuable to autoconvert long lines (rows or columns) of similar formulas into a mapping on an array. That would require some level of shape analysis on the excel file.
That is in fact the first step, we have around 800k instances, but only around 1500 unique combinations of dependency shape and expression, which makes a big difference.
Not yet, gotta do our jobs first, then we can have the candy. :- )
I would like to do a write-up about it at some point though, if for no other reason but to show the Open Document or LibreOffice people what could be improved about the formats.
Not every programming language is suitable but ClojureScript would probably work (no plans to support it right now though, gotta finish this one first!).
Considering hiding the boilerplate in the text pane.
This is really cool! Do you develop all of Mesh in itself exclusively, or do you still use a regular text editor as well? Either way I can certainly see this as being useful. I starred the project on GitHub and look forward to see what more is to come.
Aside from the SQL support you mentioned wanting to add, and the various todo-items, are you planning on going beyond the spreadsheet concept? For example with some type of node-based interface, like Unreal Engine 4 Blueprints [1], or like the materials editor in Blender [2]? I realize that might be a vague question, heh.
Thanks! I honestly haven't developed much of Mesh in Mesh, because it's still early in the 'bootstrap cycle' and due to the parse delay issue mentioned above. It's also not nearly as robust to errors as it should be - text editors and traditional spreadsheets allow the user to 'sketch' ideas as discussed by Aaron Hsu [1].
I'd like to stick to a grid for writing 'functional core' logic, but there's potential to use a node interface at the surface of the 'imperative shell', to link up sheets or data feeds (push/pull). I was really impressed by Nodes [2] and I need to spend some time digging into Node-RED [3].
I wonder if a spreadsheet and its editor could go in a self-contained HTML file. You'd open it in a browser, it modifies its own source code, and you just re-export or "Save Page As" when you're done?
Furthermore, maybe the data could be in CSV at the top of the file, in an HTML comment, and the editor could be in HTML at the bottom of the file, in a CSV comment, so the file could be opened in either a browser or Excel? Haha
Programatically invoking the "Save As" dialog seems troublesome. Maybe there could be a signed WebExtension blob in the file, too - or it should download the latest updated library script every time the file is opened (although then there are security & CORS issues).
Chris do you want to chat? I'm a founder in this space. Can you add contact info here or on github, or open twitter DMs or something:) My contact in profile.
> I'd also like a proper SQL and first-class table support, but we work with what is supported by Internet Explorer 11.
If you were thinking about WebSQL, then sticking to IE11 has skipped you over an obstacle course in web standards, because WebSQL was abandoned by the browsers (for good reasons, led by Mozilla and Microsoft trying not to let SQLite bugs define the web platform for decades) and won't be supported again soon, in lieu of the much simpler key-value store called IndexedDB.
> JavaScript's lack of a built-in parser is a real bummer
I'd be really interested in the ability to put in probability ranges for cell values and run monte-carlo simulations to get the final values (Excel+montecarlo has been a pet idea of mine for years but I haven't got the time to do it)
Pretty cool, some basic documentation would be nice (the readme does not tell everything). I didn't find how to reproduce some of the behavior of the loan example in the GIF, like how to format cells (turns out formatting is just writing a function that transforms a value and assigning it to the cell's 'f' field. Are there other special fields ?). I can't seem to make sub-table creation work, after creating a table with ctrl-alt-t, I seem to be stuck in table edition mode, I can't click on another cell or press enter or tab to deselect a cell.
I think it's a pretty promising project. Spreadsheets are very useful tools but usually crippled by single-line, crappy, not syntax-checking, not highlighting function editors.
Yes - there are, or will be, other special fields, such as 'transpose' (so table headers would go in the first column instead of the first row). I was still figuring out which flags should be included, which is why it was under-documented.
Never expected sub-tables as a use case. Displaying nested cells would require a substantial re-write, but having logically nested tables may work... you'd just need to call the table making boilerplate function manually.
If you’d like to see more of Mesh in action, here’s a long form video of an early version showing how to write a primitive RSS reader in a Mesh spreadsheet and use it as the backend to a website. Back then typing into a blank cell created a name; it now creates a value and uses the cell position as the default name. Cell references also had to be preceded with $; we now just add cell names as properties of the global object so you don’t need a prefix.
Nice project. I always wanted a Python based spreadhshet. One where all the formulas are written in python, with access to all the standard library and more. This project is in javascript, but maybe someone could do it in python one day.
Tangent: I'm reminded of [Mobx creator] Michael Weststrate's post^1 citing familiar spreadsheet formulas and input cells as a way to explain concepts of derivations and observables in mobx (his excellent state mgmt lib, which imho improves on redux), making React actually "reactive".
Neat project, although selecting cells often does not work. (I assume that's because it's in alpha.)
This line, though:
> is lightweight: ~2000 lines of source code (excluding libraries)
I feel like that's a very different meaning of "lightweight" than I normally think of. I guess you're considering it from the perspective of a developer who works on it. As a user, however, the browser downloads 1.4MB of javascript, which is quite large, I'd say.
Not sure why, but the edit button doesn’t seem to work, and I think that is preventing the keyboard from coming up (using virtual, not physical keyboard).
- $95/mo for a single user sets the impression that this is way out of reach for anything I'd consider. Clearly, I'm not the customer.
- The fact that it appears to be using traditional spreadsheet formulas gives me concerns about how general it might be. Mesh is intriguing for its more flexible programming and table model.
- There's a live chat module on your page that appears to not be able to be dismissed, which blocks a lot of the page content.
Mesh is still very much an alpha. Since the last public commit I have been experimenting with:
- different text representations of the sheet (to make diffs as readable as possible)
- ways to compress more functionality into the 'boilerplate' included with each sheet.
On the to-do list are:
- persistence (including fixing "save sheet as URL" and local load/save)
- selecting input cells with a keyboard while editing a formula
- a way to include 'standard' spreadsheet formulas such as 'SUM' on-demand in the sheet file
- case-insensitive cell references
- much more polish...
JavaScript's lack of a built-in parser is a real bummer, and it means that while Mesh's backend logic can be written as a spreadsheet, in Mesh [1], the file has to include a third-party JS parser, which significantly slows down the editing process. I'd also like a proper SQL and first-class table support, but we work with what is supported by Internet Explorer 11.
I remain confident that we can substantially improve the status quo of spreadsheets and, by extension, programming.
[1] https://twitter.com/MeshSpreadsheet/status/10195553103635046...