Page 1 of 1

ROM database

Posted: Tue Feb 10, 2009 7:01 am
by polaco
Hi,

I there any site or document with information on nes roms?
I see that nestopia works with a XML like database.. ?

I'm thinking into build an online query system, by fetching rom information using its CRC32. The emu executes a query on my server, which hosts a mysql database and PHP.

post yout opinion about it... :roll:

Posted: Tue Feb 10, 2009 10:09 am
by Coldberg
what about those without the internet ? :P and i'd opt for md5 instead of crc32

Posted: Tue Feb 10, 2009 10:37 am
by MatthewCallis
I'm more than half way done with something identical to this for Famicom and NES games, and I am still finishing up Super Nintendo games, though all Super Famicom games should be done:

http://superfamicom.org/

Posted: Tue Feb 10, 2009 1:37 pm
by mattmatteh
i have been using bootgods web page http://bootgod.dyndns.org:7777 but that seems to be offline at the moment. a single database package would be nice for any emu or rom checker to use.

Posted: Tue Feb 10, 2009 4:45 pm
by BootGod
It is back online now :) You can generate a Nestopia compatible XML with the DB client software. It will be a little while before I have the software back on line though.

Posted: Tue Feb 10, 2009 4:57 pm
by polaco
BootGod wrote:It is back online now :) You can generate a Nestopia compatible XML with the DB client software. It will be a little while before I have the software back on line though.
Awesome!! This would rock integrated with an emu!

My concept is almost this, the only missing feature is emulator compatibility :D
A nice looking form with cart info, emu compatibility, cheats.. etc.. (sorry for those without internet!!) and also, an option to report emulation errors, graphics glitches, sound problems, et all.

All this stuff coded into the emu interface. So if the user want to try a rom, they can check for compatibilty, cheats, etc..
When the user loads a rom, the emu automatically downloads the information and shows it.

Posted: Tue Feb 10, 2009 5:44 pm
by mattmatteh
BootGod wrote:... You can generate a Nestopia compatible XML with the DB client software. It will be a little while before I have the software back on line though.
is your software windows only ? i thought you said it was when i asked about it some time ago. if so that might be useless to some users :(

i have not seen the database file that nestopia uses. is this a good format ? perhaps have a standard file format for everyone and have it as a database package ? meaning the database can be updated independent of the emulator or what ever application.

matt

Posted: Tue Feb 10, 2009 5:47 pm
by mattmatteh
polaco has a good idea. but i think it might be better to have a separate database for cheats and one just for checksums and cart infomation. both could have all entries based on a checksum.

Posted: Tue Feb 10, 2009 6:06 pm
by polaco
mattmatteh wrote:polaco has a good idea. but i think it might be better to have a separate database for cheats and one just for checksums and cart infomation. both could have all entries based on a checksum.
Yup, emulation related stuff like reports or cheats would stay into a different table, or DB. I'm creating some tables for testing purposes... also, I'll create another table field, with emulator version. So its possible to filter information from which emulator version that game has a bug, or does not work... etc..

Posted: Tue Feb 10, 2009 6:23 pm
by BootGod
mattmatteh wrote:is your software windows only ? i thought you said it was when i asked about it some time ago. if so that might be useless to some users :(
Yeah it is, but in the future I will have a pre-compiled version that is updated weekly (or something) available for direct download on the site. That will solve that problem, and also the speed issues involved with generating it real-time.