Game Development Community

Databases

by Daniel Brown · in Technical Issues · 04/06/2004 (10:18 am) · 1 replies

Hi all,

Im creating an online rpg, but im going to need a database to store character details, inventory,last location,etc. But what sort of database should i use? and where would i need to implement it? engine or script?

Thanks

#1
04/06/2004 (12:32 pm)
The database "brand" is totally up to your needs. Do you need transactional support? Backup while the RDBMS is running? Clustering?

If your needs are basic, then I can recommend mysql. Its quite easy to install+use and has 95% of the features you will ever need.

The connection to the database is done in "real" code -> engine. Someone recently posted a resource with mysql connectors to the engine. Look here: www.garagegames.com/index.php?sec=mg&mod=resource&page=view&qid=5286

Databases are a topic on their own, and I can strongly recommend you to buy a dummy guide to SQL and database design. It is NOT easy, and you will make lots of mistakes if you do not read your theory first on proper relational database design.