SQL for RPG Maker?

Hello! Is it possible to use SQL databases via Ruby for the usage of texts and sprites in RPG Maker?

Which SQL database editor could I use?

i dont think so, rpg maker is only compatible with ruby.

Yes, but Ruby has access to SQL-databases, right? That way a localization to another language would be super easy I guess.

Someone has experience with this? I feel kinda n00b.

No, Ruby does not natively handle SQL databases by itself -- in order to make use of SQL, a Ruby gem must be installed which provides some sort of native extension in order to interact with SQL in any meaningful way (whether that extension is a native library for MRI Ruby or a .jar for JRuby). RPG Maker does not support such native extensions.


Also, no. Just no. SQL is absolute overkill.

Take a look at RMX-OS. It handles SQL through the use of a Java server. What you will need to do then, is make the basic TCP/IP connection between the game and the java server (something that even has a tutorial: http://lthzelda.wordpress.com/2010/04/28/rm-4-tcp-sockets-in-rpg-maker-vx/).

And then, handle the SQL server through the java server.

Never say no. It's bad.

EDIT: There is probably a way to do it directly, but it would need some research. Or using a lot of Win32API. And of course, with Win32API there is always the option to make a custom DLL in C++ that resolves the querying with the server, and sends the necessary data between them.