Does anyone have any good realtime IaaS / PaaS / SaaS / FaaS recommendations?
I've got a live native mobile app which is currently on a Firebase/Firestore backend. However, as some of you may know, Firebase's ability to accommodate complex queries can be quite limited. This means that as we scale our functionality upwards, we're facing more problems, and so we're now looking to move. There seems to be a lot of options for cloud hosting, infrastructure, etc.
I've tried my best to do my own research, looking through forums, youtube, purchasing udemy courses, and also playing around with some services such as AWS and Heroku. But with so many options, many being microservices, I'm finding it extremely easy to get bogged down in what is the right choice, or how to connect the right services together to make a realtime API that is cost-efficient, low-latency, and connects to my native iOS/Android Clients.
As I imagine I'm not the only developer with shockingly non-existent skills in devOps, I thought this would make for a more human form of research and a great/informative post for others looking to build out their own custom, realtime, backend architecture. I'll add specifics of my own efforts in a comment below.
Any tips?