The end of the ROMDB in openMSX? help needed

Por Vampier

Prophet (2405)

imagem de Vampier

10-10-2022, 20:19

the openMSX romdb in it's current form is close to 18 years old, the XML output is used for auto recognizing mapper types and gives openMSX feedback on what program/game is on the cart

During the last 2 years corruption has creeped up on the SQLLite database. I expect about 2~5% of corruption on the romdb which still is a lot considering that there are over 7000 entries.

Anyway - I don't feel like cleaning up the mess anymore or reprogramming the web interface to use another SQL solution. If anyone wants to take over the record keeping (adding/fixing of entries) let me know.

Entrar ou registrar-se para comentar

Por gdx

Enlighted (5992)

imagem de gdx

11-10-2022, 00:22

To bad. I hope someone will take up the torch. Otherwise, there is an alternative in yaml format here which could be interesting when it will be complete. This list was created for another reason but it could be used by openMSX or other projects.

Por Manuel

Ascended (19210)

imagem de Manuel

11-10-2022, 00:35

I guess the database can be rebuilt with the XML data that comes with openMSX.

Por Vampier

Prophet (2405)

imagem de Vampier

11-10-2022, 13:49

the xml data reflects the corruption already - comparing old SQLLite data to each other is easier.

Por Metalion

Paragon (1616)

imagem de Metalion

11-10-2022, 20:07

I seem to remember that someone, long ago, proposed for the mapper information to be included in the rom file. Just a header with a few bytes, containing the necessary information. Problem solved. The idea was simple and failproof.

And yet, I also remember that there was so much bickering and fighting about it, that it was dropped.
To this day, I still don't understand why we did not choose such a great idea.

Por Vampier

Prophet (2405)

imagem de Vampier

15-10-2022, 20:26

Por Vampier

Prophet (2405)

imagem de Vampier

09-11-2022, 22:36

Since no one seems to care about auto picking mappers for openMSX I declare this database as dead.

Por Manuel

Ascended (19210)

imagem de Manuel

09-11-2022, 23:17

Can you make clear what is wrong with the current XML file, so what is corrupted? Just a few examples would be enough to get an idea.

Por Vampier

Prophet (2405)

imagem de Vampier

13-01-2023, 03:37

All roms need to be verified - for some reason due to database corruption several ROMs ended up under the wrong title. Everything related to the ROM (mapper/sha1 etc) is correct except the title.