Skip to main content
Game Development

Questions tagged [databases]

Ask Question

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.

217 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
89 views

I'm currently developing third-party app to existing rpg game which serves useful information about the game. I don't have much experience of game-related development. The game provides api for ...
evol1102's user avatar
  • 51
0 votes
1 answer
112 views

What are the pros and cons of storing hero stats (health, velocity, stats for abilities) in a database versus ScriptableObjects for my MOBA-like game? I would like to be able to constantly update hero ...
Srdjan Pazin's user avatar
  • 99
0 votes
2 answers
425 views

Apologies for the length, I'm currently struggling to model a recursive loot table system in a PostgreSQL database for my game. Meaning, I want to have a main loot table, and then add sub-loot tables ...
Tdude179's user avatar
  • 1
0 votes
0 answers
127 views

I'm working on a project which is a collectable card game, where cards gonna have very different abilities, for example as in Hearthstone - one card kills another card, another gives mana, another ...
13ackspace's user avatar
  • 1
0 votes
1 answer
509 views

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 ...
zukk's user avatar
  • 1
0 votes
0 answers
101 views

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 ...
user avatar
11 votes
4 answers
7k views

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 ...
Trevor's user avatar
  • 221
2 votes
6 answers
352 views

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 ...
qris's user avatar
  • 53
0 votes
2 answers
210 views

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 ...
Jack Hail's user avatar
  • 3
0 votes
1 answer
970 views

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 ...
sharpness's user avatar
  • 101
0 votes
1 answer
617 views

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 ...
NullPointerException's user avatar
  • 101
2 votes
1 answer
3k views

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 ...
Qiao's user avatar
  • 121
0 votes
1 answer
300 views

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-...
Alireza Peer's user avatar
  • 109
1 vote
1 answer
117 views

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 ...
Loospie's user avatar
  • 191
2 votes
1 answer
872 views

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 ...
MightyOwl's user avatar
  • 21
0 votes
0 answers
166 views

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 ...
Ryan's user avatar
  • 887
0 votes
2 answers
2k views

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 ...
Gamer's user avatar
  • 1
0 votes
2 answers
82 views

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 ...
DDD's user avatar
  • 1
0 votes
0 answers
23 views

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 ...
duong_dajgja's user avatar
  • 101
1 vote
2 answers
613 views

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 ...
besplash's user avatar
  • 113
0 votes
0 answers
907 views

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 ...
genaray's user avatar
  • 517
18 votes
4 answers
4k views

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 ...
Battle's user avatar
  • 1,285
0 votes
1 answer
195 views

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 ...
Arty's user avatar
  • 103
6 votes
2 answers
5k views

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 ...
maxresdefault's user avatar
  • 63
0 votes
0 answers
200 views

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, ...
Basic's user avatar
  • 1,287
1 vote
1 answer
286 views

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 ...
Gabriel Minosso's user avatar
  • 15
1 vote
0 answers
864 views

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 ...
Xandy Vieira's user avatar
  • 11
1 vote
1 answer
563 views

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 ...
martin suchodol's user avatar
  • 11
0 votes
1 answer
1k views

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.
James Nixon's user avatar
  • 101
0 votes
0 answers
119 views

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 ...
lxknvlk's user avatar
  • 236
0 votes
2 answers
253 views

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 ...
aganm's user avatar
  • 140
1 vote
1 answer
494 views

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 ...
Fvnex's user avatar
  • 13
1 vote
2 answers
78 views

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 ...
Evan Ward's user avatar
  • 125
14 votes
4 answers
8k views

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 ...
Alex Donnelly's user avatar
  • 165
0 votes
1 answer
847 views

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 ...
IdleGameFan's user avatar
  • 3
0 votes
1 answer
891 views

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 ...
genaray's user avatar
  • 517
2 votes
1 answer
243 views

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 ...
GrowingCode247's user avatar
  • 123
0 votes
1 answer
1k views

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 ...
Toto's user avatar
  • 23
3 votes
2 answers
2k views

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 ...
zsshan07's user avatar
  • 77
0 votes
2 answers
394 views

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 ...
Francois Du Toit's user avatar
  • 5
0 votes
1 answer
674 views

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:...
Francois Du Toit's user avatar
  • 5
1 vote
1 answer
309 views

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). ...
Daily45's user avatar
  • 21
0 votes
0 answers
135 views

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 ...
shi95's user avatar
  • 101
1 vote
1 answer
187 views

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 ...
mr-matt's user avatar
  • 2,779
0 votes
1 answer
427 views

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: ...
Tom Heeley's user avatar
  • 101
3 votes
1 answer
1k views

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 ...
roseicollis's user avatar
  • 31
0 votes
0 answers
62 views

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 ...
roseicollis's user avatar
  • 31
0 votes
1 answer
114 views

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 ...
Hi There's user avatar
  • 3
2 votes
1 answer
314 views

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 ...
Niet the Dark Absol's user avatar
  • 705
0 votes
0 answers
45 views

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) ...
Neeraj Murarka's user avatar
  • 101

1
2 3 4 5