I’m pretty sure there’s must be a question like this around somewhere, but I couldn’t find it.
Anyway, I’m creating a web game in which I want to store the high-scores in a database. SQLite is obviously not option because it store on local file so it wont work on web player. I have a AWS account and I just created a DB MySQL instance on it and I want to know how to connect to it with a C# script.
Just search for something like “c# connect to mysql db” or just use http://bit.ly/14M5mPw Should be enough to get you connected unless I’m awfully wrong and there is something special about connecting to Amazon RDS
[edit] You might also want to check out http://www.xaprb.com/blog/2009/02/17/when-are-you-required-to-have-a-commercial-mysql-license/ (or the topic in general) as I’m not sure if you’re allowed to use MySQL without a license… (haven’t checked the details, I just recently stumbled across some post where someone mentioned that they might need a MySQL license for their project)
Hey ShadoX! Thanks for the answer. I found a way. Basically like a service. I have a Heroku app with some php file that to stuff with my MySQL db instance (in Heroku as well), those files “throw” the info as JSON and with URL callings (don’t know if that’t the right word) I catch the JSON object and decode with the JSONObject C# script by Matt Schoen, which you can find in the Unity Wiki.
Hope this can help somebody else!
I decided not to use Amazon RDS becase those “security group” things are a pain in the butt haha.