Choosing a database

[KraHen]

Originally Posted by CptSky

MySQL Embedded Server will probably scale a lot better than SQLite.

True, but SQLite is really lightweight, I tend to use it a lot because of this for local data with game development, although client-side. I agree, MES would be a lot better for a large game server, but as far as CO private server database sizes go, SQLite IMO can be just fine. (Then again, you want to do stuff right, not fast for this kind of stuff).

[Hybris]

Originally Posted by Y u k i

My main problem is that every mob, every spawn, every item is one seperate ini. thats how I dumped the TQ Db...

I personnaly coded this in order to extract data from ini to SQL statement (will probably have to adapt it with your own database structure).

Having a database to store a bit of everything has several advantages, performance advantages (at loading but not only).
If you have to make a search in the database, it's also more efficient (for example load at need then store locally in some cache to avoid doing the dataloading again).

Also advantage using a database is for data integrity (if the database is properly structured) and also about synchronisation, the database system will handle each request to make it synchronous (the file will not) - I talk here about writings for sure.

For big data, I use MsSQL (Windows hosted so better on Windows languages like C#), MySQL (integrates well with Php and Python...and has the advantage to be multiplatform), Oracle (multiplatform, robust but expensive ^^).
For small data, I use SQLite and No-SQL or even the Oracle lite database which I can't remember the name...

[U2_Caparzo]

Originally Posted by Hybris

I personnaly coded this in order to extract data from ini to SQL statement (will probably have to adapt it with your own database structure).

Having a database to store a bit of everything has several advantages, performance advantages (at loading but not only).
If you have to make a search in the database, it's also more efficient (for example load at need then store locally in some cache to avoid doing the dataloading again).

Also advantage using a database is for data integrity (if the database is properly structured) and also about synchronisation, the database system will handle each request to make it synchronous (the file will not) - I talk here about writings for sure.

For big data, I use MsSQL (Windows hosted so better on Windows languages like C#), MySQL (integrates well with Php and Python...and has the advantage to be multiplatform), Oracle (multiplatform, robust but expensive ^^).
For small data, I use SQLite and No-SQL or even the Oracle lite database which I can't remember the name...

No offense, but this is a one year old thread, and you said basically what has been said (supporting more the "global" opinion).

PD: You could do a more reusable code in just a few lines
( + List<object> + string.Join )