Software designed to store massive amounts of data in a queryable form. The data is typically organized to model relevant aspects in a way that supports processes requiring this information.

learn more… | top users | synonyms (1)

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 ...
0
votes
1answer
221 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
4answers
450 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 ...
3
votes
2answers
475 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
228 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 ...
-2
votes
1answer
1k 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
1k 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 ...
1
vote
1answer
586 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 ...
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 ...
4
votes
2answers
703 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
514 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
585 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, ...
3
votes
2answers
503 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
402 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 ...
8
votes
4answers
2k 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 ...
5
votes
4answers
987 views

Database structure for a trading cards video game (TCG)

Just started and after pondering with registered users' table everything came to a halt. So far I've got: +----------------------+ | tblUsers | +----------------------+ | ...
2
votes
1answer
577 views

Tools for creating an item database

I'm working on a project for which I will need to create a large item database, with plenty of different types of items which will all have different data structures and attributes. I'm hoping to ...
3
votes
1answer
368 views

Component System - Editor Data Management [closed]

I'm trying to construct an editor in C# that exposes game components to IronPython, so it may create the game object definitions to be used within the editor: C# Exposes the components to the python ...
3
votes
2answers
185 views

'Unblock' / 'Yellow Out' game questions

I would very much like to build a game that is known as 'Unblock' or 'Yellow Out'. It is a puzzle game in which the task is to move a car out of a parking space by moving other cars in certain ...
4
votes
2answers
1k views

RPG Monster-Area, Spawn, Loot table Design

I currently struggle with creating the database structure for my RPG. I got so far: tables: area (id) monster (id, area.id, monster.id, hp, attack, defense, name) item (id, some other values) loot ...
3
votes
3answers
1k views

Is a SQLite Database Suitable to Store the Building Blocks for Dynamic Content?

I am trying to make my own game for fun, it is basically a 2d side scrolling shooter, with dynamically generated enemies, levels, loot, and some other things. Currently I have dozens of XML files that ...
3
votes
3answers
376 views

Manager game questions

(Sorry about the bad title, it's the best I could come up with) I've been planning a gladiator manager game for a while now. Something similar to Blood Bowl (or Football Manager, only with fighting ...
5
votes
1answer
671 views

MySQL - Storing Character Inventory

What is the best way of storing the character's inventory (consisting of each item having a value for type and quantity). The only methods I can think of is to use the "text" type of field then parse ...
0
votes
3answers
213 views

Using an engine to create content with PHP - but how should it happen?

I need to create an engine that will allow me to add content to a website. The website is a browser-based game. This is a verbose engine that should be able to handle many different aspects of the ...
1
vote
3answers
951 views

MySql Database design for Facebook game

I'm at the planning stages for a facebook game, it will be similar to farmville, but will feature parks. I've been a Flash game dev for many years but all this database stuff is new to me so I'm ...
11
votes
2answers
4k views

What is Minecraft's database? [closed]

I was wondering, what kind of database does Minecraft use? Is it a relational database, maybe something common like MySQL? Do we even know what he's using? And maybe even a better question, SHOULD ...
-1
votes
2answers
1k views

XNA with SQLite

Does anyone have experience using SQLite with XNA? Or using any other DB with XNA?
2
votes
4answers
778 views

Creating a database with special items, like in Diablo

I am in the middle of creating a browser game. I need to add 'special items' like in Diablo, but simpler. Item names are fixed (e.g. 'ring of power'), so only their attributes change. In my game ...
-3
votes
2answers
112 views

Are there companies that can store the stream of each user event? [closed]

I want a company that can store in a database of it's own the stream of clicks each user does (my game is programmed in action script), of course I will define what data and when to store it. Bear in ...
9
votes
5answers
2k views

Distributed C++ game server which use database

My C++ turn-based game server (which uses database) does not stand against current average amount of clients (players), so I want to expand it to multiple (more then one) amount of computers and ...
3
votes
3answers
523 views

How to implment the database for event conditions and item bonuses for a browser based game

I am currently creating a browser based game, and was wondering what was the standard approach in making diverse conditions and status bonuses database wise. Currently considering two cases. Event ...
3
votes
3answers
1k views

Facebook Game database design

I'm currently develop a facebook mafia like PHP game(of course, a light weight version), here is a simplify database(MySQL) of the game id-a <int3> <for index> uid ...
13
votes
4answers
3k views

How to choose how to store data?

Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime. - Chinese Proverb I could ask what kind of data storage I should use for my actual project, ...
6
votes
2answers
612 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 ...
16
votes
5answers
3k views

noSQL - Is it a valid option for web based game? [closed]

Out of an opportunity and boredom, a friend and I decided to make a web based game. This is the first 'game' I will be making, since usually I program web apps in django. I've opted to use the same ...
10
votes
11answers
1k views

How to model multiple “uses” (e.g. weapon) for usable-inventory/object/items (e.g. katana) within a relational database

So I'm working on expanding the uses of items over at www.ninjawars.net, and I'm not exactly sure how to represent them flexibly in the relational database that we use. I may be barking up the wrong ...
18
votes
6answers
3k views

Would it be better to use XML/JSON/Text or a database to store game content?

I'm considering how to implement a component-based game, as that seems to be the hot thing and I like the idea of such a flexible design. One of the features of such a design is that adding new ...
7
votes
5answers
624 views

What techniques enable web based games to update player's resources frequently?

Long ago there was this web-based game called Utopia (and I'm sure it is still around), turns are by per hour. You only get new gold/lumber or what-not every hour. Some newer web based games have ...
18
votes
6answers
723 views

Tweaking and Settings - Runtime variable modification and persistence

Most companies have an editor, or a variable control system for tweaking stuff in games, but are there any middleware solutions to this problem? I've written two such systems in the past myself, and ...
43
votes
10answers
10k views

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

Do people write their own DB for some reason?