Dmitry Marakasov @AMDmi3@fosstodon.org

Just got an idea that pandemic is similar to Ponzi scheme - you're profitable if you join among the first (e.g. until the health system is overloaded and you get the proper treatment) or don't join at all.

I've always been upset of how russian countryside steadily dies out as people have to move to cities seeking for jobs, while in XXI a lot of jobs may be done remotely, giving people more freedom of where to live. I'd gladly move to a village to forget about smoke, crowds, traffic jams and rapacious estate prices. I hope that the pandemic will help spread the idea of remote work.

Pics: abandoned village in Russia.

#Repology now has an experimental feature of listing #foss projects which were packaged in a lot of repositories recently. This weeks trending projects are libfido2 and lunch or, likely because of openssh 8.2 release.

https://repology.org/experimental/trending

I've always been amazed by cyclopic landscapes of Blame! #manga by Tsutomu Nihei. Just got an idea that this setting could be implemented as a #minetest mod. The engine could even allow working GBE!

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.