News for hackers. Stuff that matters.
Re:Scaling to millions of users with Google Sheets as a back... by Varqu on Thursday March 02, 2023 @05:02PM (#35002701)
As a side note: it's nearly impossible to upgrade to a higher Sheets API rate limit.

We tried it all: options in Cloud Console, speaking with support, talking to sales reps. Google simply doesn't want that money and doesn't care if you are hitting limits and want to upgrade.

Re:Scaling to millions of users with Google Sheets as a back... by cldellow on Thursday March 02, 2023 @05:09PM (#35002770)
I run a Google Sheets-based SaaS. The default limit is 60 write req/user/min and 60 read req/user/min.

In my experience, that's plenty!

Especially so since Sheets has a very advanced API relative to, say, Airtable. For example, you can do atomic updates of multiple sheets in a single request. A single request can contain like 100MB of data. (It'll be very slow, and at this point, a person should question their life choices, but it'll work.)

Re:Scaling to millions of users with Google Sheets as a back... by Varqu on Thursday March 02, 2023 @05:12PM (#35002813)
We hit 60 read/write req/user/min pretty fast and yes, theoretically you can scale with the user numbers in GCP and by rotating them.
Re:Scaling to millions of users with Google Sheets as a back... by QuercusMax on Thursday March 02, 2023 @05:04PM (#35002724)
Probably because the sheets team doesn't want to be in the database business and there are lots of other Google products that let you use them as a database on purpose?
Re:Scaling to millions of users with Google Sheets as a back... by crazygringo on Thursday March 02, 2023 @06:07PM (#35003374)
> Google simply doesn't want that money

Is it simply that Sheets can't support a higher rate? At least not the way they currently provision resources across servers?

Since Sheets isn't really designed for high-rate API calls (it's a per-user app, not a database backend), I wouldn't be surprised if it was architected in a way that imposes these limits. Just think of how it's got to add to and consolidate the version history alone each time you modify a Sheet.

Re:Scaling to millions of users with Google Sheets as a back... by duxup on Thursday March 02, 2023 @10:10PM (#35005334)
There’s something to be said for knowing a product’s limitations and sticking to it.

It might seem absurd there is no option to pay a bunch of money for “more”, but we also don’t really know what guaranteeing that more work cost. Could be quite a bit of the sheets infrastructure is built expecting those limitations?