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
2answers
105 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
226 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
278 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
103 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
2answers
85 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 ...
0
votes
1answer
249 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 ...
1
vote
1answer
101 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 ...
2
votes
1answer
123 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 ...
0
votes
0answers
41 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
42 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
55 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
144 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
182 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
160 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 ...
2
votes
1answer
105 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 ...
3
votes
2answers
432 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 ...
1
vote
3answers
224 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 ...
0
votes
1answer
147 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 ...
2
votes
2answers
514 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 ...
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 ...
1
vote
0answers
166 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
0answers
293 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
318 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
175 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
112 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
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
390 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
857 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
220 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
233 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
168 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
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
5answers
576 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 ...
1
vote
0answers
216 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
385 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
129 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 ...
4
votes
2answers
2k 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
288 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
648 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
405 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
540 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
159 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 ...
1
vote
2answers
542 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
339 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
321 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
418 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
192 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
1k 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 ...