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
30 views

How flat-file and databases compare in games development? [closed]

Typically games built with a goal of being easily modded often store data in plain text documents, such as Rimworld. I can't see why an entire database system would be implemented just to read a few ...
0
votes
0answers
41 views

MMO inventory design SQL Server [closed]

Two basic designs : 1) table: user_inventory playerid itemid quantity position of the item in the inventory ( dunno if that should be here?) 2) Have a binary column "inventory" in the ...
1
vote
1answer
37 views

game server - fault tolerant

If you have for example an MMO with 2000 players, and players are constantly removing / creating / swapping items (and doing some other important things that can't be lost). If the updates are saved ...
1
vote
1answer
35 views

How can I reduce writes-per-second when saving player data to a database?

Consider a game where the player has some profile or save data stored in a database. What I want to understand is, for things that effect the users score or level, there could be so many factors that ...
-1
votes
2answers
72 views

Most Efficient Way to Store player stats/data in Unity C#?

I am looking at storing player data in Unity from a script that I'm writing in C# and I would like to get an opinion on the best way to store the player's stats/data about the player like hours ...
3
votes
1answer
77 views

How do I get data from a WWW object without freezing my game?

I am using Unity 3d to create a real time multiplayer game. I have a database set up that keeps track of player statistics and what in app purchases they have purchased. I have written a Database ...
0
votes
2answers
106 views

Backend for data-driven multiplayer game

I am working on a match-based (5v5) multiplayer steam game that is similar to TF2, LoL, Dota 2, etc. I am planning a data-driven approach where character/abilities/items/etc are defined in data ...
0
votes
0answers
36 views

Save and retrieve image from database in unity

I have done a sample to insert and retrieve data from MySQL in unity.Now I need to insert and retrieve image from MYSQL in unity. The images are files selected by the user from their filesystem. Can ...
0
votes
1answer
70 views

Accessing a database with a php script from Unity mobile game

So I am attempting to keep track of some user data in my game that I am creating in Unity 3d. I am using Unity's WWW class to do this. I am following this tutorial: ...
2
votes
1answer
96 views

How should I implement a timer in a strategy game?

I'm developing a real strategy game for Android and want to implement timers. Those timers will represent the time remaining until some building is finished. Say that i have a building in ...
0
votes
3answers
75 views

Database works on unity editor,but not on android device

I am working on database connectivity in unity.When I run my project I am able to access my database(retrieving and inserting data into database).But the problem is that when I take the android out ...
0
votes
0answers
41 views

storing hexagon-based (x/y) movements in a database

Im developing a hex(agon)-grid based game. The game is turn-based. Players move stuff on the map and they need to be allowed to issue movement-orders. Units move a certain amount of movement-points ...
1
vote
2answers
59 views

Modeling an inventory system in SQL

I'm working on a multiplayer game played through the browser. It's not a real-time game which is why I decided to go with a database, however I'm pretty weak with SQL and starting to run into ...
1
vote
0answers
35 views

Need to find a web database of german words for taboo game [closed]

I am looking for a web database of german words like this in english. Anyone knows sth about this? I develop the game based on such database of words, so this is why I asked about this here.
15
votes
3answers
3k views

Should I use a database for storing game content? [closed]

I have a 2D Game written in C++ using SFML. I want to make the game expandable in such a way that content like items or entities could easily be added by adding a line/entry/row to a file or ...
0
votes
0answers
39 views

Proper method of writing XML File data into a class array?

So I have 3 objects, The Main world class that is meant to hold all global data and do some mild file manipulation, the biome class that is meant to be syntax for creating biomes, and the XML file ...
1
vote
1answer
79 views

Is Google's Protocol Buffer viable for the serialisation of game data? [closed]

Simple yes it is suitable, no it is not suitable for communications between game clients and/or server clients. Also is it suitable for serialising and storing game data or is a more customisable, ...
1
vote
2answers
95 views

How is persistence managed by browser games?

I was wondering, when you play browser games you never seem to witness a page refresh, even if there is data being stored on the server. So how are databases handled by browser games. In my opinion ...
2
votes
0answers
34 views

Android native database organization

I am developing an Android native game, but I have problems with Data Storage. For a better comprehension think it like as i am developing Clash of Clans, but with Native Andorid. Now imagine I have ...
1
vote
1answer
206 views

Embed a real city in a game and use data to find and display paths [closed]

First of all this question is gigantic but it's mainly about Unity, maps, pathfinding, and real data. The problem. In my game the player sees the map of a real city (in 2D), it’s exactly the same ...
0
votes
1answer
159 views

Database for a diablo 2 like item system?

Diablo 2 has a very sophisticated item system and I want to create something similar. But I am having a hard time getting the architecture right. In Diablo 2 most different kind of gear has different ...
2
votes
1answer
339 views

Libgdx Networking (http requests) - Login [duplicate]

I am new to Networking and Databases, but im trying to learn MySQL and HTTP Requests to create a user Login for a game. My goal is to let users create accounts and login to them etc (for Highscores ...
0
votes
0answers
58 views

Map and Positions, Database Structure

The database structure: maps id name positions id map_id x y The relation states: Each map have many positions, A character can be on a position. So the idea is to store each x, y position on a ...
0
votes
1answer
34 views

SQLite Query from unknown table based on known column value single query

I'm working on a database to back up my online TCG. It's currently SQLite, but I'm going to transition it to a MySQL database later. Currently, I have three distinct types of cards with their own ...
1
vote
2answers
123 views

Using hard coded values for Items?

Is it a bad idea to use hard coded values for things like items (static data) that would change infrequently in an online game? I'm designing an online game in node js, and I'm trying to decide if it ...
0
votes
3answers
371 views

database structure for rpg items

I am currently developing a multiplayer html5 game, and the game has rpg elements (levels, items and such) I just started working on the database side of things, and now I have a mongodb server setup ...
-1
votes
2answers
81 views

How to make a proper cache on user computer?

Currently when launching the client of the game, it connects to the server and loads all the cachedata in a normal form (= folders, .txt files and .png files). However I don't like that the players ...
2
votes
2answers
3k views

Storing Type/Game Data Within A Unity 3D Game Using An Offline Flatfile Database

I've read several documents on how to manage game type data: Would it be better to use XML/JSON/Text or a database to store game content? How to choose how to store data? Im developing an offline ...
0
votes
1answer
227 views

Handling an item database with procedurally generated items?

Let's say you have an item database which has every item in your game. This works fine for regular items like a Health Potion, a normal Iron Sword etc, because these items have ItemID's so we can get ...
1
vote
2answers
569 views

Keeping high scores on Unity web player

I want the player to be able to save his score when she makes it into top 10 of high scores. Upon success, player will be asked for a name to submit. This does not need to be unique per player. I just ...
0
votes
1answer
445 views

Is it possible to create sqlite database only for android in LIBGDX game? [closed]

I want to know if I can just implement sqlite database for android in libgdx game? Also if this is not possible then may I know the simple way to integrate libgdx game to just store scores in sqlite ...
0
votes
2answers
158 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 ...
39
votes
9answers
12k 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
273 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
343 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
351 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
225 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
657 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
193 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
318 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
0answers
86 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
71 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
448 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
357 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
611 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
163 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
971 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
266 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
179 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
787 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 ...