1 Replies - 252 Views - Last Post: 19 March 2011 - 09:16 PM Rate Topic: -----

#1 batting  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 19-March 11

question : which database to choose?

Posted 19 March 2011 - 07:53 PM

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!

Is This A Good Question/Topic? 0
  • +

Replies To: question : which database to choose?

#2 Sergio Tapia  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 1252
  • View blog
  • Posts: 4,168
  • Joined: 27-January 10

Re: question : which database to choose?

Posted 19 March 2011 - 09:16 PM

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
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1