Quite important question. Indiehackers might be a good place to ask as well. I got introduced to this open-source tool Hasura. It gives you free service for back-end and handles a lot of issues about scalability. Please DM for more details https://hasura.io/