Questions tagged [databases]

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.

Filter by
Sorted by
Tagged with
0
votes
1answer
35 views

Authoritative game server and database storage

In an authoritative game server working with websockets, should you store every action to the database before sending the response to the client? The risk is the slow response time. Or should the ...
6
votes
2answers
4k views

Workflow for authoring Pokémon-like game database content

I'm programming on a game that relies on a database for a lot of the creatures and items in the game (think Pokémon). Currently, we have a Google Sheet that the designers are making. They will be ...
0
votes
0answers
36 views

Data structure for objects in a galaxy of star systems

I'm having some difficulty coming up with the appropriate data structure to use for a game. I'm aiming for a galaxy view with tens of thousands of visitable star systems. Structure Hierarchically, ...
1
vote
1answer
61 views

Should I use a database to store ~10 000 names in a sports game?

I'm working on a single player sports game for a year or so and this doubt came up: how should I treat/store big amounts of data, like player names. Let's take an arbitrary number as example: 10000 ...
1
vote
0answers
387 views

How to build multiplayer games for android? [closed]

I'd like to know how to build android multiplayer games but I'm struggling to find a step-by-step or good resources on this topic. My main questions is which engine and api to use? I'd like to achieve ...
1
vote
1answer
40 views

database design for browser based game [closed]

I'm wondering how to design a database for the player's experience, whether to create a single table that will collect basic information such as. Class, race, number of experiences, number of occupied ...
0
votes
1answer
79 views

How to build TileMaps dynamically from a database?

The game I'm building allows users to create their own tile maps essentially, so I want the server to respond with tilemap coordinates if / when a user enters their custom world.
0
votes
0answers
36 views

minecraft like game server database arhitecture

Let's say we have a 2d map 500*500 tiles in size. And each tile is editable by players and has many states. So it's 250k tiles. The game is multiplayer online game. What would be the best approach ...
0
votes
2answers
67 views

How to create game database editor interface like Age of Empires' AGE

Age of Empires had this powerful AGE (Advanced Genie Editor) tool to let players mod the game data with ease. You could see all the game's databases through this tool and play with them to make your ...
1
vote
1answer
76 views

How to handle data for a competitive multiplayer games

I am kinda new to Multiplayer Games and I am really wondering how I should handle my data Should each player send and update their data to the database (server) everytime one of their essential ...
0
votes
0answers
355 views

Data storage for a large number of independent actors in real-time

Basically I am creating a pretty similar game to this post. It's a large scale real-time strategy game with thousands of units active at once. I'm trying to figure out the best way to store the game ...
1
vote
2answers
43 views

Custom functionality for content saved to database

I'm creating a turn-based game where I store most of my content in a database (enemies, items, npcs, location data, etc). This allows me to update the content easily without needing to rebuild ...
11
votes
4answers
4k views

How can I implement an inventory that stores different types of items?

Let’s assume I want to create an RPG with collectible items my character can pick up and store in his inventory. One item could be a sword, with an attack, defense, and level attributes. Another ...
0
votes
1answer
130 views

How do Mobile Idle-Games work [duplicate]

I wonder how idle games, games where players only make a few clicks to get a game progress, work. These games appear to be running in the background, even when the app is closed. Therefore these games ...
0
votes
1answer
344 views

Pattern for modular ScriptableObject-Database?

Lets say we want to store game data inside of scriptableObjects and we have plenty of them... So we need to find a way to store them efficiently in a modular way. What pattern could we use to code a ...
2
votes
1answer
119 views

How would one implement having a total set of TCG cards vs the specific instances of said cards in a player's deck, hand, field, etc?

