20
votes
How does mmorpg store data?
1000 player may or may not be a problem. It depends on how often you need to update the database. However there is a simple solution: put the database on its own server.
I had a peek at how the ...
- 28.3k
9
votes
How does mmorpg store data?
Both approaches are used with MMORPGs. Keeping everything in memory and periodically check pointing it to disk seems to be the most popular option, at least for older games. It has the advantage of ...
- 430
2
votes
Database Design of loot tables
I implemented a custom loot system in a Neverwinter Nights server, which ran into several of the same concerns as you have. I also wanted the loot table to be modifiable by non-technical game-masters -...
- 645
1
vote
Godot 4 Static Storage Handling
TLDR: Use OOP and let Godot handle data storage. You focus on your game.
Everything I've read since Godot 4 was released suggests that JSON serialization is no longer the way to go, especially for ...
1
vote
Accepted
How would you implement a map system like WoW?
I have some code/design review feedback. Your design would work for a single-player game (or even a small-scale multiplayer one with ~64 concurrent players), but it has a few problems that would start ...
- 645
1
vote
proper items db design mysql
Example data model
The idea is, you have a generic item with an item type. For each item type you define an extra table, that gives the attributes to the item you want (mainly weapons, armor). The ...
- 5,099
1
vote
One sqlite db per savegame or one big sqlite db for all the savegames?
Hi and welcome to GameDev. I haven't used SQLite in a couple of years (last time was when I also developed an android game), but I've been using MySQL on the back-end in all of my games for years and ...
- 349
1
vote
MMO Chat system methods
Databases are supposed to be used for persisting long-lived data, not for ephemeral data. Using a database for storing short-lived chat messages just to delete them seconds later is quite an anti-...
- 123k
1
vote
How to Structure my Database for a HTML turn-based strategy game?
It really doesn't matter which database you use for this. You can use pretty much any.
The sql-by-the-book solution for storing the current state of all games would be to create a table with these ...
- 123k
Only top scored, non community-wiki answers of a minimum length are eligible