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.
38
votes
9answers
6k views
17
votes
4answers
2k views
noSQL - Is it a valid option for web based game?
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 ...
17
votes
6answers
665 views
Tweaking and Settings - Runtime variable modification and persistence
Most companies have an editor, or a variable control system for tweaking stuff in games, but are there any middleware solutions to this problem? I've written two such systems in the past myself, and ...
16
votes
6answers
2k 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 ...
11
votes
2answers
3k views
What is Minecraft's database?
I was wondering, what kind of database does Minecraft use? Is it a relational database, maybe something common like MySQL? Do we even know what he's using?
And maybe even a better question, SHOULD ...
10
votes
4answers
1k 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 ...
10
votes
11answers
946 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 ...
10
votes
4answers
2k views
How to choose how to store data?
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
- Chinese Proverb
I could ask what kind of data storage I should use for my actual project, ...
9
votes
5answers
1k views
Distributed C++ game server which use database
My C++ turn-based game server (which uses database) does not stand against current average amount of clients (players), so I want to expand it to multiple (more then one) amount of computers and ...
8
votes
4answers
2k views
Which Database (RDBMS vs NoSQL vs BOTH) to use for a Realtime Multiplayer Game?
I'm working on a realtime multiplayer game that will require a database (for features such as player profiles, friends, unlocks, news, etc.) This is a standard PC game (not browser-based) and will use ...
7
votes
4answers
437 views
Is there a way to make a dynamic world such as a MMORPG horizontally scalable?
Imagine a open-world of 500+ players with data changing as fast as 20 updates/player/second. Last time I worked in a similar MMORPG, it used SQL, so obvioulsy it couldn't query the DB all the time. ...
7
votes
5answers
571 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 ...
7
votes
1answer
124 views
Multilingual data bases for most common words and phrases used in games
Games tend to have easy to understand instructions/menus/tutorials and so on, so I was wondering whether...
Are there multilingual data bases, built-in with the most common phrases used in games?
...
6
votes
2answers
567 views
Using Google App Engine to Perform World Updates vs an Authoritative Server
I am considering different game server architectures that use GAE. The types of games I am considering are turn-based where the world status would need to be updated about once per minute.
I am ...
5
votes
4answers
775 views
Database structure for a trading cards video game (TCG)
Just started and after pondering with registered users' table everything came to a halt.
So far I've got:
+----------------------+
| tblUsers |
+----------------------+
| ...
5
votes
1answer
426 views
Strategy/City Builder browser game - technical details
I actually have multiple questions into one. Hopefully someone can hit all of them.
I wanted to give a try at a massively multiplayer web based game. Basically, the game would have similarities to ...
4
votes
2answers
506 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 ...
4
votes
1answer
200 views
Using heavyweight ORM implementation for light based games
I'm just about to engulf myself in an MVC-based/Component architecture in C#, using MySQL's connector/Net for the data storage, and probably some NHibernate/FluentNHibernate Object-relational-mapping ...
4
votes
2answers
996 views
RPG Monster-Area, Spawn, Loot table Design
I currently struggle with creating the database structure for my RPG.
I got so far:
tables:
area (id)
monster (id, area.id, monster.id, hp, attack, defense, name)
item (id, some other values)
loot ...
4
votes
2answers
276 views
game multiplayer service development
I'm currently working on a multiplayer game. I've looked at a number of multiplayer services(player.io, playphone, gamespy, and others) but nothing really hits the mark. They are missing features, ...
3
votes
2answers
550 views
Use a SQL Database for a Desktop Game
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++ ...
3
votes
3answers
342 views
Manager game questions
(Sorry about the bad title, it's the best I could come up with)
I've been planning a gladiator manager game for a while now. Something similar to Blood Bowl (or Football Manager, only with fighting ...
3
votes
2answers
205 views
Real time data retrieval - database vs file system
I'm planning to develop a game in which I want to draw 3d models in real time using some given x,y,z coordinates. The coordinates will be given at an average of 30 coordinates per second. Drawing will ...
3
votes
2answers
178 views
'Unblock' / 'Yellow Out' game questions
I would very much like to build a game that is known as 'Unblock' or 'Yellow Out'. It is a puzzle game in which the task is to move a car out of a parking space by moving other cars in certain ...
3
votes
2answers
269 views
C++ Database vs Reading Files
Ive been programing a C++ game/server for the past year. I have been using MYSQL for character logins, items, monsters, etc, etc. (im on windows). My question is, what are some of the databases that ...
3
votes
2answers
379 views
How should one design an analytics system for an online multiplayer game?
For my simple MMO, the MySQL database stores things like user experience, user level, user coins, health points, etc.
We wanna have an analytics system that can show me trends through daily ...
3
votes
3answers
719 views
Is a SQLite Database Suitable to Store the Building Blocks for Dynamic Content?
I am trying to make my own game for fun, it is basically a 2d side scrolling shooter, with dynamically generated enemies, levels, loot, and some other things. Currently I have dozens of XML files that ...
3
votes
3answers
435 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 ...
3
votes
1answer
339 views
Component System - Editor Data Management
I'm trying to construct an editor in C# that exposes game components to IronPython, so it may create the game object definitions to be used within the editor:
C# Exposes the components to the python ...
2
votes
5answers
418 views
Saving data in games?
I'm soon going to make a game for the iPhone as a school project.
My idea was to make a TLOZ remake, with Tiled Maps.
However, I'm not quite sure how save the data.
In TLOZ you have a lot of ...
2
votes
3answers
1k views
Facebook Game database design
I'm currently develop a facebook mafia like PHP game(of course, a light weight version), here is a simplify database(MySQL) of the game
id-a <int3> <for index>
uid ...
2
votes
2answers
78 views
web based quizz game database design, how do I store results? [closed]
I'm building a very basic quizz type of php/mysql/ajax game.
At this stage I'm thinking about the DB design, and specifically how to score results, I've two options in my mind. But cannot decide ...
2
votes
2answers
423 views
Crafting recipes: storage and quering
Consider 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;
...
2
votes
2answers
154 views
Integer vs String for “type” data in data-driven games
I've been developing a few mobile games, in which those games fetch their data from a server-database.
I'm used to storing "type" values as an integer identifier, and an enum in the client to ...
2
votes
2answers
324 views
jMonkey Quest Database
I am building a game in jMonkey (Java) and I have so far only used default quest text. But now I need to start populating a lot of quests with text. My design requires A LOT of quests texts.
What is ...
2
votes
2answers
66 views
Should many constants utilize constant variables or a database?
If you decide to design some sort of in-depth customization system for the player that utilizes a ton of different options, would you be better off using SQLite or just a whole bunch of constant ...
2
votes
2answers
78 views
Centralized User database for multiple Systems
I was wondering, how do large companies handle user accounts and allow different applications to access them.
One example that comes to mind is Riot, their game League of Legends has a global user ...
2
votes
3answers
218 views
How to store and update data table on client side (iOS MMO)
Currently I'm developing an iOS MMO game with cocos2d-x. The game depends on many data tables (Excel file) given by the designers. These tables contain data like how much gold/crystal will be cost ...
2
votes
2answers
435 views
How should I store a Game Database on Android?
I'm looking at creating a game for Android and while I have most of the ins and outs worked out, the one thing I'm struggling with is how to store data for the game.
Ultimately, the game will be ...
2
votes
4answers
679 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 ...
2
votes
2answers
313 views
Game Database Connectivity Java
I'm developing a simple multi-player puzzle game in Java. Both players should be able to view the same game board on his own computer. Then, when one player makes an action in the game (ex. drags an ...
2
votes
1answer
1k views
How do I implement a score database in Android?
I making a 2D game for Android using OpenGL-ES technology. It is a space shooting game where the player shoots enemy ships.
I want to keep a track of score for the amount of enemy ships destroyed ...
2
votes
1answer
443 views
Tools for creating an item database
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 ...
2
votes
1answer
455 views
MySQL - Storing Character Inventory
What is the best way of storing the character's inventory (consisting of each item having a value for type and quantity). The only methods I can think of is to use the "text" type of field then parse ...
2
votes
0answers
153 views
ECS, databases, XML and serialization
My entity/component/system engine is coming along quite nicely; I have two very different apps working on the same executable. (One 2-d scroller, one 3D Asteroids-type game).
In the interest of ...
1
vote
3answers
239 views
Best practice for saving items?
In a game that I'm working on, any player has (at max) 460 items within their inventory. Each item has simple attributes, such as owner and quantity, but equips have different attributes, such as ...
1
vote
1answer
306 views
SQL Database using Adobe Air
How do you create an SQL database (I believe it's tinySQL/SQLite) using Adobe Air? I have searched around, and all sites give code, and then explains to wrap it within an xml document, for example ...
1
vote
1answer
210 views
How can I keep track of a battle log on a web game?
Recently I started working on a Web turn-based PvP RPG game. Now I'm working on the battle system but I encountered some issues:
How can I keep track of everything that happens in the battle? It ...
1
vote
1answer
265 views
Implementing an online database
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 ...
1
vote
3answers
1k views
MySQL Recursive Query (kind of) help to determine tech tree prerequisites
I'm trying to figure out how to do what I can only call a recursive query (my knowledge of MySQL is extremely limited). The game I'm designing has a tech tree with items to research that will grant ...
