Hacker News Reader

Use sqlite and store it in one file. Or use s3.

If you have 5 million users, you should be using a real system

If you're managing this in a free Google Drive account, shame on you (seriously)

These are paid, large plans. 5 million files on a 20tb plan seems unreasonable.

Why would it seem unreasonable?

That's 4MB/file, which is not exactly large. That's also a small use case. 20TB is 4 people on Google Workspace. Our company is 40 people, so our limit is 200TB (which we pay for), but 5 million files.

The issue is common to all account types, ie also affects paid accounts.

Paid accounts are limited too.

https://issuetracker.google.com/issues/268606830?pli=1

> What it should say is that no matter how much you pay you have to adhere to the 5m file limit.

This is not about the free tier.

We pay $18/user/month for Google Workspace and hit this limit.

But a business isn't "anyone".

This is about a single user. No user should be storing separate files for 5M customers in their individual Google Drive!

That's what databases and storage solutions like S3 are for. Use the right tool for the job.