So 60k per hour is 1k per minute is 16 per second. That is... not that much? Certainly not really blog post material.
Hi! Can you please link me to the minimum requirements for publishing blog posts on the internet? Much appreciated, thanks!
You can get a lot of mileage out of essentially any backend technology running on recent-ish hardware, provided the devs know what they're doing.
> Our backend today is more sophisticated but our philosophy to scaling is simple, avoiding premature optimization.
EDIT: s/of/off/
no worries! In addition to its granular permissions systems which will now let you revoke the secretary's access, Sheets also has a robust backup and restore story built-in! Just click File -> Version history and rollback the offending change. (You can do a live preview of what the effect will be, to confirm you're rolling back the right change.)
The problem Sheets has is that they built a tool that is too good :)
It's a horror show that you can run a major bank on it... but also not, because you can run it pretty well.
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.
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.)
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?
A single dedicated server is not that big of an expense either. The site probably could even run on a single high end server as it is now? I guess I wouldn't have considered using something like Sheets given that. Neat idea though.
Sheets gives us an admin tool, BI tool, Charting, 'ETL', simple schema changes, etc. all-in-one.
Note we actually still use Google Sheets for some things like storing the list of companies. Just today, I needed a quick way to summarize the description of each company into a few words. I installed an add-on for =GPT() formula. Within a few minutes I had done ETL, column addition, made API calls, etc. 0 code.
Plus you'd be able to cache them and use diff+patch for quicker updates when reading.
Though, now that I think about it, things like AirTable do the database thing better than Sheets does WRT being an app backend.
