Questions tagged [sql]
Structured Query Language. A programming language designed for managing databases.
48 questions
0
votes
2
answers
906
views
Godot 4 Static Storage Handling
I have a project that will have a significant amount of item/entity data. Imagine something like a survival game that will have items being dropped that can be used in recipes and building. There will ...
- 101
1
vote
0
answers
47
views
Database or arrays
Generally for an RPG, would you say a DB like SQL server and MYSQL is over kill? RDB seems really convenient to pull and call from an inventory item for example, yet I see arguments that it is too ...
- 11
0
votes
2
answers
425
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
1
vote
1
answer
275
views
How would you implement a map system like WoW?
I'm really struggling with a 'resonable' technical implementation of the map system used by the popular MMO World of Warcraft. Not really sure on a data structure format and how to save/store it in a ...
- 13
0
votes
1
answer
970
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
617
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 ...
0
votes
0
answers
166
views
How important is it to use an in-memory datastore for real-time networked game data?
I am building some online multi-player web-based games. Naturally, we are using WebSockets to connect to the game server. I need to store "real-time" data for these games, things like which ...
- 887
1
vote
0
answers
2k
views
Reading from Streaming Assets in WebGL
I'm trying to set up my Unity game for WebGL, but I quickly found out that you can't access your streaming assets as you would in a standalone build. For example, I have a code snippet below of how I ...
- 123
0
votes
1
answer
295
views
MMO Chat system methods
I'm working on a little MMO game as a learning experience, the server coded in Python.
When a player logs in it pulls their character data from a SQL db and into server memory. It then uses memory ...
- 117
0
votes
1
answer
126
views
Separate data tables for different item types?
I have two types of items in my game, consumables, and equipment. For my database, should I store them in two different tables, or all in one big items table?
- 123
31
votes
5
answers
21k
views
How does mmorpg store data?
I want to use sql database in my server.exe.
lets say 1000 users online. And players will change their data when they play. And server need to save these updates.
But how ?
i think there two way:
...
- 555
0
votes
0
answers
61
views
How can I give to player points with ajax but secured? [duplicate]
I have a virtual world game that I developed with jQuery, AJAX and PHP. Virutal World like club penguin. Now, I want to add a game into the virtual world - like bubbles or whatever. The main problem ...
- 1
0
votes
2
answers
1k
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'...
- 21
1
vote
1
answer
874
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 ...
- 111
0
votes
1
answer
142
views
Online Tower Defense : Problem in protecting user's data [closed]
Sorry about the question heading
I am creating an online tower defense game with SQL Server 2008 as my database.
SQL user used to send data to server is restricted to only execute existing ...
- 493
2
votes
1
answer
288
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
1
answer
4k
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 ...
- 1,969
0
votes
1
answer
345
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 ...
- 23
0
votes
1
answer
377
views
ASP.NET Browser game Timers
I am developing a simple browser game, using ASP.NET, C# and SQL Server 2012.
I need to implement build time of some unit or building. One way would be storing finish date to database and just fetch ...
- 3
2
votes
0
answers
558
views
Battle Engine for Text based browser game [closed]
I am starting to code a browser game, I have a rudimentary chat set up, and would like to start creating the battle engine, I have a general idea of how I want it to play out, but I don't know where I ...
- 125
2
votes
2
answers
1k
views
Best practice to implement persistent data when using Tiled TMX map files?
A friend of mine and I are always talking about our current progress in learning game development. Recently, saving the game (data persistence) came up, and when I summarized how I tackled that for my ...
- 53
3
votes
1
answer
298
views
Conversation tree and question locking/unlocking
I have been having issues with managing a conversation tree. I am using PAWN as a scripting language (I have no other options, unfortunately) and I use MySQL databases to store user and game data.
My ...
- 31
0
votes
1
answer
2k
views
Saving and retrieving high-score data in XNA 4.0 [closed]
I made a game in XNA 4.0 and now I need to save the points in a database or in a file (or in something else). My goal is to store and retrieve the highest score if I choose that option in the main ...
- 113
1
vote
4
answers
408
views
Save "Explored Area" to SQL Database
For a strategy game, the area "already explored" has to be saved to a DB, so that the player can (upon resuming his game) see where he has already been.
The game will be a mmo-game, so i have to ...
- 113
3
votes
2
answers
2k
views
Alternatives to storing all my entities in an SQL database
I've been trying to build my entity system based on pure SQL data storage as explained in this post series. The idea is that every entity or component is stored in an SQL table. I created my framework ...
- 930
2
votes
2
answers
757
views
Unlimited inventory system?
I am working on a small game, I need to add an unlimited inventory to the game but I am not sure how to do it.
I have an inventory system with a specific amount of slots, here it is:
...
- 31
6
votes
3
answers
858
views
Mismatch of Entity System and Savegames
There is a theoretical mismatch of the entity system and the savegame system, which is think is common, but I haven't found resources about that. Therefore I will explain both systems first, as short ...
- 5,751
0
votes
2
answers
224
views
multi user web game with scheduled processing?
I have an idea for a game which I am in the process of designing, but I am struggling to establish if the way I plan to implement it is possible.
The game is a text based sports management ...
- 1
4
votes
3
answers
291
views
Labeling Areas on a map
I've been wondering how you would go about labeling an area on a 2D tile map. What I'd like to do is associate tiles with an area i.e Forest Area, Desert Area, etc.
Keep in mind this is an idea, so ...
- 141
7
votes
3
answers
4k
views
Actually utilizing relational databases for entity systems
Recently I was researching several entity systems and obviously I came across T=Machine's fantastic articles on the subject. In Part 5 of the series the author uses a relational schema to explain how ...
- 1,007
0
votes
2
answers
2k
views
Integrating SQLite to Cocos2d-x at Xcode
I have downloaded SQLite C/C++ interface to work with Cocos2d-x. Created a database by Firefox SQLite plugin. Then tried the following code
...
- 2,867
2
votes
2
answers
381
views
Convenience of mySQL over xml
Currently I use XML to store specific information to correctly load a few things such as a list of specfied characters, scenes and music, Once more I use JAXB in combination with standard compression/...
- 133
1
vote
1
answer
722
views
Multiplayer (Database, Users,etc) for game
I'm am looking to add multiplayer into my game (2D Platformer in XNA C#) My worlds are quite large (Up to 30 Million tiles max, Average 20 million maybe. 2000x10000). You could say the game is quite ...
- 1,039
-3
votes
1
answer
115
views
Why would selecting a lot of rows crash my game? [closed]
I have a databse that contains:
id , playlistname , playlistnum
and I want to get alll the rows where ...
- 111
2
votes
2
answers
4k
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 ...
- 123
0
votes
1
answer
105
views
Build / Destroy function design & security checks
I'm working on a browser based strategy game. For the moment I'm working on the build/destroy functions and I have a couple of questions about this. The main question is do you have advice on how I ...
- 155
-1
votes
1
answer
196
views
0
votes
2
answers
501
views
Game resources storing
I'm working on a browser-based RTS, and we are targeting 10k+ users with multiple towns per user.
I have the following table townresources in which I store every ...
1
vote
1
answer
831
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 ...
- 431
-1
votes
2
answers
1k
views
Multiplayer game over internet
How to construct my multilayer mode for my Delphi game? For LAN I use UDP server/client. But for internet I think UDP is useless.
I have in mind something like:
The host create SQL database and store ...
- 147
5
votes
1
answer
1k
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 ...
- 153
1
vote
1
answer
350
views
Need Feedback for PHP & MySQL Saving Game Progress
My team is planning to create a simulation game using Javascript, CodeIgniter and MySQL for the backend.
It will be mostly click based, ie: There will be buttons for activities like Eat, Play, Study, ...
- 113
-2
votes
1
answer
3k
views
Browser Game Database structure
users
id
username
password
email
userlevel
characters
id
userid
level
strength
exp
max_exp
map
id
x
y
This is what I have so far. I want to be able to implement ...
- 101
1
vote
3
answers
2k
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 ...
- 113
0
votes
1
answer
1k
views
SQl, noSQL, and Doctrine with Symfony 2.0
I've had the idea of creating a webgame for a while now, and as it becomes more and more accurate i started playing around with Symfony 2.0.
First question :
it seems that it is recommanded to use ...
-1
votes
1
answer
1k
views
Database for increased scalability in a mmorpg? [closed]
I am planning a simple MMORPG, but even though it's a small, open source project, I'd like to have the best quality database. Which would be the best database software to use?
Examples:
SQL - MySQL, ...
- 131
4
votes
3
answers
8k
views
Using SQL for a Realtime Multiplayer Game Server's Working Data (Fast Enough?)
The game I'm working on currently has a Client in Flash AS3, and a Server in C# (multithreaded).
Currently I use mySQL to handle logins (Raw access: no middleman for accessing the database) which ...
- 739
7
votes
1
answer
5k
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 ...
- 235