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)

0
votes
1answer
315 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 ...
0
votes
2answers
87 views

“Game Property Values” for online game on Database or somewhere else? [closed]

I'm working on a online game but, what would be the best way to store values like damage,movespeed,turnrate, and so on.. ? My answer would be, to store them in a Database, so they can easily be ...
1
vote
0answers
168 views

Indie game databases [closed]

as I am approaching the end of development of my iPhone game I find it increasingly difficult to approach magazines / youtubers and bloggers interested in replying to me and featuring a preview of my ...
0
votes
2answers
110 views

I want to show total time spent by all players around the world in my game

I am developing a Unity3D game. I want to show in my game: Total time spent playing all time by all players around the world Total time spent playing in last 24 hours by all players around the world ...
37
votes
9answers
11k views

Why is it bad to hard-code content?

I know most games store dialogue text in files, but I've also seen a few text-based games actually program the content (map, choices, possible player commands, story text) into the game code. I can ...
2
votes
2answers
231 views

Processing periodical operations on the database [duplicate]

I program MMO strategy game (C# monogame) like Goodgame Empire or Travian for Windows Phone. The server part of the game will run on Windows Server and MS SQL database. I'm trying to figure out a ...
2
votes
1answer
286 views

Handling game-state updates in an MMO while the player is logged out

I have a plan to build MMO strategy game like Goodgame Empire or Travian for windows phone. I want program it in C# Monogame (because I have some good experiance with it). But I still can't figure ...
1
vote
1answer
109 views

how to store game state for a multiplayer board game eg. poker

First Approach: Store the state in database and play with database queries. Could a database handle the load, as poker is quite fast paced, and I have to query/update database for each player move. ...
0
votes
1answer
151 views

Is this technique for stat tracking without a database workable?

If I wanted to create a chess game, for iOS, that tracked both player moves (for retracing the progression of a game and for player stats), what would be the simplest route to take? To clarify, I ...
0
votes
1answer
264 views

HTML5 canvas multiplayer game with node.js and Isogenic engine [closed]

I want to create a multiplayer game using Isogenic engine i understand that this technology uses html5 and canvas for rendering graphics in frontend and node.js for backend. I started working on how ...
4
votes
2answers
3k 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
1answer
129 views

How should I store grid-based character inventories in the database?

I used to encode the whole inventory data into binary but I'm thinking of doing something different now. The inventory has a 64 slots in an 8×8 grid. Large items like weapons fill up 6 to 8 ...
1
vote
1answer
105 views

How can I can I reduce the write load on a database for an MMO?

I am considering using MySQL as a database for storing the character states or the world for that matter. The thing is if I will save the character data on an interval, thus giving rest to the mysql ...
0
votes
0answers
45 views

Am I missing something about these considerations about Leaderboard's database's schema?

I just finished to develop a mobile game, now I want to implement an online leaerboard using mysql. I'm wondering about the database's schema, I thought about some possibilities: (I didn't got in ...
1
vote
0answers
44 views

Best database setup for one click games [closed]

I am building a one click game website/mobile app, and I am debating between using MySQL and MongoDB for the backend. The way I have been exploring it is with a ...
1
vote
2answers
57 views

Server side random selection of players

Assuming I have a simple client-server game, where the server picks random players on a very frequent base, I was wondering what is the best way to select a random player (According to the following ...
1
vote
2answers
152 views

RPG: store dialog

I'm creating a single player web RPG. I was originally storing NPC dialog in a JS object. I could cycle through lengthy dialog in an array as I wanted. I can also store objects with K:V pairs. That ...
2
votes
1answer
187 views

RPG - storing player data

Given the following tree structure, where each player logged in can have data for current and completed levels, quests per level, NPCs per quest, and multiple tasks per NPC... I'm trying to figure out ...
1
vote
1answer
177 views

MMORPG game server data storage performance [closed]

When writing a MMORPG game server... Which storage design is better: Should I only save character data from specific times? On character log-out. User disconnect. From time to time. (every few ...
0
votes
3answers
348 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
2answers
455 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 ...
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 ...
2
votes
1answer
107 views

When to read/write to database with a game server

My question is fairly simple but maybe hard to answer. I'm currently building my own game server and I've done to login server now. So, on to the actual game server. I have a question for this server ...
49
votes
10answers
12k views
2
votes
2answers
528 views

Database vs classes in a rpg character sheet app for android [closed]

i'm trying to develop an android app to handle character sheets in roleplay games like D&D and Pathfinder. My target is to avoid calculations of bonuses by the player who only cares to set which ...
1
vote
3answers
227 views

Is there a better way to handle a large amount of organized game data in Character Creation?

I am currently working on a text based prototype, in where the player is (eventually) allowed to have over 180 character choices in a quickly played permadeath type of game. It's a lot simpler than it ...
3
votes
2answers
2k 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 ...
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 ...
1
vote
1answer
325 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
177 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
113 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 ...
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 ...
0
votes
1answer
80 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
401 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 ...
9
votes
4answers
865 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
203 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 ...
2
votes
2answers
225 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
237 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
169 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 ...
3
votes
5answers
580 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 ...
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 ...
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 ...
1
vote
0answers
225 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 ...
1
vote
1answer
130 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 ...
0
votes
3answers
390 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
votes
2answers
1k views

XNA with SQLite

Does anyone have experience using SQLite with XNA? Or using any other DB with XNA?
2
votes
3answers
292 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
684 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
417 views

ECS, databases, XML and serialization

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
423 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, ...