4 ms·

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.

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.