apps-script-samples VS perspective

One of the things that stifles openness is noise. Sifting through our public repos, some are very obviously redundant and just distracting. So we started by archiving a whole bunch of them - over half, in fact. We wrote some Google Apps Script in a spreadsheet to import and analyze the state of all our public repos:

From my current employer I discovered that you can get surprisingly high mileage with spreadsheets and a little bit of scripting.

My employer uses Google Sheets with app scripts [1].

It automatically reads emails, updates a bunch of spreadsheets, makes other API calls, creates entire report documents etc.

The initial setup might take a while though.

[1] https://developers.google.com/apps-script

I have completed https://grasshopper.app entirely with no prior knowledge of coding. It is very hands on easy to follow. There is more doing coding than reading and each question has a walkthrough available. It is by Google and directs you too Google's own coding platform when you finish. It covers the basics of coding, automation, HTML/CSS/JavaScript and Google's AppScript that work with apps like Google Drive and Sheets. Each course has a PDF certificate of completion. (Last I checked the app was bricked and suggested using the webpage until they figured out the bug with the new operating system.)

Did you consider Google Sheets? It has an API for reading and writing rows, you can run queries against it, it has built-in access control, it has a well-working user interface that supports multiple simultaneous users, and it is no-code. If needed you can go "low-code" by extending Google Sheets with Apps Script.

Apps Script: Extend and automate everything 🔗Link

Google Apps Script is a scripting platform developed by Google for light-weight application development, in the Google Workspace platform (wikipedia) and RapidAPI is a marketplace for APIs.

If we're talking about making something really easily for a small data set with minimal programming knowledge and time required, Google Apps Script would probably be a good bet. Similarly, if your organization has Microsoft Office 365 instead of Google Workspace, you might try out their Office Scripts and Power Automate.

Write an API client in Apps Script that would monitor your Management Sheet and make appropriate API calls

If you haven't looked into it yet - Google Apps Script [0] is an incredibly powerful system when combined with Google Sheets. You can integrate lots of business processes together and integrate with classic spreadsheet functionality, we use it a lot in business!

[0] https://developers.google.com/apps-script

Why do you want to render to canvas?

Perspective seems to be the most performant html table. It is more focused on extremely fast updates than styling, although it looks good.

Glide is a newcomer that also renders to canvas.

https://github.com/finos/perspective

https://github.com/glideapps/glide-data-grid

SQL workbench also uses https://perspective.finos.org/ for tables. It's a WASM table library which pairs nicely with duckdb and works well with large tables.

Yes. We are working on adding support for aggregation and pivoting using https://github.com/finos/perspective

I haven't looked extensively at react-datasheet. It looks like it is trying to build more of a full product than the other data tables.

I have used ag-grid extensively, its an impressive product. Some pieces are a little awkward to use, particularly auto-sizing. But generally ag-grid has thought of most functionality and has a solution. The creator of ag-grid had a great interview on Javascript Jabber [1].

The other serious data table component that I have seen is FinOS Perspective [2]. This is extremely high performance, also more specialized and probably harder to customize. I think Perspective renders to a canvas element from Rust/C++ compiled to WASM (not 100% sure). It is also made for streaming updates.

AG-Grid supports streaming updates... but only in the commercial version.

Eventually the data model for these types of tables becomes tricky. I will be investigating parquet-wasm for my use case. Hit me up if you want to collaborate.

[1] https://blog.ag-grid.com/javascript-jabber-podcast/

[2] https://perspective.finos.org/

Something like https://github.com/finos/perspective ? We use an OLAP(-y) WASM engine to provide query-ability to our data visualization tool, and doing the calculations in the browser is cheaper and simpler than a server-side database for datasets that fit in browser memory.

It's an open source project. You could create an issue on their GitHub repo, or better yet, create a PR and reference this existing issue:

https://github.com/finos/perspective/issues/2133

We're looking for senior product managers and engineers of all experience levels to build the next generation of collaborative data visualization. At the Prospective Co., you'll contribute to our existing open-source project as well as help design our enterprise offering.

https://perspective.finos.org/

We're looking for any of:

- Familiarity with WebAssembly, data visualization, WebGL/OpenGL, data science, Jupyter/notebook, web/desktop/mobile UI development, compiler/language or database design, finance services.

- Primary stack is Rust (targeting WebAssembly). JavaScript, C++ and Python are a big plus.

- We <3 GitHub contributors - opt to discuss your GitHub work in lieu of a technical interview.

Contact [email protected]