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!