I haven't started building my back end yet but I need to now.
My needs are the following:
- Database needs to be holding millions of game information (just info that can be stored in a typical db like match_id, win or loss, hero id #, item id # etc...)
- Needs to be able to perform a basic division calculation based on certain parameters, like games that contain a hero id # and this needs to be as fast as possible since I don't want my user to wait like 5 minutes for a db query.
- Once a day needs to call the api and update the db with thousands to millions of new games that were played in the last 24 hours.
Those are the most important aspects of my back end. Based on this, how would you build it?
I was planning on using MySQL but some people I talked to suggested Postgres. Some people also suggested using Heroku for this back end need, what about firebase? I know that there are a lot of options available for me. I think my BIGGEST NEED is speed. I need to have the queries done FAST AS POSSIBLE so that my front end isn't super slow waiting for information.
edit: more information about this.
This is just a simple DB holding basic data about the game of Dota 2. I am getting match information from the steam api and putting that into my db. I then make a simple division calculation based on some parameters like games that have a particular hero in them. Its just basic information not like an actual game. Just ID #s and stuff like that.