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

[kuadran45]

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 :()

[Sodabread]

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.

[gusano79]

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 .

[kuadran45]

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? :)

[kuadran45]

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 :)

[gusano79]

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.

[kuadran45]

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

[kuadran45]

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..