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)

3
votes
2answers
5k views

C# Item system design approach, should I use abstract classes, interfaces or virutals?

I'm working on a Resident Evil 1/2/3/0/Remake type of game. Currently I've done a big part of the inventory system (here's a link if you wanna see my inventory, pretty outdated, added a lot of ...
0
votes
1answer
767 views

How can I extract a list of Minecraft items and recipes?

I'm designing a robust system for resolving item dependencies in Minecraft and to do so, I need to maintain a database of items and recipes. Right now, this database has to be hand-crafted (no pun ...
1
vote
1answer
510 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 ...
3
votes
1answer
219 views

simple adventure game mechanics stored in database

I plan to code a little adventure-like game. To be able to build multiple episodes without deploying new code I want to store any information possible in the database. This includes stuff like ...
2
votes
2answers
132 views

Should many constants utilize constant variables or a database?

If you decide to design some sort of in-depth customization system for the player that utilizes a ton of different options, would you be better off using SQLite or just a whole bunch of constant ...
0
votes
1answer
91 views

cost of Adding Social Feature to your game such Creating guilds/guild chat [closed]

I'm making a f2p game in unity C#. The game currently has no social features. I would like to have players to have their own accounts and also a guild tab. This tab is where they can create a guild ...
-1
votes
1answer
793 views

Server Based High Scores

I'm currently using the following MySQL example to make a server side high score table: Unity Server Side high score The above example allows me to create a top 5 player high score table that sorts ...
10
votes
5answers
1k 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. ...
0
votes
1answer
260 views

How to setup Authentication Database and Game Database?

I'm playing around with creating a game in C# using the XNA Framework. I've decided to use technologies that I'm pretty much familiar with and create things from scratch. There are probably frameworks ...
1
vote
2answers
334 views

web based quizz game database design, how do I store results? [closed]

I'm building a very basic quizz type of php/mysql/ajax game. At this stage I'm thinking about the DB design, and specifically how to score results, I've two options in my mind. But cannot decide ...
2
votes
2answers
344 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 ...
1
vote
2answers
258 views

Centralized User database for multiple Systems

I was wondering, how do large companies handle user accounts and allow different applications to access them. One example that comes to mind is Riot, their game League of Legends has a global user ...
0
votes
3answers
415 views

Is there any public in-game data mining/knowledge discovery repository? [closed]

I'm taking an Introduction to Data Mining course at the university and we have to work on a final project. As you may already know, it's difficult to collect this kind of data manually (specially ...
3
votes
5answers
678 views

Saving data in games?

I'm soon going to make a game for the iPhone as a school project. My idea was to make a TLOZ remake, with Tiled Maps. However, I'm not quite sure how save the data. In TLOZ you have a lot of sub-...
1
vote
0answers
357 views

What is the right way to use a QStateMachine for a text adventure game? [closed]

I have seen a couple topics about this already but they were a bit vague for me so I decided to make this. I'm working on a little adventure game just for fun in Qt, its basically just text on the ...
0
votes
3answers
640 views

Persistent Data for Multiplayer, Browser-Based Games

What is generally used to store persistent data in online games - browser games/facebook apps, in particular? I have used MySQL in web development before - but I've read that it's not very scalable, ...
1
vote
1answer
140 views

How to model / where to store relational data between classes

I'm trying to figure out the best design here, and I can see multiple approaches, but none that seems "right." There are three relevant classes here: Base, TradingPost, and Resource. Each Base has a ...
6
votes
2answers
7k views

Use a SQL Database for a Desktop Game

Developing a Game Engine I am planning a computer game and its engine. There will be a 3 dimensional world with first person view and it will be single player for now. The programming language is C++ ...
2
votes
3answers
415 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 ...
2
votes
2answers
1k views

Game Database Connectivity Java

I'm developing a simple multi-player puzzle game in Java. Both players should be able to view the same game board on his own computer. Then, when one player makes an action in the game (ex. drags an ...
2
votes
0answers
687 views

ECS, databases, XML and serialization [closed]

My entity/component/system engine is coming along quite nicely; I have two very different apps working on the same executable. (One 2-d scroller, one 3D Asteroids-type game). In the interest of ...
4
votes
2answers
929 views

C++ Database vs Reading Files

Ive been programing a C++ game/server for the past year. I have been using MYSQL for character logins, items, monsters, etc, etc. (im on windows). My question is, what are some of the databases that ...
0
votes
2answers
169 views

Algorithm for querying linearly through a non-linear list of questions

For a multiplayers trivia game, I need to supply my users with a new quizz in a desired subject (Science, Maths, Litt. and such) at the start of every game. I've generated about 5K quizzes for each ...
2
votes
2answers
948 views

Passive skills and items

I'm making a small text browser RPG game using PHP, MySQL and Java Script (and jQuery). All the items are saved in the MySQL database. Every now and then a character have to make a skill roll (Talk, ...
1
vote
1answer
419 views

Multiplayer (Database, Users,etc) for game

I'm am looking to add multiplayer into my game (2D Platformer in XNA C#) My worlds are quite large (Up to 30 Million tiles max, Average 20 million maybe. 2000x10000). You could say the game is quite ...
1
vote
3answers
397 views

Best practice for saving items?

In a game that I'm working on, any player has (at max) 460 items within their inventory. Each item has simple attributes, such as owner and quantity, but equips have different attributes, such as ...
4
votes
2answers
531 views

game multiplayer service development

I'm currently working on a multiplayer game. I've looked at a number of multiplayer services(player.io, playphone, gamespy, and others) but nothing really hits the mark. They are missing features, ...
7
votes
1answer
275 views

Multilingual data bases for most common words and phrases used in games

Games tend to have easy to understand instructions/menus/tutorials and so on, so I was wondering whether... Are there multilingual data bases, built-in with the most common phrases used in games? ...
2
votes
2answers
2k views

How should I store a Game Database on Android?

I'm looking at creating a game for Android and while I have most of the ins and outs worked out, the one thing I'm struggling with is how to store data for the game. Ultimately, the game will be ...
1
vote
1answer
280 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 ...
0
votes
1answer
223 views

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

A friend and I are currently looking at developing a game. We have 648 units that need to be defined, with 22 final values. To define the units in the game, we've created an abstract class with 44 ...
-1
votes
1answer
500 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
632 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
153 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
292 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
583 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
239 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
5k 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
961 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
881 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
1k 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
257 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 ...
3
votes
3answers
3k 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
271 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
674 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
867 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 averages,...
4
votes
1answer
444 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
2k 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 ...