clasp
perspective
Our great sponsors
clasp | perspective | |
---|---|---|
20 | 45 | |
4,366 | 7,493 | |
1.9% | 3.8% | |
6.5 | 9.4 | |
about 1 month ago | 10 days ago | |
TypeScript | C++ | |
Apache License 2.0 | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
clasp
-
How to make a Gmail Addon
First, you will need to create an App Script project. Navigate here to create one. The easiest way to manage deployments and upload of your add-on code is with clasp. In order to use clasp, turn on the setting that allows CLI tools. Then install clasp and run clasp login. Once you login, run clasp clone
-
Writing a Google Script en VS code.
CLASP in combination with types for auto complete. Make sure you add the node_modules forlder to the .claspignore file..
-
Beginning with Apps Script. What are your "I wish I knew before I started" moments
For big projects you can use CLASP to program inside you're own editor of choice. With types installed you have intellisense (autocomplete)
-
Can other editors to a document I own edit my app script and access my account?
Use a local editor with GIT and clasp
-
What language do you code a google sheet add on in?
There are some possibilities..
- How to Write Google Apps Script Code Locally In Your Favorite IDE?
-
How to automate Google Apps Script deployments with GitHub Actions
Luckily there is the awesome tool named clasp that allows you to develop your Apps Script projects locally. That means you can check your code into GitHub source control and use your favorite tools (I use VS-Code) to develop Apps Script scripts. Best of all, it allows you to automate the Apps Script code deployment by using Github Actions.
-
noob question: see function parameters in the app script editor
As addition. You may want to develop in vscode (what I like to do) and use clasp clone / push your code. With types installed you have autocomplete. You can make a .claspignore for you test files and the node_module folder.
-
Creating a Management Game in Google Sheets
Btw, if you don't already know about it, clasp (https://developers.google.com/apps-script/guides/clasp) can be a big help. It lets you develop more like normal (using your favorite IDE, committing to github, etc.) rather than rely on the online GAS editor.
-
How to build a knowledge system with Slack and Notion
Install Clasp at first if you haven't done it yet.
perspective
-
The Design Philosophy of Great Tables (Software Package)
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.
-
Show HN: WhatTheDuck – open-source, in-browser SQL on CSV files
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.
-
React Spreadsheet 2 – Your Own Google Sheets
Yes. We are working on adding support for aggregation and pivoting using https://github.com/finos/perspective
-
Show HN: DataSheetGrid, an Airtable-like React component
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.
- Perspective Market Simulation
-
ChDB: Embedded OLAP SQL Engine Powered by ClickHouse
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.
- Show HN: Udsv.js – A faster CSV parser in 5KB (min)
- Perspective 2.0, Open Source WebAssembly-Powered BI
What are some alternatives?
nocodb - 🔥 🔥 🔥 Open Source Airtable Alternative
ag-Grid - The best JavaScript Data Table for building Enterprise Applications. Supports React / Angular / Vue / Plain JavaScript.
express-app-cli - CLI application for generating NodeJS / Express projects
arquero - Query processing and transformation of array-backed data tables.
automate_apps_script_deployment - http://gorankukurin.com/g-suite/google-sheets/how-to-automate-google-apps-script-deployments-with-github-actions/
gas-slack2notion - gas-slack2notion is a starter kit to post messages via Google Sheets from Slack to Notion.
datapane - Build and share data reports in 100% Python
apps-script-samples - Apps Script samples for Google Workspace products.
ClickHouse - ClickHouse® is a free analytics DBMS for big data
fuelPrices - fuelPrices: Twitter Bot Running on Google Apps Script
SandDance - Visually explore, understand, and present your data.