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
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 ...
CodexArcanum's user avatar
  • 1,372
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 ...
Eldros's user avatar
  • 409
65 votes
10 answers
45k views

What kind of databases are usually used in an MMORPG? [closed]

Do people write their own DB for some reason?
user avatar
14 votes
4 answers
5k views

How should I track players' real-time positions in an MMO?

How do you keep track of the positions of the players in a MMORPG? I read that you can use either a database or you can store the coordinates in files. I tried using a database but it was slow. How ...
rxjsisfine's user avatar
10 votes
2 answers
20k views

Should I use an SQL database to store data in a desktop game? [closed]

Developing a Game Engine I am planning a computer game and its engine. There will be a 3 dimensional world with first person view and it will be single player for now. The programming language is C++ ...
danijar's user avatar
  • 5,731
2 votes
1 answer
703 views

How can I handle game-state updates in an MMO while the player is logged out?

I have a plan to build MMO strategy game like Goodgame Empire or Travian for Windows Phone. I want to program it in C# Monogame (because I have some good experience with it). But I still can't figure ...
Earlgray's user avatar
  • 145
13 votes
4 answers
8k 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 ...
Alex Donnelly's user avatar
10 votes
11 answers
2k views

How to model multiple "uses" (e.g. weapon) for usable-inventory/object/items (e.g. katana) within a relational database

So I'm working on expanding the uses of items over at www.ninjawars.net, and I'm not exactly sure how to represent them flexibly in the relational database that we use. I may be barking up the wrong ...
Kzqai's user avatar
  • 1,188
2 votes
2 answers
2k views

Implementing an online database [closed]

I'd like to get into online games programming. I thought that as a start i'd be a good idea to implement an online database that would store the progress and score for a game i have made, i'll ...
dreta's user avatar
  • 3,524
1 vote
1 answer
3k views

Database for a diablo 2 like item system?

Diablo 2 has a very sophisticated item system and I want to create something similar. But I am having a hard time getting the architecture right. In Diablo 2 most different kind of gear has different ...
Madmenyo's user avatar
  • 1,979
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 ...
Gabriel Minosso's user avatar
21 votes
5 answers
15k views

noSQL - Is it a valid option for web based game? [closed]

Out of an opportunity and boredom, a friend and I decided to make a web based game. This is the first 'game' I will be making, since usually I program web apps in django. I've opted to use the same ...
Pran's user avatar
  • 381
8 votes
5 answers
1k views

What techniques enable web based games to update player's resources frequently?

Long ago there was this web-based game called Utopia (and I'm sure it is still around), turns are by per hour. You only get new gold/lumber or what-not every hour. Some newer web based games have ...
Extrakun's user avatar
  • 2,742
5 votes
2 answers
2k views

How do I store Items in MySQL?

I'm working to my first game containing items (built a small one before, strategy type but not very complicated). I was thinking something like this for the db design since it will be almost the same ...
Bogdan's user avatar
  • 155
5 votes
2 answers
2k views

Crafting recipes: storage and quering

Consider the following situation. In a game you can perform crafting: i.e. create new items from existing ones (like in Minecraft). I have following game entities (simplified): item: Atomic part. ...
Petr Abdulin's user avatar
  • 2,711
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, ...
Ziik's user avatar
  • 143
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 ...
Aggressor's user avatar
  • 233
2 votes
1 answer
1k 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, ...
Bunnny's user avatar
  • 21
2 votes
2 answers
2k views

RPG: store dialog

I'm creating a single player web RPG. I was originally storing NPC dialog in a JS object. I could cycle through lengthy dialog in an array as I wanted. I can also store objects with K:V pairs. That ...
user3871's user avatar
  • 1,055
2 votes
4 answers
2k views

Creating a database with special items, like in Diablo

I am in the middle of creating a browser game. I need to add 'special items' like in Diablo, but simpler. Item names are fixed (e.g. 'ring of power'), so only their attributes change. In my game ...
xpanta's user avatar
  • 163
1 vote
2 answers
388 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 ...
scranley's user avatar
  • 115
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 ...
Andy's user avatar
  • 45