Dmitry Marakasov @AMDmi3@fosstodon.org

TIL you can make other people unfollow you on GitHub by blocking and unblocking them.

"There are only two hard things in Computer Science: cache invalidation and naming things."

I'd replace both with choosing right logging severity level.

Google haters paradox: while I fully agree with people who say that the purpose of everything #google develops is just more privacy invasion and data collection, Google is still much more trustworthy than these people.

#google was amazingly effective in making me switch to #duckduckgo with their craptcha, yet they fail miserably in preventing my bot from scanning their SERP 24/7 for months.

In case you're interested the key to success was using elinks user agent (seem to prevent them from using some ways of clientside bot detection) and do no more than one request per minute. Not much, but quite enough for monitoring you site positions in search results.

About 10 years ago #sourceforge seemed like preferable way to host #FOSS source packages because of its mirror system which greatly increased distfile availability.

Nowadays half of its mirrors do not respond, others give unimaginable in 2020 speeds like 10-100 kBps. In addition, whole sourceforge infrastructure is frequently down lately.

So today it's preferable to avoid this dump at all costs.

#DIY #robotics and #computer_vision idea: a mechanized bird feeder which retracts as a bird tries to peck. Would be fun to see it in action.

Today I've discovered that order of INSERTed data matters in #PostgreSQL. Inserting randomly ordered data (like, a result of HashAggregate which may be used to perform `INSERT INTO .. FROM SELECT .. JOIN ..`) may lead to thrashing if affected indexes do not fit into shared_buffers. The solution is obviously to add ORDER BY.

So, #Firefox 72.0 seems to have killed the ability to place tab bar below the location bar again, and there doesn't seem to be a way to easily fix it with user CSS. I guess that there's no other choice than to start patching it.

It's a nice chance to get acquainted with its internals though, remove garbage like pocket and telemetry, and invent the name which humiliates #mozilla the most.

Unfortunately, introduction of new #python features (such as PEP 572 - Assignment Expressions) into real codebases is hindered by lagging tools support.

Such as, PEP572 is still not supported neither by #flake8 nor by #mypy.

Feels nice to finally return some technical debt. Shamefully, I have some #FreeBSD bugs assigned to me since 2017, but I'm finally at squishing them.

The biggest one is #OpenSceneGraph port update which I'm going to commit tomorrow, another is #UnknownHorizons update to 2019.1 which also requires #fifengine and other dependencies update (pending maintainer feedback/timeout).

After these, only 3 ancient bugs left!

Finally switched to #python 3.8 on my #FreeBSD desktop. Two problems discovered so far: devel/talloc port does not build [1] and there's hang [2] in multiprocessing.Pool in one of my scripts.

[1] https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=241791
[2] https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=241801

#Repology has used software versions from #Wikidata as one of its sources for almost two years, and now it's time to give back. The bot which fills package information for software projects in Wikidata based on data from Repology is complete, had been approved and had already filled most of Gentoo and Arch packages known to Repology. I love this kind of synergy.