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)

1
vote
1answer
248 views

How can I keep track of a battle log on a web game?

Recently I started working on a Web turn-based PvP RPG game. Now I'm working on the battle system but I encountered some issues: How can I keep track of everything that happens in the battle? It ...
-1
votes
1answer
178 views

How to define 648 units, with 22 different values in Java

A friend and I are currently looking at developing a game, with similarities to a certain trademarked francise. To define the units in the game, we've created an abstract class which denotes the 44 ...
-1
votes
1answer
319 views

multiplayer tic-tac toe checking if other player is in game or not

I am developing a multiplayer tic tac toe game. The issue I'm facing at the moment is knowing whether the other player is in the game or not. Each player is running their own session, and should a ...
2
votes
2answers
507 views

jMonkey Quest Database

I am building a game in jMonkey (Java) and I have so far only used default quest text. But now I need to start populating a lot of quests with text. My design requires A LOT of quests texts. What is ...
1
vote
2answers
143 views

Implementing an existing (but out of print) game electronically

One of my favorite games is the old Avalon Hill class, PanzerBlitz. I would like to implement it electronically, and have a couple questions related to that: Would I be in legal trouble if I do ...
-4
votes
1answer
225 views

Database structure for level packs, levels and level information

I have a game which shall consist of several level packs (and also be extended by additional level packs). Each level pack should contain some levels. Each level will have its own level information. ...
1
vote
1answer
425 views

SQL Database using Adobe Air

How do you create an SQL database (I believe it's tinySQL/SQLite) using Adobe Air? I have searched around, and all sites give code, and then explains to wrap it within an xml document, for example ...
1
vote
2answers
174 views

Storing Player Location/Data in an Online Game

I know this question has been asked and answered in some threads, but I'd like a more beginner dumbed down explanation. So player information, specifically direction and position, need to be updated ...
2
votes
1answer
3k views

How do I implement a score database in Android?

I making a 2D game for Android using OpenGL-ES technology. It is a space shooting game where the player shoots enemy ships. I want to keep a track of score for the amount of enemy ships destroyed ...
5
votes
1answer
720 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 ...
0
votes
2answers
2k views

(XNA) What's a Good Database Program for a Turn-Based RPG?

I'll begin by saying that I feel my level of expertise matters here, and so I have about a year worth of experience as a programmer in the C# language and most of the .NET framework as a whole, but ...
1
vote
1answer
454 views

Implementing an online database

I'd like to get into online games programming. I thought that as a start i'd be a good idea to implement an online database that would store the progress and score for a game i have made, i'll ...
1
vote
3answers
930 views

How do RPG store and retrieve maps?

I'm making a very basic online RPG (2d, and instead sprites I use characters, like a roguelike) and I still haven't figured out how to store and retrieve maps. Until now I used a text file that's ...
3
votes
2answers
234 views

Real time data retrieval - database vs file system

I'm planning to develop a game in which I want to draw 3d models in real time using some given x,y,z coordinates. The coordinates will be given at an average of 30 coordinates per second. Drawing will ...
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
233 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
504 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
529 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
261 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
2k 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
613 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
813 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
585 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 ...
-2
votes
1answer
637 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
551 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
418 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
1k 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 | +----------------------+ | ...
3
votes
1answer
689 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
373 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
186 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
399 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
820 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
240 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
999 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
5k 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
839 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
570 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 ...
15
votes
4answers
4k 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
639 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 ...
17
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 ...