[batting]

hi , i am vishnukumar. I am developing a text based cricket simulation game. I have a problem in choosing a database. my friend is suggesting me to go for embedded database(sql lite) , so it will be easy for me when i release the game for others to download. but i want to go for mysql.


which one to choose? sql lite or mysql?

also i have not worked with sql lite. so , guide me to any tutorial if your answer is sql lite.


thanks!

[Sergio Tapia]

It depends on how you expect your application to be used.

SQLite doesn't work well with lots of concurrent access. It causes errors when people try to access information at the same time. I had this error come back and bite me in the ass once when I launched a school application in production.

I ended up using MSSQL Express 2008. It let's you use unlimited databases, of maximum size 10Gb which is a lot.

For more information, read here:
http://www.sqlite.org/whentouse.html