3
votes
2answers
362 views

Alternatives to storing all my entities in an SQL database

I've been trying to build my entity system based on pure SQL data storage as explained in this post series. The idea is that every entity or component is stored in an SQL table. I created my framework ...
1
vote
1answer
288 views

Tracking player location in realtime 2d mmo

I have read all of the answers here about tracking player locations, but still have some questions. I don't seem to understand how to do this efficiently, and feel that the internet could greatly ...
9
votes
4answers
814 views

Is there a way to make a dynamic world such as a MMORPG horizontally scalable?

Imagine a open-world of 500+ players with data changing as fast as 20 updates/player/second. Last time I worked in a similar MMORPG, it used SQL, so obvioulsy it couldn't query the DB all the time. ...
2
votes
2answers
224 views

Integer vs String for “type” data in data-driven games

I've been developing a few mobile games, in which those games fetch their data from a server-database. I'm used to storing "type" values as an integer identifier, and an enum in the client to ...
2
votes
3answers
271 views

How to store and update data table on client side (iOS MMO)

Currently I'm developing an iOS MMO game with cocos2d-x. The game depends on many data tables (Excel file) given by the designers. These tables contain data like how much gold/crystal will be cost ...
5
votes
1answer
706 views

Strategy/City Builder browser game - technical details

I actually have multiple questions into one. Hopefully someone can hit all of them. I wanted to give a try at a massively multiplayer web based game. Basically, the game would have similarities to ...
2
votes
2answers
2k views

NoSQL (CouchDB) database design for MMORPGs

Are there any pratical examples of database implementation for an MMORPG in CouchDB? Even a detailed thesis? I've looked but found very little on practical examples and not even find any good UML ...
13
votes
4answers
2k views

How should I track players' real-time positions in an MMO?

How do you keep track of the positions of the players in a MMORPG? I read that you can use either a database or you can store the coordinates in files. I tried using a database but it was slow. How ...
-2
votes
1answer
623 views

Database for increased scalability in a mmorpg? [closed]

I am planning a simple MMORPG, but even though it's a small, open source project, I'd like to have the best quality database. Which would be the best database software to use? Examples: SQL - MySQL, ...
6
votes
2answers
635 views

Using Google App Engine to Perform World Updates vs an Authoritative Server

I am considering different game server architectures that use GAE. The types of games I am considering are turn-based where the world status would need to be updated about once per minute. I am ...
49
votes
10answers
11k views

What kind of databases are usually used in an MMORPG? [closed]

Do people write their own DB for some reason?