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.
1
vote
1answer
74 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
69 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
28 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
28 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
52 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
99 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
149 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
86 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
89 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
328 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
204 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
127 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
389 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
143 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
236 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
271 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
159 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
107 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
78 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
329 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
774 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
185 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
190 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
218 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
149 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
329 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
551 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
171 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
347 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
125 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
267 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
541 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
330 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 ...
3
votes
2answers
480 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
152 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
465 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
320 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
304 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
385 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
180 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
909 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
241 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
177 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
290 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
481 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
218 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
408 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 ...
