Profile avatar
xpaw.me
Programmer, data miner, creator of @steamdb.info 🌍 https://xpaw.me
118 posts 3,243 followers 89 following
Regular Contributor
Active Commenter
Posts 23 Comments 27

Here's that crossposter I mentioned before. Since I already had APIs implemented for automated posting, I created an UI, and then expanded it to support alt-text and replying to existing posts (which required storing new posts into the database ­­­— including automated ones).

submitted 3 days ago • 2 comments

@froggi.es cooked

submitted 4 days ago • 1 comment

Steam is working on adding zstd compression for game chunks (every game file is split into 1MB), it currently uses LZMA. Wonder how much of an overall improvement it will be.

submitted 5 days ago • 1 comment

testing api, pls ignore

submitted 9 days ago • 2 comments

@trezy.codes hey maybe add a label to @steamdb.info, and perhaps me 🙈

submitted 10 days ago • 1 comment

It's great how @discord.com's 2FA has been broken with hardware keys for at least a month now in any Chromium browser, which includes the desktop app.

submitted 10 days ago • 0 comments

Valve has created a dedicated page describing that in-game ads or ad-based revenue models are not allowed in Steam games. This has been reported as a new policy, but this has been the case for at least 5 years as seen on the pricing page, there just wasn't a separate page.

submitted 13 days ago • 14 comments

Been encoding kingdom come 2, but needed to install some mods to make it simpler: unlimited saves, higher inventory capacity, faster smithing. Just makes it less of a hassle to play. The game is fun though, still haven't done the first main mission in 19 hours 🙈

submitted 14 days ago • 1 comment

How did github gaslight everyone into thinking that putting random incarnations of scripts into a yaml file is a good way to do anything and there's no way to validate this locally

submitted 24 days ago • 3 comments

bizarre announcement, this is their 3rd rewrite and they will limit to querying 72 hours of data. guess i will have to look into migrating @steamdb.info to use clickhouse or something else

submitted 29 days ago • 2 comments

html/css got a few nice things relatively recently: css nesting, @starting-style to allow animating properties like display none->block, popovers that handle the backdrop/closing with escape correctly for you

submitted 41 days ago • 0 comments

Discord stopped remembering my collapsed categories a few weeks ago. So I tried to login into canary discord, but I can't even use the security key due to an error (?). Okay fine, I'll scan the qr code, but that fails too!?

submitted 46 days ago • 3 comments

one day microsoft will actually add country flag emojis to windows

submitted 47 days ago • 4 comments

TIL backdrop-filter:blur() has really different performance compared filter:blur(), generally with hardware acceleration turned off. It's really low fps when applying a backdrop filter on full screen modals for example. Also Firefox has some weird perf drop when there's multiple sticky elements.

submitted 47 days ago • 2 comments

Mildly impressive a 150gb mariadb database can compress to 12gb with zstd (using level 9). Really great for backups.

submitted 48 days ago • 0 comments

just sent everyone that has a donator badge on steamdb a steam award

submitted 58 days ago • 5 comments

Almost 19,000 games were released on Steam in 2024. Up from 14k in the previous year.

submitted 60 days ago • 7 comments

Reminder that SteamDB's sales page has filters for all-time and 2-year historical lows allowing you find the deepest discounts on Steam games so far.

submitted 62 days ago • 2 comments

always takes a while to update since steam servers have issues for hours every time a major sale starts

submitted 65 days ago • 0 comments

Brotli at higher compression levels is an insane CPU hog. I tweaked brotli_comp_level in nginx from 9 to 4, and it majorly helped with containing cpu loads. Caddy removed brotli too: "Compression performance was terrible. It would eat up a lot of CPU resources." Wonder how zstd compares.

submitted 65 days ago • 1 comment

#AdventOfCode day 14 part 2: Puzzle filled with assumptions, so I ended up cheating it and it surprisingly worked. I simply calculate bruteforce it, move all robots, and check how close they all are to the center of grid, and take the step where they all are the closest.

submitted 71 days ago • 0 comments

Top Steam releases of 2024 as decided by our rating algorithm: 1. Balatro 2. WEBFISHING 3. The WereCleaner 4. Sheepy: A Short Adventure 5. Satisfactory 6. Black Myth: Wukong This year we've added filtering, so you can find top games matching your criteria. Full list: steamdb.info/stats/gamera...

submitted 72 days ago • 13 comments

PSA if you like engine vanity data: Please ship your games on Steam with .exe + .pck, not with the "Embed PCK" single binary option. SteamDB detects engines based on the files listing, and .pck files are the only reliable marker of Godot games.

submitted 74 days ago • 3 comments