Pavel Djundik
banner
xpaw.me
Pavel Djundik
@xpaw.me
Programmer, data miner, creator of @steamdb.info

🌍 https://xpaw.me
It's rather ironic that I haven't been getting ads on twitch for months (because no one buys ads here), and now all of a sudden they keep repeating an ad for twitch turbo promoting ad free viewing.
November 2, 2025 at 7:33 PM
the new steam controller 2 (triton) icon is just that, an icon.

don't worry it has a dpad, two sticks, and more buttons.
October 29, 2025 at 9:01 AM
It's currently not possible to view issues in the @github.com mobile app because they can't handle their own deprecations. Embarrassing.
October 21, 2025 at 10:12 AM
Valve confirms Ricochet 2 🫨

* This is basically a response to mod 'Team Fortress 2 Classic' steamcommunity.com/games/354506...
October 7, 2025 at 8:33 AM
@davidanson.bsky.social hey i hit your blog and some of the code blocks seem unreadable in dark theme here dlaa.me/blog/post/99...
October 3, 2025 at 4:36 PM
You can now browse anyone's owned games or wishlist on steamdb with all the filters.

It was partially possible before by specifying the accountid in the url, but now it's more obvious, and you can get to it from the calculator.
October 1, 2025 at 6:32 PM
Full code if you want to see: github.com/SteamDatabas...

My backend code generates the status and writes it to workers kv with rest api, it used to be served by my server and then cached by cf.
September 21, 2025 at 8:32 PM
I've got @cloudflare.social to sponsor Workers for steamstat.us, it's pretty cool.

The status json is stored in the KV, and I've now added SSR support, which means page load is faster and you can see the status without JS (rendering the canvas graphs still requires js though).
September 21, 2025 at 8:32 PM
I'm glad dhh is publicly talking about the overall complexity of modern development.

steamdb deploys from a git commit in under 2 seconds, it's really invaluable.
September 5, 2025 at 4:59 PM
New trademark for "Steam Frame" has been registered for new computer hardware

uspto.report/TM/99370857
September 3, 2025 at 7:36 PM
You should have a performance bar always available in production which has timings and logs all the individual queries.

This helps you find bottlenecks that need attention just while you're using the site.
September 2, 2025 at 10:09 AM
There's a reference to TF project in the source1import code, that means Valve are trying to import S1 assets into Source 2.

This is still assuming that TF actually means Team Fortress.

noticed by @gabefollower.com
August 25, 2025 at 10:53 AM
.@steamdb.info now tracks VPK archive contents across all games
August 22, 2025 at 1:48 PM
This picture is however not true, the screenshots section doesn't actually align like that.
August 16, 2025 at 10:43 AM
August 2, 2025 at 9:45 PM
Added two new rankings to SteamDB: daily active users and wishlist activity.

This data comes directly from the Steam API, so I don't exactly know what "wishlist activity" means.
Battlefield 6 is the #1 for upcoming games.

DAU: steamdb.info/stats/dailya...
Wishlists: steamdb.info/stats/wishli...
July 26, 2025 at 6:13 PM
New Source 2 Viewer release! Added an entity list to filter and jump to entities, export physics to glTF and a bunch of other goodies!

github.com/ValveResourc...
July 24, 2025 at 10:25 AM
When I paste text I copied I want it to look like this, and for Ctrl-Z to obviously be broken to not be able to revert it.

@github.com pls fix
July 21, 2025 at 9:17 AM
the font choice is not good
July 11, 2025 at 7:08 PM
Valve is preparing to display Counter-Strike 2 item float values in the Steam inventory

(TIL ecmascript explicitly allows HTML single line comments in JS)
July 11, 2025 at 8:11 AM
running mesa drivers on a windows in github actions to validate shaders is pretty cool
July 6, 2025 at 8:31 PM
I've successfully migrated @steamdb.info from InfluxDB to ClickHouse.

CPU and RAM usage is down, query times are faster. Quite impressed all around.

Thanks to influxdb for doing multiple incompatible rewrites for forcing me off it.
June 30, 2025 at 8:22 PM
June 9, 2025 at 9:08 PM
I ratholed into a bizzare issue where creating a file with emoji in it would crash Windows 11's explorer, and it's fixed by disabling the "UTF-8 support" in region settings.

This started out as a bug where I couldn't close an untitled file in VS Code that emojis written...
June 9, 2025 at 9:06 PM
I've expanded the theming to tables/titles/progress bars
June 6, 2025 at 1:32 PM