Pavel Djundik's Avatar

Pavel Djundik

@xpaw.me.bsky.social

Programmer, data miner, creator of @steamdb.info 🌍 https://xpaw.me

3,536 Followers  |  98 Following  |  225 Posts  |  Joined: 19.09.2023  |  1.9484

Latest posts by xpaw.me on Bluesky

A lot of the search results are SEO/AI generated slop so it's hard to find real posts either way.

05.08.2025 11:59 β€” πŸ‘ 3    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Post image 02.08.2025 21:45 β€” πŸ‘ 31    πŸ” 3    πŸ’¬ 0    πŸ“Œ 0

Well it's showing whatever Steam returns. I think they skip games hidden from the store.

27.07.2025 17:49 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Post image Post image

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

26.07.2025 18:13 β€” πŸ‘ 87    πŸ” 4    πŸ’¬ 1    πŸ“Œ 0
Video thumbnail

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

24.07.2025 10:25 β€” πŸ‘ 24    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

There's also same thing for swf2js, so it's not a random word for sure. Compromised WordPress?

23.07.2025 15:25 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Slop is going to be word of the year, isn't it?

21.07.2025 14:20 β€” πŸ‘ 33    πŸ” 0    πŸ’¬ 2    πŸ“Œ 0

I do, that's why I'm trying to undo the paste to do ctrl-shift-v, but the undo is broken :D

21.07.2025 09:43 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
Post image

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

21.07.2025 09:17 β€” πŸ‘ 8    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

did you send it to press@? but that statement is a nothing burger

18.07.2025 07:53 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Preview
1 files | onboarding.html Β· SteamDatabase/SteamworksDocumentation@fddd59b

diff of the rule being added here: github.com/SteamDatabas...

16.07.2025 09:09 β€” πŸ‘ 14    πŸ” 2    πŸ’¬ 1    πŸ“Œ 0
Post image

the font choice is not good

11.07.2025 19:08 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
Post image Post image

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)

11.07.2025 08:11 β€” πŸ‘ 49    πŸ” 0    πŸ’¬ 2    πŸ“Œ 0
Post image

running mesa drivers on a windows in github actions to validate shaders is pretty cool

06.07.2025 20:31 β€” πŸ‘ 16    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

has the story with filtering report spam caused by extensions improved?

02.07.2025 18:36 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Went to a few of these, they're copying actual project sites and adding generated text to the page. And google being google, that somehow ranks higher.

30.06.2025 22:11 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

ClickHouse provides a MySQL interface, so it's trivial to use straight away, don't need to be using a library or rolling my own with the http interface.

One thing I hit was setting PDO::ATTR_EMULATE_PREPARES is a requirement, otherwise first row in selects was missing.

30.06.2025 20:22 β€” πŸ‘ 13    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Step 1 was double-writing data to both databases (still doing this until fully validated)

Step 2 is importing all the existing data, Claude made this pretty easy by making scripts for me.

Step 3 is switching all the queries to read from new database.

30.06.2025 20:22 β€” πŸ‘ 11    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
Post image

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.

30.06.2025 20:22 β€” πŸ‘ 63    πŸ” 0    πŸ’¬ 2    πŸ“Œ 0
Post image

Use SteamDB to find games with historical lows 🏷️, and many other filters https://steamdb.info/sales/

29.06.2025 20:51 β€” πŸ‘ 130    πŸ” 13    πŸ’¬ 3    πŸ“Œ 0

hey

27.06.2025 08:51 β€” πŸ‘ 30    πŸ” 0    πŸ’¬ 8    πŸ“Œ 0

Agreed, the discover feed on bsky is really bad for me too

23.06.2025 11:08 β€” πŸ‘ 4    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

this will be excellent after they tweak it further

would be nice to have a keybind to quickly toggle it

18.06.2025 10:08 β€” πŸ‘ 37    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Post image Post image Post image Post image

Sony appears to be removing regional restrictions on their Steam/PC games

God of War Ragnarok steamdb.info/sub/833972/h...
The Last of Us Part II Remastered steamdb.info/sub/1219787/...
Spider-Man 2 steamdb.info/sub/1219797/...
Helldivers 2 steamdb.info/sub/137730/h...

13.06.2025 18:38 β€” πŸ‘ 543    πŸ” 170    πŸ’¬ 20    πŸ“Œ 37

poorly implemented and poorly performing liquid glass coming soon to a website near you

12.06.2025 14:31 β€” πŸ‘ 40    πŸ” 0    πŸ’¬ 5    πŸ“Œ 0

Any good puzzle games to try this fest?

09.06.2025 22:02 β€” πŸ‘ 3    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Video thumbnail
09.06.2025 21:08 β€” πŸ‘ 12    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
Post image

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

09.06.2025 21:06 β€” πŸ‘ 17    πŸ” 1    πŸ’¬ 2    πŸ“Œ 0
Post image

I've expanded the theming to tables/titles/progress bars

06.06.2025 13:32 β€” πŸ‘ 25    πŸ” 1    πŸ’¬ 0    πŸ“Œ 0
Post image

steamdb calculator now matches your steam profile a little bit more

04.06.2025 19:57 β€” πŸ‘ 131    πŸ” 5    πŸ’¬ 2    πŸ“Œ 1

@xpaw.me is following 20 prominent accounts