Cloud Firestore

What do you think is/are the best DB(s) for my use case? Do you have any other ideas like Cloud Firestore or MongoDB?

Here is the project: https://1drv.ms/w/s!Aryf65kIpgMPp_VQzKCJWCUzU8esTA

I'm wondering if any Cloud Firestore users might be open to sharing some input and challenges encountered when trying to create a low-cost, low-latency data pipeline to their Analytics warehouse (e.g. Google BigQuery, Snowflake, etc...)

I'm working with a platform by the name of Estuary.dev, an ETL/ELT and we are conducting some research on the pain points here to see if there are drawbacks of the Firestore->BQ extension and/or if users are seeking easy ways for getting nosql->fine-grained tabular data

Please feel free to drop some knowledge/wish list stuff on me for a better pipeline here!

Good day, everyone!

We recently got the request to add a feature to our systems: Forms should be saved to be continued later given the following cases:

If the connection to the server is lost, if the user closes their browser, if the user changes networks, if the user didn't finish the form and decides to take a week off and a mix of them all.

One of the best solutions we've thought so far is to save the data in the forms in a remote database every so minutes directly from the client.

A document-oriented database seems the best bet, but which database to use is the question. Since we already use Google Cloud Platform, Cloud Firestore is a "safe" option right now, but we are looking at every option we can find. The "caveat" of our use case is that we need more writes than reads, but writes are usually more expensive, and our biggest constraint is budget.

That's why I am seeking advice. What other options do we have?

In case you're wondering, we seek to save the forms bypassing the backend and our own system resources entirely, so a dedicated, remote database or Local Storage are our best options, but Local Storage is a bit controversial choice within the team, so we will explore that options later on.

Any advice or experience in this matter is highly appreciated!

I am having a mid size React Native project, I work with SQL databases but I am thinking about moving to NoSQL, I tried to learn NoSQL databases like Cloud Firestore but I faced issues at building the relation between models, also I noticed that the data is being duplicated in many places, should I stick with SQL databases like PostgreSQL or try again with Firebase.

I am considering choosing Cloud Firestore Database As Primary Database for my app that needs huge storage. I'm still a bit confused about my choice because it's not used by big companies as a database and it's not too scalable. But for the free tier and pay as you go, it seems like a good budget deal. Please recommend some other databases required for my situation: Low Cost, Highly Scalable, Easy To Manage, Good Storage.

Could you pls help me to understand whether Cloud Firestore or MongoDB is better for rewards program