- Forum
- General C++ Programming
- Looking for uses for databases
Looking for uses for databases
I wanted to learn networking so I decided to write a simple multiplayer game. For database stuff I settled on using SQLite. After some research the only viable reason I can think of to using is when players first log in. Other than that I can't think of any further uses.
As for player data, I'm following what I heard guildwars use. They use a binary file containing player info. Makes sense I guess since opening a file is as simple as using a filepath.
So for a game like guildwars, what else would they use DB stuff for?
As for player data, I'm following what I heard guildwars use. They use a binary file containing player info. Makes sense I guess since opening a file is as simple as using a filepath.
So for a game like guildwars, what else would they use DB stuff for?
You can store in a database pretty much everything that varies from player to player.
For example, in a game a player can name his character, go up in level, and kill other players, we could store in the database, aside from username and password, the name of his characters, his level and experience and number of kills and death.
You can also store binary files in databases as BLOBs, these can be used to represent the player's items, or something like that.
For example, in a game a player can name his character, go up in level, and kill other players, we could store in the database, aside from username and password, the name of his characters, his level and experience and number of kills and death.
You can also store binary files in databases as BLOBs, these can be used to represent the player's items, or something like that.
closed account (S6k9GNh0)
This one is something I contemplated awhile back. I thought to myself. Each player needs an ID other than their name so we can find them with ease. And then I thought, maybe each player wants a profile? You can place profile information into a database and have other people look at it. Then I thought, "Well, character information shouldn't be held client side of course and it must be saved over time" which is easily fixable with a database (secured).
Binary files are fine but in a sense, that's a database. You have a file that correlates to each player (I think) and they use that to restore player information. The definition of database is huge and can be many things.
Binary files are fine but in a sense, that's a database. You have a file that correlates to each player (I think) and they use that to restore player information. The definition of database is huge and can be many things.
Beibin
I mean specifically as in SQL sort of DB - where they only allow the most basic types of be represented in their tables. Sure a folder with a bunch of files in it is a technically a DB, but I mean specifically, tables, rows, columns as a means of storing data. For now.
Let me know if I'm wrong...As I'm reading more about it, DB is primarily only for fetching data from and storing it in the server cache to be used in the game.
Occasionally it should be written to if something changes.
Basically, keep calls to the DB out of the main loop and only for special one-shot cases, such as logging in...
Why don't mmorpgs store their player inventory data in SQL? I have a hard time believing that opening a file and parsing, converting it is faster than what's been written in SQL.
I mean specifically as in SQL sort of DB - where they only allow the most basic types of be represented in their tables. Sure a folder with a bunch of files in it is a technically a DB, but I mean specifically, tables, rows, columns as a means of storing data. For now.
Let me know if I'm wrong...As I'm reading more about it, DB is primarily only for fetching data from and storing it in the server cache to be used in the game.
Occasionally it should be written to if something changes.
Basically, keep calls to the DB out of the main loop and only for special one-shot cases, such as logging in...
Why don't mmorpgs store their player inventory data in SQL? I have a hard time believing that opening a file and parsing, converting it is faster than what's been written in SQL.
| Why don't mmorpgs store their player inventory data in SQL? I have a hard time believing that opening a file and parsing, converting it is faster than what's been written in SQL. |
Most, if not all MMOs make heavy use of databases for storing game data.
Topic archived. No new replies allowed.