Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

2
votes
1answer
26 views

Structures for item data

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

Unity: Get excel type data from an html website

So is there a way that I can use an html page as a database? My end goal is to put everything into an excel sheet that the people I am making the application for want. I need to upload data from the ...
0
votes
0answers
22 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
80 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
33 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
178 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
57 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
60 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
189 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
46 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
87 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
174 views

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

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
134 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
167 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
127 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
131 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
52 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
189 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
0answers
42 views

Better way for authentication servers

I'm about to start working on a project with a friend of mine, our first multiplayer game (alone nor together) and I was wondering about something so I thought it's the place to ask. This game is ...
0
votes
1answer
485 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
151 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
135 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. ...
0
votes
0answers
36 views

How to Approach User Accounts, Data and Stats

I'm not sure what the best approach is for how to setup a user account system. Ignoring login/security issues for now, I just want to store a small amount of data, like DisplayName, ProgressionLevel, ...
1
vote
1answer
121 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
188 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 ...
0
votes
2answers
183 views

Relational Databases vs XML vs public static finals: Pros and Cons [closed]

I'm working on a game (single player, metroidvania type, Java) and I'm torn as to how data should be stored. For example, monster stats, dialogues, flavor text for weapons, gear stats... there is all ...
0
votes
2answers
327 views

How to Structure my Database for a HTML turn-based strategy game?

I'm making simple HTML socket game that I want to record over time. It's a "risk" type game where individual tiles can be conquered, and the team with the most tiles is winning. As of right now, I'...
2
votes
2answers
2k views

realtime multiplayer game database design

I'm creating a real time client/server game, where each match is a 1v1. I'm a little lost as how to implement this. I want it to be viable for 1,000 simultaneous matches, but as I'm expecting around ...
2
votes
2answers
283 views

Storing quests for an online RPG in a MySQL database

I'm creating an online RPG game and I've been looking around for a way to save players' progressions in quests in MySQL. I've been looking at Pim Jager's answer answer for a while and I've come to the ...
0
votes
2answers
628 views

Where is the best way to store game stats?

I am building a small Android game with Unity. Everything is going OK, but I have some things bothering me, that I see no real solution. The problem In my game, you build your character as you like, ...
0
votes
1answer
78 views
1
vote
2answers
582 views

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

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 ...
0
votes
2answers
192 views

The most correct/efficient way to update millions of entities that change over time in an mmo?

We have a server and a database in the cloud. We have a game where each player can grow a farm on a massive x,y grid. Each hour is a grow cycle. All players can harvest anyone's plants. Player A ...
0
votes
1answer
384 views

Appropriate data structures for large item database

I'm currently building an RPG Game and as such I intend to have a lot of items. In my current system I have a database of items stored in a JSON file which I read and then store the items in a generic ...
1
vote
1answer
350 views

Unity store data in database

Is it possible to store assets used in a Unity game (2D or 3D) in the database? I think it is less efficient but want to have single source of truth and maybe have the game contact the database ...
0
votes
1answer
508 views

How is text/scripts/dialogue stored and accessed in games?

For large, complex games, I imagine that text descriptions, dialogue lines, etc, are organized in some sort of database, and not actually hardcoded into the source. Are there any conventions on how ...
0
votes
0answers
83 views

Efficient use of database in game loop

I'm trying to write a simple browser based style game (I say browser based style because I'm running it all locally). The game is a real time strategy in which player control towns and armies and try ...
0
votes
1answer
706 views

Structure game database to store player info and items

Recently I started developing my tiny html5 multiplayer game made in Node.js, Express.js, MongoDB(Mongoose), Socket.io and using Phaser.js. I am quite new to these frameworks and especially new to ...
0
votes
2answers
616 views

Is it a good idea to use a single sqlite database to store all occurring multiplayer matches?

I have a turn based strategy game for desktop and mobile, the game app uses a sqlite database to play local games. There's nothing special about the database design, I have tables to keep track of ...
-2
votes
3answers
2k views

How do I make a highscore database for Unity?

I have been looking around, but I haven't found the perfect answer, yet. I want to to send scores from Unity to a database, without a username, and display the high scores in the highscore menu. How ...
0
votes
1answer
432 views

Inventory Table efficiency

I'm building an inventory system for a MMORPG game that can possibly contain massive numbers of players (~20.000). Is it smart to make an InventoryTable where each row contains only one item, or ...
1
vote
1answer
362 views

Game data structure in node.js

I am building a simple turn-based game in node.js using sockets.io. My web experience with node.js has typically involved saving everything to a relational database. I set this up for my game. I am ...
1
vote
0answers
110 views

Database design

I have a Ship class, into which components can be added which change the performance of the ship. The question is regarding modelling this. My first approach essentially was an EAV approach (a ...
1
vote
0answers
31 views

Paradigm for storing user data for iOS

Disclaimer: I'm not well versed in Game Dev best practices so this may be a trivial question. I'm developing an iPhone game in which I have to store a user profile containing such information as ...
3
votes
1answer
856 views

Ability/Skill Data and Method Structure (C#, Unity3D)

So I've come to design my game which players will be having a unique set of skill or ability to come with. I can store skill name, mana cost, cooldown, etc in database which each skill have in common, ...
0
votes
1answer
116 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 ...
1
vote
1answer
89 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
68 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
1k 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 played,...