Show newer

Everybody freaking out about open-sourcing their kernel , perhaps not realizing they are only open-sourcing the *kernel* part of the driver - not the huge userspace blob:

$ ls -l /usr/lib/firmware/nvidia/510.60.02/gsp.bin
-rw-r--r-- 1 root root 40439760 ... /usr/lib/firmware/nvidia/510.60.02/gsp.bin

It says so right there on the first page of in the repo, if anyone bothered to check...

Over the past few days I've been playing with and data whenever I could grab a moment. I went from:

"How am I supposed to do $simple_thing?!?!"


"Mmm, this actually makes sense..."


"Let me style all tertiary roads using dashed lines and have buildings in residential areas throw simple shadows and generate a 3x3 A4 poster optimized for B&W laser printer"

I'm having fun!

Michal boosted

I'm playing the "Why?" game with the little one. My longest streak so far was 11 answers, since I didn't want to get into particle physics.

Winning strategies so far: not playing (stop responding) and/or steer the questions towards the little one ("Why?... Because you didn't want to do it, why didn't you want to do it? Because...")

Michal boosted

Have you posted a photo on Mastodon and the preview image hides something important?

If you're using the web version of Masto, you can alter the focus of the preview image when posting photos. Just click "Edit" on the image and move the circle around. When you've finished click "Apply".

(And while you're editing, do remember to add an image description for blind people!)

The two photos below are identical, but one has the focus set to the right and one to the left.

#MastoTips #Mastodon #FediTips

Interesting little mnemonic I've been told as a kid about one's bottom and sitting on cold surfaces outdoors: "You can sit on your aRse if there's an R in the current month".

I still think September should get an exception...

Trick to allow importing an entire country to pgRouting/PostGIS/PostgreSQL [1]: first chop up the source into smaller pieces using splitter [2], otherwise the osm2pgrouting tool will keep crashing:

$ java -jar splitter.jar --output-dir=splits/ country.osm
$ ONCE=--clean; for f in splits/*.pbf; do osmconvert $f --out-osm -o=part.osm; osm2pgrouting -f part.osm $ONCE ...; ONCE=; done


Things I changed my opinion on based in practice - if you are committing a change, a test change should be included.

If you're modifying something, then either
a) it was tested before, and something must have started failing, or b) you're modifying something that wasn't tested before, so a new test case should be added.

Obviously one should apply common sense, but it's useful even for small/one-off projects...

Example where this is being done rigorously - SQLite, e.g.

Michal boosted

Year progress: ▒▒▒▒▒▒░░░░░░░░░░░░░░ 33.2%

It turns out that the extensions are maintained *per database*, so while I was upgrading the extension version in "postgres" database, I was *not* upgrading the extension in "mastodon" database.

After checking the extension versions in both using "\dx", the fix was simple - use the "postgres" user in the "mastodon" database and voila, it worked!

Show thread

+ : after recent upgrade, I wanted to try out /pghero only to find out it's broken with the following error in logs:

ERROR: column "total_plan_time" does not exist [1]

The supposed fix is to run the following command:

ALTER EXTENSION pg_stat_statements UPDATE;

Which only works under the "creator" creator account, so I ran it under "postgresql" role instead of "mastodon".

However, even after running it, it still didn't work...


Michal boosted

A few years ago I made this flow chart of which Mastodon posts end up in which timelines!

So, you can see how each instance will have a different local timeline, and even a slightly different federated timeline - and you can see why the federated timeline moves so much faster than the local one, too.

This is why it's important to boost good posts and use hashtags - the fediverse is fragmented and harder to search by nature.

[ #mastodon #meta #tootorial #howto #mastopedia #mastotip ]

It's Friday afternoon after working hours, obviously the best time for kids to have elevated temperature again.

Just after the doctor's office closes, yet another weekend not going anywhere, waiting to see how situation evolves.

Another day, another system update, another failure to start Mastodon server followed by debugging, figuring out Postgres got upgraded too, having to manually do the `pg_upgrade` dance...

Why can't the system update do the pg_upgrade as a post install hook and keep a backup somewhere if something goes wrong?

Was reading a random "new laptop wanted" thread, realized I was happy with my T440s and checked its age - it was introduced in 2013, it's almost 9 years old now.

Yep, still very usable. I guess the 12G RAM and 1080p resolution has a lot to do with it.

After multiple attempts it suddenly worked. I have no clue what happened and why this suddenly worked. Maybe I tried the "Mastodon domain" instead of the "root domain"?

Show thread

I'm trying out the app, unsuccessfully trying to log into my self-hosted instance.

First I had to add a redirect for "/oauth/" from my "main" domain to the Mastodon subdomain for some reason.

Now I get a '404' toast after "approving" the permissions. Checking the server logs:

GET /api/v1/apps HTTP/2.0 404

mastodon-web-1 | ... method=GET path=/api/v1/apps format=html controller=ApplicationController action=raise_not_found status=404 duration=0.93 view=0.48 db=0.00

How to export cookies for a certain host in cookies.txt format from Firefox using the command line?

$ sqlite3 -tabs cookies.sqlite "SELECT host, 'TRUE', path, 'TRUE', expiry, name, value FROM moz_cookies WHERE host='${HOST?}'"

Michal boosted

for every engineer who moves fast and breaks things, there are four more who move slow and fix things. and they're tired of the first engineer's bullshit

"I don't just have ADHD, I have AD-UltraHD-4K-120fps" 😁

Show older

The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!