Tell me more ×
Game Development Stack Exchange is a question and answer site for professional and independent game developers. It's 100% free, no registration required.
up vote 0 down vote favorite
1

What database engine would be appropriate for an online multiplayer card game(with many different cards) done in Flash?

MyISAM seems to be the one because of full-text search and good read speeds, although it doesn't support foreign keys which my card database will heavily depend on.

share|improve this question
1  
As a side suggestion, try consulting with the stack overflow community. The number of DB gurus lurking there should be a tad higher than on this Q&A site (not that many game developers are involved in subtle DB design.. :) ). – teodron Aug 1 '12 at 23:12
"which tech to use" questions are off topic for the site: meta.gamedev.stackexchange.com/questions/695/… Plus to answer your specific questions I would imagine that you aren't providing enough information (budget, server infrastructure you're going to use, access patterns, db schema, etc) to really answer the question well other than "which one is your favorite". – Tetrad♦ Aug 2 '12 at 0:42

closed as not constructive by Tetrad♦ Aug 2 '12 at 0:42

As it currently stands, this question is not a good fit for our Q&A; format. We expect answers to be supported by facts, references, or specific expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, see the FAQ for guidance.

1 Answer

up vote 0 down vote

I really like PostgreSQL myself. On the one hand it seems like it might be overkill, on the other it does have a lot of features.

The main reason I'm suggesting it though is that it has a pretty open license, is well maintained, and has good documentation.

MySQL seems like another possibility, but Oracle isn't exactly the most trustworthy of companies. Who knows what they'll do with MySQL?

share|improve this answer
From his question, MyISAM is the older engine used by MySQL(versus InnoDB)... – XiaoChuan Yu Aug 2 '12 at 0:31
Ah. I'm not too familiar with MySQL myself. But if LittleJimmy already is using MySQL, learning PostgreSQL wouldn't be as hard. – xuincherguixe Aug 2 '12 at 0:46

Not the answer you're looking for? Browse other questions tagged or ask your own question.