4 ms·

Anyone know of a project like this for video games? I got a spreadsheet I use to organize games I’ve played/am going to play and always looking for an easier wa

Anyone know of a project like this for video games? I got a spreadsheet I use to organize games I’ve played/am going to play and always looking for an easier way to get metadata. I was also looking at building something like Goodreads for video games and similarly that data would have been great.

corobo 6y ago
Depends on your use case but yes: https://www.giantbomb.com/api/ https://www.giantbomb.com/api/
Pet_Ant 6y ago
What about https://videogamegeek.com/ https://videogamegeek.com/ ?
- Cyph0n 6y ago
  I’m surprised I’ve never heard of this. Thanks for sharing.
  - jacobobryant 6y ago
    also rawg.io's api. I've used them in the past.
Xavdidtheshadow 6y ago
https://www.igdb.com/ https://www.igdb.com/ is the one! I do the same thing. I've got a great process built on Airtable + IGDB.
- khalilravanna 6y ago
  Operated by Twitch nice. Interesting they have a “Time To Beat” field but it’s not really populated. I also use Airtable and was thinking of writing a Zapier hook to scrape HowLongToBeat.com for this info. It’s one of my favorite stats to help prioritize what game to play next. I can’t be dumping 100 hours into JRPGs back to back lol.
  - Xavdidtheshadow 6y ago
    Yeah, I get that. It's all wiki based, so I guess folks aren't filling in that data. There's not an API directly, but https://www.howlongtobeatsteam.com https://www.howlongtobeatsteam.com looks promising. It's got an API that you can use to cache your (or all) games. Zapier might be able to do it as well w/ this scraper: https://www.npmjs.com/package/howlongtobeat https://www.npmjs.com/package/howlongtobeat (disclosure, I work at Zapier). I used to have a CLI that would trigger a Zapier webhook that would use [this CLI app](https://github.com/xavdid/zapier-igdb https://github.com/xavdid/zapier-igdb) to populate data into Airtable, but I actually moved the whole process to [Airtable Apps](https://airtable.com/marketplace https://airtable.com/marketplace) since I could customize the UI a little more. I've been meaning to open source it, but it's pretty customized so I'm not sure if it'd be widely useful. I'm curious to see where you end up with this though! It's something I've put a lot of thought into.
  - sellyme 6y ago
    > Interesting they have a “Time To Beat” field but it’s not really populated. Time to beat is a very difficult metric. Does a Visual Novel take 10 hours to beat, or 2 minutes? I'd argue the latter, but I know plenty of people would disagree with me. "Alright," says the webadmin, "I'll just implement a voting system and take the average". But now they'll be claiming that it takes 5 hours and 1 minute to beat, which everyone disagrees with. The best system I've seen is SteamHunters' "Shortest/Median/Average", which gives you a pretty reliable indicator of what's possible, what's typical, and how much of a difference there is between optimal and casual play, respectively. It's by far the most comprehensive dataset out there, but unfortunately only mono-platform so probably not too useful for sites like igdb.
desertcroc 6y ago
Have a look at grouvee. I've been using it for quite a while now and I believe is basically donationware.
WorldMaker 6y ago
What GOG is attempting with Galaxy 2.0 [0] is interesting in this department. Galaxy 2.0 has plugins to import what it can of games/achievements/play time from as many other vendors as it can and tries to show something of a view of every game across all your major services/accounts. Many of those plugins are open source, written in Python, though of course Galaxy 2.0 itself is not itself open source and it is still the primary installer/launcher for GOG's own service, if you are concerned about vendor control. There's a third party export script in Python as well [1], though it is reading JSON and SQLite files directly and not using an official API. [0] https://www.gog.com/galaxy https://www.gog.com/galaxy [1] https://github.com/AB1908/GOG-Galaxy-Export-Script https://github.com/AB1908/GOG-Galaxy-Export-Script

corobo 6y ago

Depends on your use case but yes: https://www.giantbomb.com/api/ https://www.giantbomb.com/api/

Pet_Ant 6y ago

What about https://videogamegeek.com/ https://videogamegeek.com/ ?

Cyph0n 6y ago
I’m surprised I’ve never heard of this. Thanks for sharing.
- jacobobryant 6y ago
  also rawg.io's api. I've used them in the past.

Xavdidtheshadow 6y ago

https://www.igdb.com/ https://www.igdb.com/ is the one! I do the same thing. I've got a great process built on Airtable + IGDB.

khalilravanna 6y ago
Operated by Twitch nice. Interesting they have a “Time To Beat” field but it’s not really populated. I also use Airtable and was thinking of writing a Zapier hook to scrape HowLongToBeat.com for this info. It’s one of my favorite stats to help prioritize what game to play next. I can’t be dumping 100 hours into JRPGs back to back lol.
- Xavdidtheshadow 6y ago
  Yeah, I get that. It's all wiki based, so I guess folks aren't filling in that data. There's not an API directly, but https://www.howlongtobeatsteam.com https://www.howlongtobeatsteam.com looks promising. It's got an API that you can use to cache your (or all) games. Zapier might be able to do it as well w/ this scraper: https://www.npmjs.com/package/howlongtobeat https://www.npmjs.com/package/howlongtobeat (disclosure, I work at Zapier). I used to have a CLI that would trigger a Zapier webhook that would use [this CLI app](https://github.com/xavdid/zapier-igdb https://github.com/xavdid/zapier-igdb) to populate data into Airtable, but I actually moved the whole process to [Airtable Apps](https://airtable.com/marketplace https://airtable.com/marketplace) since I could customize the UI a little more. I've been meaning to open source it, but it's pretty customized so I'm not sure if it'd be widely useful. I'm curious to see where you end up with this though! It's something I've put a lot of thought into.
- sellyme 6y ago
  > Interesting they have a “Time To Beat” field but it’s not really populated. Time to beat is a very difficult metric. Does a Visual Novel take 10 hours to beat, or 2 minutes? I'd argue the latter, but I know plenty of people would disagree with me. "Alright," says the webadmin, "I'll just implement a voting system and take the average". But now they'll be claiming that it takes 5 hours and 1 minute to beat, which everyone disagrees with. The best system I've seen is SteamHunters' "Shortest/Median/Average", which gives you a pretty reliable indicator of what's possible, what's typical, and how much of a difference there is between optimal and casual play, respectively. It's by far the most comprehensive dataset out there, but unfortunately only mono-platform so probably not too useful for sites like igdb.

desertcroc 6y ago

Have a look at grouvee. I've been using it for quite a while now and I believe is basically donationware.

WorldMaker 6y ago

What GOG is attempting with Galaxy 2.0 [0] is interesting in this department. Galaxy 2.0 has plugins to import what it can of games/achievements/play time from as many other vendors as it can and tries to show something of a view of every game across all your major services/accounts. Many of those plugins are open source, written in Python, though of course Galaxy 2.0 itself is not itself open source and it is still the primary installer/launcher for GOG's own service, if you are concerned about vendor control. There's a third party export script in Python as well [1], though it is reading JSON and SQLite files directly and not using an official API. [0] https://www.gog.com/galaxy https://www.gog.com/galaxy [1] https://github.com/AB1908/GOG-Galaxy-Export-Script https://github.com/AB1908/GOG-Galaxy-Export-Script