My friend and I are programming a game that needs a database. It will be a unity game mostly text based menus with 2D and some 3D cutscenes and such. When players fight and get experience, buy items from a shop, sell items, etc it needs a database to update.
We are planning on it being a downloadable game for PC that they launch and play. But which server asset is best to have a remote database to connect to, to update their accounts as they play?
Thanks
“24 hour bump”
This is a pretty big question with lots of context required for a good answer. You could use a simple REST style web-app interface to a DB backend, in which case you could use almost any web host which offers PHP & MySQL. You could run your own instance of the Parse server @ gomix . You could use one of the many game backend as a services which are available.
Many of the questions i’d have would involve how many players, what kind of game, how ofter is the DB being hit, how secure does it all have to be, etc etc.
Good luck!
I would estimate closer to 500 - 600 active players, the game is currently PHP text based browser based, but I want to convert it to Unity and make it more graphical, animation, etc. The DB would be hit often, such as battle it can update after the battle ends, but like buying an item it would need to update instantly. Nothing is perfectly secure, but it needs to be secure enough where players cannot edit their own stats/account or others or see any details of donations and things. It’ll be free but will have an item mall. Thanks
I’m not really able to help with specifics, but if you already have it running in-browser, and you “just” want Unity as a front end, i would not change anything - just make https calls to your existing backend.
I didn’t know that was possible. I am currently using a MYSQL database, so instead of browser based, I can have downloadable game that is a program and it connects over the internet to the database to update?
I’m suggesting you use Unity’s WWW class to make http/https calls to some php code, ideally the same you are already using, and just use unity as the “front end” rather then the HTML one you have currently.
Ok thank you.