61–70 of 171 posts
Earlier quoted context omitted.
client = (APIcall) => redis.get(sha1(APIcall)) || { res = api(APIcall); redis.set(sha1(APIcall),res) return res } Not that hard. Like 10 lines of code to get a decentish cache going.
Assuming you have Redis
Earlier quoted context omitted.
Redis uses like 5mb of baseline RAM and can be deployed in a few lines of docker-compose.
I'm not allowed to do that where I work. License is a no-no, can't run jobs without red tape, and there's no Docker either.
Pricing is unclear to me
My next user script project idea would require something like this. It's for my own use, but I have to fill out grade sheets using an incredibly painful web UI. The data would be far more easily entered into a spreadsheet. (That's exactly what they used to use, but in order to make things "easier" the school implemented a horrific parody of an ultra basic CRUD web app...) So I want to make a user script that reads fr…
Earlier quoted context omitted.
I'm not allowed to do that where I work. License is a no-no, can't run jobs without red tape, and there's no Docker either.
Ok? I'm surprised your work lets you build a whole product ontop of google sheets, then. Also, why did you delete your original comment on not having a server?
They're internal tools, but big ones. And I'm surprised too. You won't hit too much resistance doing things the well-supported ways, but for some reason there's no well-supported way to run a cache.
so not just google sheets as the backend, google sheets as your personal backend for you instance of the app.
I'd like to plug PocketBase [0] for a similar use case. Last week I was looking for a place to store random data with API access, and was looking at making a Google Sheets backend, but PocketBase was easy and didn't have a 60 rpm quota [1]. Deploying to a cheap VPS was very easy with CapRover. [0] https://pocketbase.io/ [1] https://developers.google.com/sheets/api/limits
I was looking at pocketbase but I didn't really understand how to use it. I know sqlite and am good at SQL, but couldn't work out how to use it.
Great concept. Congrats on launching. Do you have a sense for how much usage Google will allow on a given sheet or user? I.e. will Google shut down the API after a certain usage level? (Side-note, your SSL cert seems to be having trouble, i.e. www.zerosheets.com is correctly encrypted, zerosheets.com is not.)
Hello!! Google limits for me are: 300 Read requests per minute 300 Write request per minute Since Ive just launched it, that number is far far away from being reach. (If it happens, the number can be increased). Regarding the SSL cert, some other users pointed the problem but I can`t replicated. Tried with many different browsers. Im not sure about whats happening, it`s always working for me but I will keep digging.…