chuso.net

Running SQL queries on Spanish cadastre

Python script for importing CAT files from the Spanish cadastre into a database on which SQL queries can be executed.

Scheduling Mastodon posts without third-party tools

Mastodon supports scheduling posts natively, but the feature is not available in the official interfaces.

About the New Terms of Use of mastodon.social

The Mastodon instance mastodon.social plans to implement new terms of use starting July 2025, which have turned out to be somewhat controversial.

Collapse all diff blocks in Github or GitLab

How to collapse all diff blocks in Github or GitLab while seeing changes between versions

Speeding up Gentoo packages building

Some strategies to make Gentoo package compilation a bit faster

On moderation in the fediverse and in general

My views on a recent controversy on the fediverse on stop federation with instances that unknowngly host unacceptable accounts.

Splitting merged text files back into individual files

How to split back with POSIX standard tools text files that were merged into one single file.

A November patch introduces new conflicts in Active Directory

Since Novembmer ‘21 update, Active Directory new conditions may make it raise a CONSTRAINT_ATT_TYPE violation affecting other products.

Why I choose Gentoo

I’ve been using Gentoo Linux for 20 years. Why? Because I cannot live without Linux and I haven’t found any Linux distribution that I like so much. Here I tell why.

Trusting invalid SSL certificates is wrong

So let me put it clear from the first line: trusting invalid certificates is wrong.

And now I will explain why it’s wrong and why there are few excuses for it.

We are talking here about certificates for SSL encryption, which serves basically two purposes:

  • Privacy — data is transferred encrypted and can only be decrypted by the intended recipient and not a third party wiretapping the line.
  • Authentication — making sure the receiving end that will be able to decrypt the data is who they claim to be and data is not diverted to a different receiver by a third party with access to manipulating our transfers.

Invalid certificates obviously defeat the second purpose of verifying the other end’s identity: