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.
2
votes
2answers
209 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
254 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
65 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
48 views
“Game Property Values” for online game on Database or somewhere else?
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
134 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
84 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
108 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
35 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
40 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
54 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
125 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
165 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
113 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
99 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
372 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
206 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
144 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
443 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
154 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
262 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
296 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
167 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
110 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
79 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
347 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
822 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
194 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
205 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
224 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
160 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
342 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
566 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
186 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
371 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
127 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
273 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
581 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
371 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
515 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
156 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
518 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
330 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
312 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
403 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
186 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 ...
1
vote
1answer
247 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 ...
