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
29 votes
5 answers
29k views

How to choose how to store data?

Until recently, I used two methods to store data on my non-game project: XML files, and relational databases. I know that there are other kinds of database as well: the NoSQL kind. However I don't ...
0 votes
1 answer
1k 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
1 answer
246 views

Best way to store player data like scores, rewards, login info, checkpoints etc for offline PC games?

I am creating a VR game in Unity, it will be an offline PC game. I want to store user login info, score, checkpoints, learning points, rewards etc in the database. I checked out firebase but it doesnt ...
0 votes
0 answers
73 views

What class should access my database?

I would like to code a turn-based RPG, and I decided to use a database to store all skills in the game. Now I have to decide as well which class can see this database, and how classes pass around ...
11 votes
4 answers
6k views

How do online games handle frequent updates?

Web/Mobile full stack engineer here. Zero game experience. How do big multiplayer games handle multiple database updates simultaneously? I.e. World of Warcraft or similar games with 10k players ...
2 votes
6 answers
229 views

Modelling Two Way Relationship in Unity for Scriptable Objects

How does one model two-way relationships for scriptable objects? Let's say we have a number of items in-game, and each item can be obtained by different conditions. Some may require you to complete a ...
1 vote
1 answer
73 views

How do I handle a non-hierarchical, referential network of game data?

I've been using JSON to store a lot of my game's data. I love it compared to my previous workflow. Having a human-readable hierarchy of arbitrary information is a godsend. My needs have grown more ...
1 vote
1 answer
1k views

SQL Database structure for ECS

I am making turn-based browser game (mostly server-sided), and every turn all game-state is saved into database (SQLite). Using ECS pattern. Never done this before (I am webdev). There will be a lot ...
0 votes
2 answers
177 views

Do a quiz from web api data

i'm new to unity and i want to do a quiz using data coming from a web api I was able to retreive data from the api but i couldn't make the game logic with them This is where i arrived ...
0 votes
1 answer
369 views

One sqlite db per savegame or one big sqlite db for all the savegames?

when you develop a simple local game, with 4 slots for history mode, wich option is better to persist the savegame of the history slot openned by the user? The game has 4 entities with some simple ...
0 votes
2 answers
906 views

Designing database schema for multiplayer game inventory

I want to create an inventory system for an online multiplayer game, so I was thinking about database. My research led me to this form: id (user, bigint, unsigned + index, foreign key for user's id ...
0 votes
1 answer
584 views

proper items db design mysql

I'm working on a game using MySQL as the db. I'm struggling a bit on the database design, this is the part I'm struggling with: So basically exp_ups, mystery_boxes and weapons are entities in the ...
1 vote
1 answer
133 views

How to connect to a server without hard coded passwords?

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

How to save user progress and report on the server?

I'm developing a game that consists of many mini-games. We want the user username to be recorded and saved. Also, each time the user plays one of the mini-games, some reports for that specific mini-...
2 votes
1 answer
492 views

How is data regarding items in RPGs and other loot-based games stored and implemented?

I am currently practicing game design and development by implementing singular (or a small set) of mechanics in Unity. For example, -- and this is relevant towards the end -- I've just finished a ...
0 votes
0 answers
100 views

How important is it to use an in-memory datastore for real-time networked game data?

I am building some online multi-player web-based games. Naturally, we are using WebSockets to connect to the game server. I need to store "real-time" data for these games, things like which ...
0 votes
2 answers
52 views

regarding about game servers performance and security

I have two options to implement should my game server access the database directly should game server access database via api would it be necessary to abstract the calls via api even though its ...
3 votes
1 answer
1k 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
0 answers
22 views

Appropriate database schema for heroes' skills in a Tower Defense game? [duplicate]

In a Tower Defense game, each hero (or character) has some skills. Each skill has some "chance of appearance" (CoA for short) when attacking enemies and if appeared it has some "hit ...
1 vote
2 answers
418 views

What's a code-efficient way to go about DB objects, DTO objects and actual objects?

Currently I have 3 different classes for the same type of entity. One is the main class that contains logic and everything the entity needs. Then I have a DB object, that has the same structure as the ...
0 votes
0 answers
556 views

Ways to persist entities and components in an ECS?

I am working on a small multiplayer game with rpg elements using java and "Artemis ODB". Most of the logic is already done but one important thing is missing. The persistence. So i am ...
18 votes
4 answers
4k views

How can I efficiently load huge volumes of star systems?

I am working on a space exploration and combat game, and I can create galaxies, nebulas, solar systems, and load and unload them procedurally as needed. Meaning the stars that the player can see are ...
0 votes
1 answer
145 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
2 answers
5k 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
0 answers
139 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
1 answer
233 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
0 answers
828 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 ...
0 votes
2 answers
161 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
1 answer
433 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
0 answers
87 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 ...
1 vote
1 answer
411 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 ...
13 votes
4 answers
7k 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 ...
1 vote
2 answers
53 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 ...
0 votes
1 answer
594 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
1 answer
1k 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 ...
0 votes
1 answer
862 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 ...
1 vote
2 answers
2k views

Where and how to store players collection in a computer card game?

I am developing a trading card game ( something like Hearthstone but not as complex) and I am faced with the following problem: I don't know what is the optimal way to store players collections and ...
2 votes
1 answer
169 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 ...
1 vote
1 answer
251 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). ...
30 votes
8 answers
24k views

Would it be better to use XML/JSON/Text or a database to store game content?

I'm considering how to implement a component-based game, as that seems to be the hot thing and I like the idea of such a flexible design. One of the features of such a design is that adding new ...
0 votes
4 answers
207 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 ...
3 votes
2 answers
2k 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 ...
5 votes
4 answers
1k views

How to implment the database for event conditions and item bonuses for a browser based game?

I am currently creating a browser based game, and was wondering what was the standard approach in making diverse conditions and status bonuses database wise. Currently considering two cases. Event ...
4 votes
2 answers
2k views

Tools for creating an item database [closed]

I'm working on a project for which I will need to create a large item database, with plenty of different types of items which will all have different data structures and attributes. I'm hoping to ...
4 votes
3 answers
2k 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, ...
0 votes
2 answers
251 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
1 answer
477 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:...
3 votes
2 answers
7k 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
0 answers
112 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
1 answer
337 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: ...

1
2 3 4 5