Game development - Data question

Adrian B

Hello, thanks for taking a quick read,

My current goal at the moment would be to develop a card game, (similar style to yu-gi-oh), with this style, there is many cards to pick from, and with each card, multiple stats, I.E, CardA may have 50 Attack, 20 Defense, 100 Health, and be worth 1000 Gold. That is simple enough to hard code write into a C# windows form application, using classes, but my overall goal would have 100+ of these cards. Entering each individual stat of each card seems... messy. I have been doing some reading on .XML files as a form of a database, as well as C# Databases and finally MySQL.

I am unfamiliar with all 3 database types and I've managed to become lost in the internet on what to read. I am hoping some one may be able to recommend some sort of database to me, so that I may focus and read more on that specific type, and be even more generous in giving a rough explanation and general use of each one. I'm currently using Visual Studio 2010 as an IDE.

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Adrian B14y ago
The data would be considered base attributes, so would not change. I would like to use only 1 table for all card types, however I believe it may be faster to separate it into 5 tables, 4 races, and 1 for cards that can be used with all races. From my reading it seems that XML is easier to work with, and SQLite requires a bit more work to have it working.

I am going to search around for a SQLite beginner tutorial, as I am very unfamiliar with it, if anyone has any they can recommend off the top of their head, will be greatly appreciated.

Thanks,
Adrian
Sam Hobbs14y ago
How often would the data cahnge and who would change it? If the data would only be changed by you then XML is likely a good choice. How many tables would be required? If there would be just one table then XML is likely a good choice. Otherwise it might be beneficial to use a database. How many applications would use the data? If only your game then perhaps SQLite is enough. Note that SQLite is used in many smartphones.