Hi,
I want to build an app for a company that has around 10,000 transactions pre week.
It's a subscription based module, with 5,000 subscribers, so every week a row is added for each subscriber with a due/bill and another row with an income when the payment appears on the bank statements.
Usually I use google sheets as the data source. I know google has a limit of 10 million cells. This means that once a year for example I will need to combine all transactions for each subscriber from the previous year into a single row and save the old transactions on a separate database.
This isn't end of the world, but I want to know how would you guys handle this? Would you start with a different database, like Bigquery etc? Or perhaps I should look for an alternative to AppSheet?
LinkedIn
Twitter
