Ruby MYSQL?

[Ter13]

Now, I'm quite curious about this... As many commercial online (NOT ALWAYS AN MMORPG!) games (be it via rankings savefiles, etc.) uses a MYSQL driven server to store and access the data. As I'm looking into the Ruby language a little further and further these days, I wanted to know about RUBY/MYSQL. I've done a lot of work with PHPMYSQL, and I've worked a lot in C++, Java, and a lot of other engines.

I'm not a new user in this field at all.

I'm wondering what steps could be taken to make certain that the user can use the ruby MYSQL module, which may not be included in the RMXP bundle. Could I build an installer with my game that requires the user to install the latest version of RUBY, and the module itself, or is there another way to make certain that the users could do this?

Anyway, thanks in advance for any information that can be found on this topic.

 

[Exsharaen]

You might be able to, but isn't requiring user to install latest RUBY means the bigger your game installer size be? People will think twice to download your game if the size is more than 100 MB... Besides, if we had been be able to do so, there would be many scripts using database instead of text files.

Although it may be very tricky to do so, I think we can accomplish the same effect using text files.

 

[Ter13]

Of course, if you know much about MYSQL, you would never have said that. ;P

MYSQL can be accessed from a remote location, thus multiple servers could share the same data without wasting the server resources and waiting on transfers.

It also accounts for read/write collisions, and prevents them. Plus, it makes website integration with your game seamless.

Then again, you are right, it can all be done with text files. Just TONNES of work... Ah well, back to marshalling all my data again... >_<