Search Unity

  1. We are migrating the Unity Forums to Unity Discussions. On July 12, the Unity Forums will become read-only.

    Please, do not make any changes to your username or email addresses at id.unity.com during this transition time.

    It's still possible to reply to existing private message conversations during the migration, but any new replies you post will be missing after the main migration is complete. We'll do our best to migrate these messages in a follow-up step.

    On July 15, Unity Discussions will become read-only until July 18, when the new design and the migrated forum contents will go live.


    Read our full announcement for more information and let us know if you have any questions.

Question Looking for a very simple server hosted database

Discussion in 'Multiplayer' started by RemDust, Jan 22, 2023.

  1. RemDust

    RemDust

    Joined:
    Aug 28, 2015
    Posts:
    438
    Hello gang !

    I'm totally new to mySQL and stuff, and for the first time, I would need to store/fetch character statistics in a very simple (but secured) database, looking like this :
    ID <-> ID.json

    I would consider a buy if there is a very user friendly asset in the assetstore that you want to recommend, or I could get my hands dirty if you want to help me going down this road !

    Thanks a lot !
     
  2. tleylan

    tleylan

    Joined:
    Jun 17, 2020
    Posts:
    698
    Setting up a simple database is easy but if you have never used SQL before you should watch at least a few videos to learn the syntax. I use SQLite as it is free, lightweight, flexible and suits my needs. I could use SQL Server which I have available but it is overkill for my needs.

    You will need a server of some sort with public access that you can host the SQLite database in. If you write a simple API you can use access the database from a webpage or PC app and also from your Unity game.
     
    RemDust likes this.
  3. CodeSmile

    CodeSmile

    Joined:
    Apr 10, 2014
    Posts:
    7,263
    What is a „secured database“ supposed to be? What exactly needs to be secure? And why?
     
    RemDust likes this.
  4. RemDust

    RemDust

    Joined:
    Aug 28, 2015
    Posts:
    438
    Thanks for passing by !

    So, in my game, a "player" has statistics (classic level, health, strength etc ).
    But a "player" won't be permanently linked to a USER -> characters/players can be traded, gifted etc.

    So I need to have them referenced by an ID, and not by the Owner.

    That's the reason why I need to have them all in a table with their IDs <-> Stats.
    -> Those are the data that I need to secure (nobody wants a game where someone can cheat and set values/data to a "player" stats, right ?

    Hope it's clearer now :)