For example, let's say in total there may be 5 cards that are in the game, let's use: Axe-thrower (3-cost, Creature, 5 Power, 3 Defense, Rush ability) Ice Elemental (2-cost, Creature, 2 Power, 5 ...
0
votes
1answer
158 views

Engine for a Football Manager Type game (data driven, menu clicking) [closed]

A friend and I had started developing a football manager two years ago, but ultimately squashed the whole thing because we found ourselves in a mess with developing UI and saving/loading. The basic ...
2
votes
2answers
933 views

What is the reason that people avoid PlayerPrefs to store character data and coins etc?

PlayerPrefs are easy to implement and i think it can be used to store important game data like selected character and coins and completed quests for small games, but i have read too much to make me ...
0
votes
2answers
136 views

MMORPG - Auction House and Bank Primary Keys

On to the next... So I've been sitting with the idea of how to better future proof my database tables when it comes to things like auction houses, inventories and banks. Q: Is it really necessary to ...
0
votes
1answer
116 views

MMORPG - Representing Money in a DB table

Where to begin... I'm currently busy with a few Udemy courses on game development using Unreal Engine 4. My end goal is to develop an MMORPG that I've always wanted to play, but never found online. Q:...
1
vote
1answer
118 views

How to set up an architecture and a strategy allowing the persistence of the data of a MUD in a relational database?

How to set up an architecture and a strategy allowing the persistence of the data of a MUD in a relational database? Type of game: My question relates to the design of a Multi User Dungeon (MUD). ...
0
votes
0answers
70 views

How to manage virtual currency transactions

I am developing a game that needs a transaction management system. Once player finish a task, he or she would gain some amount of credits (virtual money). When Player_A buys some virtual things from ...
0
votes
1answer
70 views

How to connect to a server without hard coded passwords?

I have two features in my game that need to a server of some kind that require authentication: a bug reporter and a leaderboard. The bug reporter will take the users report and add it as a card to my ...
0
votes
1answer
113 views

Storing Users Character in MySQL Database

Just asking a quick question about storing Characters in a database. I am currently implementing a MySQL Database to store character data, using this current structure Character Table: ...
2
votes
1answer
626 views

Game communicates with MongoDB in the Editor but not in WebGL build

I was trying to implement MongoDB in my Unity WebGL game and everything is working fine in the editor: I managed to insert and retrieve documents from my Mongo database with no issues. Everything ...
0
votes
0answers
39 views

Do I need a server if I only want to upload data to a DB?

I'm currently creating a game where people get some kind of reports for their game performance on a website. Let's say, you log-in, play the game, the system gathers your performance data and this is ...
0
votes
1answer
61 views

Online database

In a unity MOBILE game where a player needs to see all online other players added by each other. and once one gets offline, or their scores changed, their status gets updated, do I need a real time ...
2
votes
1answer
160 views

How can I avoid writing a class for each of my 800 different items?

I have a webgame written in PHP and using MariaDB for the database. I'm currently looking into ways of improving core systems. One example would be items. Currently, there is a table ...
0
votes
0answers
27 views

In which game use cases or contexts is it safe for a game client (end user application) to talk directly to a data store?

I have noticed countless messages that discuss the architectural design of nodes, networks, middleware, databases, and how the clients (as in a game client on a phone, browser, console, PC, etc) ...
1
vote
1answer
131 views

Store temporary state in DB or not

Background I'm trying to implement a little MMORPG. I'm planning to use Cassandra DB for the database. Question I don't really understand which data should be store in DB and which one should be ...
0
votes
0answers
50 views

Large game statistics database management

I am making a management game in Java with a farming theme. I am rather beginner in software development and every steps requires lots of thoughts. I am at a point now that I want to log and keep ...
1
vote
3answers
1k views

How to efficiently store a large amount of data?

I am doing minecraft-like game. I have a limited world in size 32x16x32 chunk. Each chunk is a structure in which there is a three-dimensional array containing the values ​​of the blocks located in it....
0
votes
1answer
99 views

Creating structure to a game (Missions, Dialogue, Triggering events upon items collected, etc) & monitoring the progress of a player in our code?

Hello all I have been working with Unity and other game engines/libraries for many years in my spare time. It's been a long twisty road full of joy and pain :D In the last few months or so I have been ...
0
votes
1answer
94 views

What is the easiest way to make an online high scores table?

I made an 2d Android game with using Libgdx library. This game like Flappy Bird. And every user have a highscore. I want to store this highscores respectively to an online database and return the rank ...
3
votes
1answer
665 views

How to store and retrieve user data in a multiplayer game

I am building a multiplayer game with a team and each player will have a multiplayer rank, a matchmaking rating (MMR), a username, and possibly a picture, a description etc. We are planning on ...
1
vote
1answer
67 views

Online Browser Game Resource Incrementing Production Problem

I am working on a browser game where there are citys and their resource productions. Each player has their own production rate for each resource.Lets say stone as example. I have production rate,...
0
votes
2answers
141 views

Update android game with new levels without replacing database

So I've published a game for android users containing 400 levels and 2k users have completed or are playing it since. Now I'm going to update the game with 600 levels, but I don't want current users ...
0
votes
4answers
198 views

Do I need a database to support a sign-in system to associate a player with their save/highscore data? [closed]

I am making a 2d game with Unity, and in my game I want to add a username and a password for each player, so that when the player signs in, they will get all the data about what they played until the ...
1
vote
1answer
195 views

How MMOs store IDs for game entities

Wondering in general how IDs are stored in a large massively multiplayer online game. From what I can imagine, it seems that each "game entity" would have a globally unique ID (GUID). Say there are ...
0
votes
1answer
315 views

Making read from and write to databases

I want to make a few simple databases for a sports game using Unity2D(C#). One is a read-only google sheet where it takes the players from the pool and adds them into the game at the start. Another ...
-1
votes
1answer
145 views

What is “storage” in MMOs with vehicles good for, where all equipped items get removed?

Many games, for example Star Trek Online (Dry Dock) and Battletech (Storage) have a concept of placing a vehicle in storage. It is not ready for use, you're not destroying unused vehicles, but rather ...
0
votes
1answer
351 views

Best way to store items with statistics in an mysql database?

Im currently working on an multiplayer game. Therefore using MySql for my game to store different data ( For example players, resources and so on ). Lately i implemented items, players receive them ...
0
votes
1answer
70 views

Should all stats only exist on MySQL database for my Flash browser RPG?

I'm creating a browser RPG in Flash which will have some multiplayer elements and in-app purchases so security is a high concern. Would it be better to have all game stats like health and such exist ...
4
votes
2answers
248 views

How to achieve game server redundancy?

The game I'm developing has a simple game server which stores inventory and hero data for each user, as well as deciding the outcome of some random events. The server interacts with PostgreSQL and ...
0
votes
1answer
960 views

Best data structure to store large amount of data

I am making a minecraft kind of game. In which I have 100s of objects and their crafting recipe. Now I want to store them inside the program, ie I cannot load external files. Everything must be ...
1
vote
1answer
246 views

Save game on server side

I'm working on a small management game. The player manage his hospital where he can collect items and new characters. Each player can visit others players hospital and gives collected entities. I ...
1
vote
2answers
300 views

Generating Unique Identifiers for Procedural Item Generation

I have been writing all the necessary code for procedurally generated items within my game. The database mechanism that I have built supports new items at runtime, such as when a player opens a chest. ...
1
vote
1answer
135 views

How to trigger poison effects efficiently

I'm trying to trigger poison effects at the end of each turn in a turn based game. Each Actor in battle has a list of active effects, each of which could be a poison. I simply want to Execute() all of ...
26
votes
2answers
5k views

What's the performance benefit of saving all logged in characters in MMOs in regular intervals?

The majority of MMORPGS have a Worldsave system that will save all the characters once every X hours. I guess the reason is performance. So why is this better, performance wise, than saving a ...
1
vote
2answers
296 views

Strange issue with bool comparing ToString always false - unity c#

I have another problem with my code that I can't fix :\ Basically i have an enum called 'type' in my Item class, which tells me if the item is consumable, or equipment, etc. In the database script I ...