Hello CF community,
I am building my first serverless app. Traditionally I am used to SQL/NoSQL databases, typically a MEAN stack.
I know there is a(n unsupported) repo that supports using workers and SQL but my concern with that would be performance. I would really like to use workers to run a JS/TS application but the data storage is a deal breaker if KV is not an ideal solution for some of the functions of the application. Azure has support for DB operations with their serverless solutions but I feel like using a separate DB host and then workers scripts will cause too much latency and way higher execution times.
Some of the data my application would need to store is
-User information (name, email, passwords)
-Purchases - an array of products that the user account owns
-Gameplay data - statistics from matches of games
-Content information (relations of paths to the static file storage, ex. profile pictures)
-Historic information (basic logging of some activities)
I know that purchases, gameplay data, and content information are good use cases, but I don’t think user information will be ideal due to the ~30-60 second propagation time. Registering a new account or changing a password should be instant.
Does anybody have experience building a serverless app with similar use cases? I’m interested to see how these can be accomplished using only KV or a combination of a traditional DB.
And if any staff is here - are there any plans on implementing a full DB solution for workers at some point in the future? It would make it way less tempting to run the whole thing on Azure/AWS.