Firestore is quite cheap when we compare it to others because you will be in free tier up to:
- Up to 50K read/day
- Up to 20K write/day
- Up to 20K delete/day
When you compare this to Wix’s limits it’s crazy. And let’s say we have 10GiB data in collections which means millions of documents. Maybe even billion depends on the document size.
You will pay 1-2$/m. Check here.
BUT BUT BUT if you use wix-data APIs these limits are not important because you will be also limited to Wix’s data request limits as I know. And Wix has very low limits with new update and overall monthly limit which you don’t have in Firestore. Check.
About the performance I think there is no big difference I didn’t test it enough to compare with local collections. But I can say it’s fast enough. Since we can change Cloud Run performance settings like CPU and RAM we can even have higher performance when we run heavy queries.
And here is the Cloud Run pricing which you will probably again stay in the free tier (all depends on your Cloud Run settings and of course usage).
When you change CPU to 1 and ram to 512mb which is default values. It will be even free. I selected 4CPU and 8GB RAM probably you will never need that much for a external DB connection service. But even with that let’s say we made 1M requests to the DB and each request run 1.5s you will pay 4.87$/m for the Cloud Run. If you lower the CPU and RAM it will be cheaper or even free. (Play with it in calculator).