spreadapi
avalanche-report
spreadapi | avalanche-report | |
---|---|---|
4 | 2 | |
80 | 20 | |
- | - | |
3.6 | 9.3 | |
6 days ago | 8 days ago | |
JavaScript | Rust | |
GNU General Public License v3.0 or later | GNU Affero General Public License v3.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.
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.
avalanche-report
-
Using Google Sheets as the back end/APIs of your app
I did something very similar with https://github.com/kellpossible/avalanche-report/ we started with Google Sheets because it allowed us to quickly iterate with data entry workflow. When paired with a server this also allowed us to generate custom charts/diagrams via the IMAGE function with a crafted URL query. Reads are cached in a local sqlite database.
We're in the process of migrating away from Google Sheets now as it's a little painful to set up and it's impossible to completely prevent users from editing the wrong fields in our use case. But it has served very well so far and would highly recommend this approach to start with for anyone!
-
Axum + Sqlite + minijinja + htmx winning website combo?
My most recent project is here https://github.com/kellpossible/avalanche-report so probably it will end up looking somewhat similar
What are some alternatives?
SQLpage - SQL-only webapp builder, empowering data analysts to build websites and applications quickly
smithy-rs - Code generation for the AWS SDK for Rust, as well as server and generic smithy client generation.
datasette - An open source multi-tool for exploring and publishing data
svelte-axum-project - Starting project template for Rust Axum backend and Svelte frontend
imba - 🐤 The friendly full-stack language
pretzelai - Open-source, browser-local data exploration using DuckDB-Wasm and PRQL
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