ROM database

polaco · Post by **polaco** » Tue Feb 10, 2009 7:01 am

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...

Coldberg · Post by **Coldberg** » Tue Feb 10, 2009 10:09 am

what about those without the internet ?

and i'd opt for md5 instead of crc32

MatthewCallis · Post by **MatthewCallis** » Tue Feb 10, 2009 10:37 am

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/

mattmatteh · Post by **mattmatteh** » Tue Feb 10, 2009 1:37 pm

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.

BootGod · Post by **BootGod** » Tue Feb 10, 2009 4:45 pm

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.

polaco · Post by **polaco** » Tue Feb 10, 2009 4:57 pm

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

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.

mattmatteh · Post by **mattmatteh** » Tue Feb 10, 2009 5:44 pm

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

mattmatteh · Post by **mattmatteh** » Tue Feb 10, 2009 5:47 pm

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.

polaco · Post by **polaco** » Tue Feb 10, 2009 6:06 pm

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..

BootGod · Post by **BootGod** » Tue Feb 10, 2009 6:23 pm

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.