Hi,
I'm designing a turn-based multiplayer game that uses items (such as potions, etc). I want a player to log in with his details and store info into a database. This is the first project I've had to work with databases, so I'm new to them in general
The question I have is the following: What's the most efficient way of storing many objects in a database? The way I'm thinking is have each item as an object in the database, however I want to separate the objects into 2 categories: some objects will be usable in fights (such as potions) but some will only be available outside of them (quest items). The server would check to see if the items exists in the database and then send the info to the client.
Is it possible to store an object in a database with properties (such as: name(potion), quantity(x), usableInFights(bool))? My game has maaaaany items, how will this affect performance? Will storing an ID number instead of a string for the name offer any advantages?