Yo, I've been working on this database for a few months now, I figured I'd let you see it. So far it imports all the MDX files in the
neko68k collection. The MDX titles are converted to utf-8 and stored in a MySQL DB. The importer also extrapolates other data, as you can see:
http://mdx.vampi.techRight now the plan is to add a JS player, which will be possible due to the fact that I've written a
MDX player as part of mdxtools (currently in beta) and my plan is to compile that with emscripten.
However, I'll need help with the song data, I've started a spreadsheet here:
https://docs.google.com/spreadsheets/d/ ... sp=sharingand I'll need help filling in the track name, authors, date, company, type, product JP (original name), product EN and platform fields. Most of the data in there is extrapolated from directory names and MDX titles, some is hand-input.
As you can see in the site, MDX files are grouped in 'sets', and sets belong to a 'product'. Products can be games, anime, TV shows etc. Products have a list of releases.
Some interesting results of storing this data in a relational DB: I was easily able to find the most used FM voice, which is a nice FM bass. I was also able to find the most used PDX file, which is BOS.PDX (Bosconian). There are many more queries that can be made. I was thinking of adding a histogram of song releases per author, so we can see the time they were active. Generally the MDX scene lasted for 5 years, I think from '88 to '93 or something like that.
Anyway, have fun browsing those files, and if you'd like to help, please see the
get involved page.
_________________
Follow me on twitter.
If you like this post, give it a big thumbs up and hit that subscribe button down below! And as always, thanks for reading, and see you next post.