Tagged Questions
The databases tag has no wiki summary.
1
vote
2answers
145 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 ...
0
votes
1answer
50 views
Need Feedback for PHP & MySQL Saving Game Progress
My team is planning to create a simulation game using Javascript, CodeIgniter and MySQL for the backend.
It will be mostly click based, ie: There will be buttons for activities like Eat, Play, Study, ...
0
votes
2answers
83 views
Is there an in memory data store that is feasible for real time, non-networked games?
I would like to know if anyone has recommendations or experience with using an in memory data store for a real time, non-networked game. This is not necessarily for loading levels or saving data, but ...
2
votes
2answers
52 views
How should one design an analytics system for an online multiplayer game?
For my simple MMO, the MySQL database stores things like user experience, user level, user coins, health points, etc.
We wanna have an analytics system that can show me trends through daily ...
4
votes
1answer
118 views
Using heavyweight ORM implementation for light based games
I'm just about to engulf myself in an MVC-based/Component architecture in C#, using MySQL's connector/Net for the data storage, and probably some NHibernate/FluentNHibernate Object-relational-mapping ...
0
votes
1answer
164 views
Browser Game Database structure
users
id
username
password
email
userlevel
characters
id
userid
level
strength
exp
max_exp
map
id
x
y
This is what I have so far. I want to be able to implement and put different NPC's on my map ...
1
vote
3answers
236 views
MySQL Recursive Query (kind of) help to determine tech tree prerequisites
I'm trying to figure out how to do what I can only call a recursive query (my knowledge of MySQL is extremely limited). The game I'm designing has a tech tree with items to research that will grant ...
0
votes
1answer
182 views
Is my technique for client-side character movement in an MMORPG reasonable?
I started an MMORPG game, and I can already make a character move around the map and see other characters. But I have doubts about my architecture.
I have a loop which, every x milliseconds, request ...
9
votes
4answers
646 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 ...
4
votes
2answers
231 views
How do I store Items in MySQL?
I'm working to my first game containing items (built a small one before, strategy type but not very complicated). I was thinking something like this for the db design since it will be almost the same ...
0
votes
1answer
132 views
SQl, noSQL, and Doctrine with Symfony 2.0
I've had the idea of creating a webgame for a while now, and as it becomes more and more accurate i started playing around with Symfony 2.0.
First question :
it seems that it is recommanded to use ...
-3
votes
1answer
210 views
Database for increased scalability in a mmorpg?
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, ...
2
votes
2answers
250 views
Crafting recipes: storage and quering
Consider following situation. In a game you can perform crafting: i.e. create new items from existing ones (like in Minecraft). I have following game entities (simplified):
item: atomic part;
...
0
votes
1answer
140 views
database design for a game like “Empires and Alies” in facebook
recently im trying to create a isometric game for facebook pretty much like Empires and Allies in facebook , i have used as3isolib to create the game , the user interactions are almost ready , but im ...
7
votes
5answers
671 views
Which Database (RDBMS vs NoSQL vs BOTH) to use for a Realtime Multiplayer Game?
I'm working on a realtime multiplayer game that will require a database (for features such as player profiles, friends, unlocks, news, etc.) This is a standard PC game (not browser-based) and will use ...
