VGCollect Forum
VGCollect Site Stuff => Video Game Database Discussion => Topic started by: LividChihuahua on December 21, 2014, 09:17:48 pm
-
I'm interested in collecting a subset of games for the PS1 (and maybe other system eventually, but I want to start there), specifically games that were exclusive to the system. I've had a hard time finding a list of PS1 exclusives online with the only close result being on wikipedia (although it seems limited to games they have pages on, which misses quite a few). Manually searching on each game would take a long time and I'd probably miss something along the way.
If however I had a copy of the game DB that has been created and curated by users here I could write a script to cross reference each PS1 game and find the ones that are on no other platform. This could also be done by writing a script to search the site over and over again, but that seems like a poor way to do it (not only because it would be slower but because it could potentially cause a lot of traffic in a short period of time).
I'm only interested in the games, not user collections, and I could use any file I could get (I'm just going to guess it's a MySQL database, but another format, even a CSV, would work). I figure that the data is probably locked away, but figured I'd ask since it would make my goal a a lot easier.
-
This would be pretty cool as currently the most complete lists I can find are on wikipedia and those are varied in quality and completeness.
-
A slightly harder solution could be, put all of the ps1 games in your collection, and then you can export them in a csv file.
-
A slightly harder solution could be, put all of the ps1 games in your collection, and then you can export them in a csv file.
I'm not looking for a list of PS1 games, thats easy to find, I'm looking for a list of PS1 exclusive games. The only idea I have to create such a list now would be to search the site for every PS1 game and check if there are any results for a different platform.
-
Unfortunately, the database doesn't mark which ones are exclusive, so I don't think there's a way to export a list when we don't have a field for it :/
-
Another challenge would be games that were released cross-platform but named uniquely for each platform. It didn't happen often but it did happen.
-
Unfortunately, the database doesn't mark which ones are exclusive, so I don't think there's a way to export a list when we don't have a field for it :/
Thats why I would like the entire list of games occross all platforms, I can write a script to do the referencing myself
Another challenge would be games that were released cross-platform but named uniquely for each platform. It didn't happen often but it did happen.
I thought of this and am not to worried about it, since I'm only collecting NA releases it shouldn't be a problem. Hopefully once I have a shorter list any questions regarding it I can research on a game by game basis.
-
Unfortunately, the database doesn't mark which ones are exclusive, so I don't think there's a way to export a list when we don't have a field for it :/
Thats why I would like the entire list of games occross all platforms, I can write a script to do the referencing myself
Another challenge would be games that were released cross-platform but named uniquely for each platform. It didn't happen often but it did happen.
I thought of this and am not to worried about it, since I'm only collecting NA releases it shouldn't be a problem. Hopefully once I have a shorter list any questions regarding it I can research on a game by game basis.
Ah, I see - well, it'd probably be Matt who'd have to help you out, so your best bet would be to email or PM him directly. The only thing I can see would be an issue is that he'd basically be giving away all of his community members' work, if you know what I mean...
-
Unfortunately, the database doesn't mark which ones are exclusive, so I don't think there's a way to export a list when we don't have a field for it :/
Thats why I would like the entire list of games occross all platforms, I can write a script to do the referencing myself
Another challenge would be games that were released cross-platform but named uniquely for each platform. It didn't happen often but it did happen.
I thought of this and am not to worried about it, since I'm only collecting NA releases it shouldn't be a problem. Hopefully once I have a shorter list any questions regarding it I can research on a game by game basis.
Ah, I see - well, it'd probably be Matt who'd have to help you out, so your best bet would be to email or PM him directly. The only thing I can see would be an issue is that he'd basically be giving away all of his community members' work, if you know what I mean...
Yeah and thats why I figure it would be locked away, I'll send him a PM and see if we can part with a copy.