Taret Blade Development Diary - Chapter 3: Databaserie
Okay, I lied. This one is not about which technique to use. This is about my custom database.
So anyway, I started playing around with Microsoft Access, and realized that since it could output in XML, I could pretty easily just use Ruby's REXML script to convert the XML into a a Ruby object, then marshall it out into a database file like those in the "Project/Data/" directory.
This trick requires using Ruby, and not just RGSS, but luckily REXML is an extremely intuitive little class. This is a lot easier than my old way of doing it, but it still takes a bit of time, since I've got to set up the databases in Access, then add a routine to my "xml.rb" script to convert it. On the other hand, once I've got the converter up, it's really only two steps to update the thing (output the XML, then run the script), which isn't bad at all.