spreadapi
dailygraphics-next
| spreadapi | dailygraphics-next | |
|---|---|---|
| 4 | 1 | |
| 81 | 63 | |
| - | - | |
| 3.6 | 3.9 | |
| 16 days ago | about 2 months ago | |
| JavaScript | JavaScript | |
| GNU General Public License v3.0 or later | MIT License |
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.
spreadapi
-
Using Google Sheets as the back end/APIs of your app
Just tried it out. The script is able to handle multiple commands (GET, POST, etc) in one go, but you will have to package the payload as an array.
See https://github.com/ziolko/spreadapi/blob/master/spread-api.j...
As an example:
curl -L \ -
Ask HN: Experience using your user's Google Drive instead of a database?
I'm doing something similar, but using SpreadAPI (https://spreadapi.roombelt.com/) which is free and uses Google Apps Script for myself.
I use GPTs with it to save ideas / thoughts / notes, but also to parse URLs with lists like "best burgers" and GPTs will just add details to the sheets.
Sheets is GREAT for personal / small group use, but if you're a massive company you'll probably run into limitations quickly (5 API calls/s; 200k cells; monthly limits) etc. but I've never even gotten close.
-
Portugal. The Man – Official Website Is a Google Sheets Document
You can easily turn a spreadsheet into a small CRUD database with HTTP API using Google Apps Script. I've shared an example a few years ago on github: https://github.com/ziolko/spreadapi.
dailygraphics-next
-
Using Google Sheets as the back end/APIs of your app
I was exploring some alternatives for templating and CMSs a few days ago, and stumbled over NPR’s internal toolkit[1] for publishing articles with data, charts, visualizations, etc., and thought it was interesting that they included Google-Sheets-as-a-CMS.
1. https://github.com/nprapps/dailygraphics-next
What are some alternatives?
SQLpage - SQL-only webapp builder, empowering data analysts to build websites and applications quickly
datami - Datami's mirror repo (source on Gitlab)
datasette - An open source multi-tool for exploring and publishing data
imba - 🐤 The friendly full-stack language
pretzelai - The modern replacement for Jupyter Notebooks
Filestash - 🦄 A modern web client for SFTP, S3, FTP, WebDAV, Git, Minio, LDAP, CalDAV, CardDAV, Mysql, Backblaze, ...
rclone - "rsync for cloud storage" - Google Drive, S3, Dropbox, Backblaze B2, One Drive, Swift, Hubic, Wasabi, Google Cloud Storage, Azure Blob, Azure Files, Yandex Files