Live data from Hacker News

Scaling to millions of users with Google Sheets as a back end

levels.fyi

21–30 of 31 posts

Re: Scaling to millions of users with Google Sheets as a back end

#21
post #18

I guess I'm confused, if you're already running Cloudfront, API Gateway, and lambdas, why you'd bother to make API calls out to Sheets rather than just plunking down a simple DynamoDB? Maybe the data access patterns are more complicated than I'm thinking, or just to capture the built in Forms -> Sheets data entry flow?

I thought the same thing. Makes me wonder what the line is between short term thinking and deliberate short cuts to find product fit.

Re: Scaling to millions of users with Google Sheets as a back end

#22
Is Google Sheets designed for this sort of usage? I would have been worried about hitting some undisclosed limits with the service.

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.

Re: Scaling to millions of users with Google Sheets as a back end

#23
post #13
post #8

> Even now, one of our most trafficked services today still has a single node.js instance serving 60K requests per hour (topic for another blog post). So 60k per hour is 1k per minute is 16 per second. That is... not that much? Certainly not really blog post material.

You could serve that with a shell script running off an uncached floppy. EDIT: s/of/off/

I remember seek time on floppies to be most of a second. Maybe that was just CDs..

Re: Scaling to millions of users with Google Sheets as a back end

#24

So when they say they're running without a server it means they are running on Google servers? I thought serverless meant.. no servers

Serverless generally means that you don't have a server / servers in the sense that you don't have some specific dedicated server(s) that you can point to running your code, not that there aren't any servers involved in making your code do its thing.

Re: Scaling to millions of users with Google Sheets as a back end

#26
post #8

> Even now, one of our most trafficked services today still has a single node.js instance serving 60K requests per hour (topic for another blog post). So 60k per hour is 1k per minute is 16 per second. That is... not that much? Certainly not really blog post material.

> 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!

Re: Scaling to millions of users with Google Sheets as a back end

#27
post #26
post #8

> Even now, one of our most trafficked services today still has a single node.js instance serving 60K requests per hour (topic for another blog post). So 60k per hour is 1k per minute is 16 per second. That is... not that much? Certainly not really blog post material.

> 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!

I love your tone.

Re: Scaling to millions of users with Google Sheets as a back end

#28
post #2

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.

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?

Re: Scaling to millions of users with Google Sheets as a back end

#29
post #8

> Even now, one of our most trafficked services today still has a single node.js instance serving 60K requests per hour (topic for another blog post). So 60k per hour is 1k per minute is 16 per second. That is... not that much? Certainly not really blog post material.

I think that's the author's point: the industry tends to act as if complex, scalable architectures are inevitable if you have a useful service or want a viable business.

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.

Re: Scaling to millions of users with Google Sheets as a back end

#30
post #8

> Even now, one of our most trafficked services today still has a single node.js instance serving 60K requests per hour (topic for another blog post). So 60k per hour is 1k per minute is 16 per second. That is... not that much? Certainly not really blog post material.

I think the main success is that they have succeeded in glorifying their work in this dimension. He'll probably tell it for 20 years. "You won't believe it dude but i was just using google sheets. Can you believe it dude?"
Post reply on HN