I am looking for suggestions on game databases. This is to be a database on the local machine to store game information, but i'm opposed to having to install a sql server on the local machine. I think mySQL and mySQL++ would be great but i'm not sure if you could do it (without making big changes to mysql) since i want it to be more of a game starts ->loads dbase ->game runs->game ends->unloads dbase flat fles are not really feasible in this. So i'm looking for general ideas, possible solutions and possible packages/api's ect to use . thx, LittleGiant

It's very easy to use mySQL in your:

game starts ->loads dbase ->game runs->game ends->unloads dbase

If you don't want to install a database server you can use sqlite.

I know you said you were opposed to flat files, but I would consider using an XML file.

There are many APIs out there that access XML files as if they are databases... and if you use .Net then your laughing because it's a one-stop shop for xml goodness.

Word of caution - careful not to make things more complicated then they need to be - get something working and if you can see that an xml file / inifile won't do for whatever reason - THEN investigate alternatives.

i 2nd sqlite
there is even a very easy to use c++ wraper for it.

C++ Wraper
http://www.codeproject.com/database/CppSQLite.asp

SQLites webpage
http://www.sqlite.org/

Silent Storm uses SQL in it's game databases, but only requires any sort of SQL server be set up if you plan on modding the game.

Third vote for SQLite, I've used it in two of my projects, and it met my needs very well.

Thx for everyones ideas!

I had looked for something like SQLite to no avail, thanks so much for bringing it to my attention, looks like it fits the bill quite nicely.

I'm gonna go ahead and start working with it, i'll be back if it usddenly has some huge lacking but looks great so far!

Thx, Again!
LittleGiant

That SQL Lite thing looks pretty impressive - got a great feature set and has a non-restrictive licence. Good find!