I have been trying out Defold for a period of time and had successfully developed a simple multiplayer game using luasocket. But now, I am stuck with the database structure as I have no experience in creating a database.
As the game will require user’s profile and I suppose this will be stored at a database and the game will then fetch the data from that database. I will be creating a website for user to create their profile.
For now, my idea is to use a server for my game server and another for database. So in this case, what should be my approach?
P.S. I have some experience in .net application and MSSQL (but limited to managing not creating one).
Greatly appreciate the attention to my question and hope you guys will enlighten me.
As Sven suggested, I would recommend Playfab or Gamesparks to help you out. Both are “Backend-As-A-Service” and very easy to use and script.
We decided to go with Gamesparks after deep investigation but that was just because of a few features that was stronger on that side. Playfab has it’s great advantages as well.
Thanks for the attention, I have been trying to read up all the solution mentioned and is very appreciated it.
For GameSpark, I think it’s great but it’s kind of overpowered for my simple game. I will continue to research to see if is feasible to integrate.
For Colyseus, as @britzl mentioned, I still need to handle the database configuration by myself, thus I will still have some difficulties.
For PlayFab, is seems simple and easy to integrate, but I am unsure if I should go with this. In fact, even with GameSpark, the reason is because I already created the network layer for my game (which of course won’t be as efficient as whatever provided) and I merely want a channel for me to grab a stored data from a server which I preferred to be from a database which I think will be located separately from the game server.
All the solutions mentioned seems to take over whatever I implemented using defnet, thus I am unsure if I should go ahead with GameSpark or PlayFab. I am still in midst of understanding the implementation and integration, so please correct me if I am wrong.
Gamesparks and PlayFab can be combined with your own backend. You can use PlayFab for user authentication and storing user specific data and then your own backend for the game specific packets.
Yes, that’s what I kind of concluded as well. I will first try out PlayFab first and see how it’s goes. I still have question about the approach in creating the lobby (which I will post as a new question). I guess I am still far from completion. Will update my progress with database as it’s goes. Thanks!