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.
217 questions
0
votes
0
answers
87
views
DB for RPG game item: Should I stick with RDB?
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 ...
- 51
0
votes
1
answer
112
views
Storing hero stats: Database vs ScriptableObject (MOBA game)
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 ...
- 99
0
votes
2
answers
417
views
Database Design of loot tables
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 ...
- 1
0
votes
0
answers
125
views
How to store an ability mechanic?
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 ...
0
votes
1
answer
506
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 ...
- 1
0
votes
0
answers
100
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 ...
user167577
11
votes
4
answers
7k
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 ...
- 221
2
votes
6
answers
350
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 ...
- 53
0
votes
2
answers
210
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
966
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 ...
- 101
0
votes
1
answer
611
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 ...
2
votes
1
answer
3k
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 ...
- 121
0
votes
1
answer
296
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-...
- 109
1
vote
1
answer
117
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 ...
- 191
2
votes
1
answer
860
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 ...
- 21