Detailed usage of Firestore Cloud

[David R.]

Hello everyone.

My boss told me last week to check out the Google Firebase, so I did. Till yesterday I was working on adapting a MySQL WebApp, that generates multiple data (just string, pretty light) every 5 minutes, to Firestore Cloud, which I don't know if it's a great cloud-base alternative for this kind of WebApp. So, I exceeded the free quota 0.05 million Cloud Firestore Read Operations limit. I want to know, when, what data or some other details about when it reached that limit. Is it possible?

I mean, I can't even check the collections in the Firebase Console, because there was an 'Error loading collections'.


Thanks!

[Jordan (Cloud Platform Support)]

This question would be better suited for Firebase Support. The Firestore is a non-relational database, where as MySQL is relational. So if you are looking for a fast object-store that uses APIs instead of SQL to interact with the database, Firestore is definitely a great choice. 

You can find information about the quotas and limits in their documentation. You can also find your current usage in the Cloud Console quotas page. Note that you must enable billing to use more than the free quotas. 

[David R.]

Thanks for the suggestion Jordan, next time I'll post my doubts there.

I read some of the Firestore documentation and managed to modify a lot of the logic of the code, now it takes way way less read operations. I mean, now it took like 1 percent in 3:30 hours. It's beautiful lol. I've learned that subcollections are great.

[David R.]

Well, I finally realize neither Firestore nor Realtime Database are options to replace MySQL. I mean, the WebApp generates thousands of points in a chart. That's, or really slow on Realtime Database or will cost a lot of money using Firestore Cloud.

On Wednesday, April 25, 2018 at 3:33:28 PM UTC-3, Jordan (Cloud Platform Support) wrote: