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

[1] https://github.com/AB1908/GOG-Galaxy-Export-Script

What about https://videogamegeek.com/ ?

I’m surprised I’ve never heard of this. Thanks for sharing.

also rawg.io's api. I've used them in the past.

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

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.

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 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 (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) to populate data into Airtable, but I actually moved the whole process to [Airtable Apps](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.

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

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

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