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.
0
votes
1answer
29 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 ...
0
votes
0answers
61 views
Storing 3d Objects file in database [on hold]
My company decided to automate some of the manual working and we are willing to store 3D objects in a database. I checked different links and found that the BLOB data type can be used to store ...
1
vote
1answer
44 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
33 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
63 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
73 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
96 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 ...
-3
votes
3answers
137 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
69 views
Inventory Table efficiency
I am thinking of code some sort of inventory system for a MMORPG game that can possibly contain massive number of player(~20.000). Is it smart to make a InventoryTable that contains each row only one ...
0
votes
1answer
128 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 ...
0
votes
0answers
82 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
11 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
354 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
54 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
53 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
50 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
366 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,...
3
votes
1answer
91 views
How do I get data from a WWW object without freezing my game?
I am using Unity 3d to create a real time multiplayer game. I have a database set up that keeps track of player statistics and what in app purchases they have purchased. I have written a Database ...
0
votes
2answers
494 views
Backend for data-driven multiplayer game
I am working on a match-based (5v5) multiplayer steam game that is similar to TF2, LoL, Dota 2, etc.
I am planning a data-driven approach where character/abilities/items/etc are defined in data (JSON)...
0
votes
0answers
497 views
Save and retrieve image from database in unity
I have done a sample to insert and retrieve data from MySQL in unity.Now I need to insert and retrieve image from MYSQL in unity. The images are files selected by the user from their filesystem.
Can ...
0
votes
1answer
632 views
Accessing a database with a php script from Unity mobile game
So I am attempting to keep track of some user data in my game that I am creating in Unity 3d. I am using Unity's WWW class to do this. I am following this tutorial: http://wiki.unity3d.com/index.php?...
2
votes
1answer
314 views
How should I implement a timer in a strategy game?
I'm developing a real strategy game for Android and want to implement timers. Those timers will represent the time remaining until some building is finished.
Say that i have a building in ...
0
votes
3answers
315 views
Database works on unity editor,but not on android device
I am working on database connectivity in unity.When I run my project I am able to access my database(retrieving and inserting data into database).But the problem is that when I take the android out ...
0
votes
0answers
59 views
storing hexagon-based (x/y) movements in a database
Im developing a hex(agon)-grid based game. The game is turn-based.
Players move stuff on the map and they need to be allowed to issue movement-orders. Units move a certain amount of movement-points ...
1
vote
2answers
467 views
Modeling an inventory system in SQL
I'm working on a multiplayer game played through the browser. It's not a real-time game which is why I decided to go with a database, however I'm pretty weak with SQL and starting to run into ...
1
vote
0answers
102 views
Need to find a web database of german words for taboo game [closed]
I am looking for a web database of german words like this in english. Anyone knows sth about this? I develop the game based on such database of words, so this is why I asked about this here.
15
votes
3answers
3k views
Should I use a database for storing game content? [closed]
I have a 2D Game written in C++ using SFML. I want to make the game expandable in such a way that content like items or entities could easily be added by adding a line/entry/row to a file or database....
0
votes
0answers
61 views
Proper method of writing XML File data into a class array?
So I have 3 objects, The Main world class that is meant to hold all global data and do some mild file manipulation, the biome class that is meant to be syntax for creating biomes, and the XML file ...
1
vote
1answer
517 views
Is Google's Protocol Buffer viable for the serialisation of game data? [closed]
Simple yes it is suitable, no it is not suitable for communications between game clients and/or server clients. Also is it suitable for serialising and storing game data or is a more customisable, ...
1
vote
2answers
218 views
How is persistence managed by browser games?
I was wondering,
when you play browser games you never seem to witness a page refresh, even if there is data being stored on the server. So how are databases handled by browser games.
In my opinion ...
2
votes
1answer
94 views
Android native database organization
I am developing an Android native game, but I have problems with Data Storage.
For a better comprehension think it like as i am developing Clash of Clans, but with Native Andorid.
Now imagine I have ...
1
vote
1answer
336 views
Embed a real city in a game and use data to find and display paths [closed]
First of all this question is gigantic but it's mainly about Unity, maps, pathfinding, and real data.
The problem.
In my game the player sees the map of a real city (in 2D), it’s exactly the same ...
1
vote
1answer
378 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 ...
3
votes
1answer
731 views
Libgdx Networking (http requests) - Login [duplicate]
I am new to Networking and Databases,
but im trying to learn MySQL and HTTP Requests to create a
user Login for a game.
My goal is to let users create accounts and login to them etc (for Highscores ...
0
votes
1answer
52 views
SQLite Query from unknown table based on known column value single query
I'm working on a database to back up my online TCG. It's currently SQLite, but I'm going to transition it to a MySQL database later.
Currently, I have three distinct types of cards with their own ...
1
vote
2answers
142 views
Using hard coded values for Items?
Is it a bad idea to use hard coded values for things like items (static data) that would change infrequently in an online game? I'm designing an online game in node js, and I'm trying to decide if it ...
0
votes
3answers
683 views
database structure for rpg items
I am currently developing a multiplayer html5 game, and the game has rpg elements (levels, items and such)
I just started working on the database side of things, and now I have a mongodb server setup ...
-1
votes
2answers
87 views
How to make a proper cache on user computer?
Currently when launching the client of the game, it connects to the server and loads all the cachedata in a normal form (= folders, .txt files and .png files). However I don't like that the players ...
2
votes
2answers
4k 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 ...
0
votes
1answer
356 views
Handling an item database with procedurally generated items?
Let's say you have an item database which has every item in your game.
This works fine for regular items like a Health Potion, a normal Iron Sword etc, because these items have ItemID's so we can get ...
1
vote
2answers
766 views
Keeping high scores on Unity web player
I want the player to be able to save his score when she makes it into top 10 of high scores. Upon success, player will be asked for a name to submit. This does not need to be unique per player. I just ...
0
votes
1answer
680 views
Is it possible to create sqlite database only for android in LIBGDX game? [closed]
I want to know if I can just implement sqlite database for android in libgdx game?
Also if this is not possible then may I know the simple way to integrate libgdx game to just store scores in sqlite ...
0
votes
2answers
184 views
I want to show total time spent by all players around the world in my game
I am developing a Unity3D game. I want to show in my game:
Total time spent playing all time by all players around the world
Total time spent playing in last 24 hours by all players around the world
...
39
votes
9answers
12k views
Why is it bad to hard-code content?
I know most games store dialogue text in files, but I've also seen a few text-based games actually program the content (map, choices, possible player commands, story text) into the game code.
I can ...
2
votes
2answers
280 views
Processing periodical operations on the database [duplicate]
I program MMO strategy game (C# monogame) like Goodgame Empire or Travian for Windows Phone.
The server part of the game will run on Windows Server and MS SQL database.
I'm trying to figure out a ...
2
votes
1answer
380 views
Handling 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 program it in C# Monogame (because I have some good experiance with it).
But I still can't figure ...
1
vote
1answer
576 views
how to store game state for a multiplayer board game eg. poker
First Approach: Store the state in database and play with database queries. Could a database handle the load, as poker is quite fast paced, and I have to query/update database for each player move.
...
0
votes
2answers
350 views
“Game Property Values” for online game on Database or somewhere else? [closed]
I'm working on a online game but,
what would be the best way to store values like damage,movespeed,turnrate, and so on.. ?
My answer would be, to store them in a Database, so they can easily be ...
0
votes
1answer
829 views
HTML5 canvas multiplayer game with node.js and Isogenic engine [closed]
I want to create a multiplayer game using Isogenic engine i understand that this technology uses html5 and canvas for rendering graphics in frontend and node.js for backend. I started working on how ...
1
vote
1answer
268 views
How can I can I reduce the write load on a database for an MMO?
I am considering using MySQL as a database for storing the character states or the world for that matter.
The thing is if I will save the character data on an interval, thus giving rest to the mysql ...
