1,105,636 Community Members

[ASK]Which database/saving system should i use in game?

Member Avatar
neartoyou
Newbie Poster
12 posts since Feb 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Forgive me if this thread was repost. :(

I am a novice in database system for game development.
Can Mr./Mrs. (Master) in here give me an example of a saving system for game? or it just use a database?(Like SQL?):idea:
Like a feature for "Save the Games" and sometimes the player can "Continue" or "Load games".

I imagine the database will store data for the game like level, exp., skill, coordinates, items, etc. ;)

Thankyou for the reply :) I'm really appreciate it :)
(I'm sorry if my english not good :()

Member Avatar
Sodabread
Posting Whiz in Training
287 posts since Nov 2009
Reputation Points: 88 [?]
Q&As Helped to Solve: 44 [?]
Skill Endorsements: 0 [?]
 
1
 

The answers, as always, is: it depends. Databases are often times best with online/browser based games, but Flash, I believe, can write save files to the computer on which it's being played. I don't work with Flash, so I'm not 100%.

In single-player, offline games a save file would probably be the best, as you don't really want to install a database instance for your game. I can't say I'd be ok with someone installing SQL on my machine just to save a game. Although, you can do a persistent/occasional network connection (which puts it in the online game category) in order to write the data to a database on your end.

Figure out what you want your game to be and how the player should be able to play it and you'll most likely have your answer.

Member Avatar
gusano79
Practically a Posting Shark
816 posts since May 2004
Reputation Points: 203 [?]
Q&As Helped to Solve: 131 [?]
Skill Endorsements: 10 [?]
 
0
 

If you prefer a database, but need an offline save file, and don't want to install a database server, you might look at SQLite.

Member Avatar
neartoyou
Newbie Poster
12 posts since Feb 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

The answers, as always, is: it depends. Databases are often times best with online/browser based games, but Flash, I believe, can write save files to the computer on which it's being played. I don't work with Flash, so I'm not 100%.

In single-player, offline games a save file would probably be the best, as you don't really want to install a database instance for your game. I can't say I'd be ok with someone installing SQL on my machine just to save a game. Although, you can do a persistent/occasional network connection (which puts it in the online game category) in order to write the data to a database on your end.

Figure out what you want your game to be and how the player should be able to play it and you'll most likely have your answer.

How about if offline games? which database you choose? :)

Member Avatar
neartoyou
Newbie Poster
12 posts since Feb 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

If you prefer a database, but need an offline save file, and don't want to install a database server, you might look at SQLite.

May i distribute it? and how it works?

thx :)

Member Avatar
gusano79
Practically a Posting Shark
816 posts since May 2004
Reputation Points: 203 [?]
Q&As Helped to Solve: 131 [?]
Skill Endorsements: 10 [?]
 
0
 

May i distribute it? and how it works?

SQLite is public domain, so do what you want, including distribute it.

It's a C/C++ library, although you can find bindings to other languages if you look for them. There's a C-function API for managing the database files, and you write almost-standard SQL queries for data access.

Member Avatar
neartoyou
Newbie Poster
12 posts since Feb 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

SQLite is public domain, so do what you want, including distribute it.

It's a C/C++ library, although you can find bindings to other languages if you look for them. There's a C-function API for managing the database files, and you write almost-standard SQL queries for data access.

Thx a lot! :D

Member Avatar
neartoyou
Newbie Poster
12 posts since Feb 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

SQLite is public domain, so do what you want, including distribute it.

It's a C/C++ library, although you can find bindings to other languages if you look for them. There's a C-function API for managing the database files, and you write almost-standard SQL queries for data access.

Thx a lot! :D I'm on learning SQLite..

Question Answered as of 2 Years Ago by gusano79 and Sodabread
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: