My problem: sometimes I forget to review published interviews for a talk. I publish a weekly interview series, the 'PostgreSQL Person of the Week' interviews. The data lives in a big spreadsheet, which has several sub-sheets. My idea was to color the background of this cell, based on the value in the first sheet: make the cell background green when the interview is completed. This gives me an instant indication if I need to work on this interview or not. Turns out this is a bit complicated, but possible.
Posted by ads' corner on Tuesday, June 7, 2022
A couple days ago Devrim forked PostgreSQL to get a beer. That effort is of course laudable, but a bit extreme. PostgreSQL is very extensible, and allows to implement a beer now clock with just a few easy steps.
Posted by ads' corner on Tuesday, May 3, 2022
For one project I need to insert the content of a local file into another file on the remote system, and the first file happens to be JSON. The JSON file is in compact format and is supposed to stay this way. When Ansible reads the content of the file, it determines that the content is JSON, and parses the content into the variable - and along the way is uncompressing the format. Not what I want. To keep the file content as string, it is necessary to tell Ansible to handle this as string.
Posted by ads' corner on Sunday, March 20, 2022
In a more complex openHAB2 Rule I'm writing, I need to find out if a certain Item exist. If I try to access it when it does not exist, the Rule will fail. Not good. I could pass in a parameter to the framework which builds the Rule, but that is cumbersome and requires changes on several places. Let's see if I can have the Rule figure this out.
Posted by ads' corner on Saturday, March 19, 2022
While writing and stress-testing a Python script which uses the multiprocessing library, I ran into the problem that occasionally the script hangs at the end. Literally runs past the last line of code and then hangs.
Posted by ads' corner on Thursday, March 3, 2022
Christophe Pettus posted an interesting challenge. Two strings which on the surface look equal, but if you ask PostgreSQL to compare them, they are not equal.
Posted by ads' corner on Thursday, January 27, 2022
Wir haben den Golf 8 jetzt etwas über ein Jahr, Zeit eine weitere Bilanz zu ziehen.
Posted by ads' corner on Friday, January 7, 2022
Irgendwann September 2020 wollten wir unseren in die Tage gekommenen Smoothiemaker ersetzen. Nach etwas Recherche wurde es dann der 'WMF Küchenminis Smoothie-to-go 0,6l'. Es sollte nicht der einzige bleiben.
Posted by ads' corner on Wednesday, January 5, 2022
When I rolled out my new Icinga2 installation, and added disk checks for all laptops, I ran into a small problem: there is a fuse mountpoint for logged in users which only the user can read. Apparently it has something to do with Flatpack.
Posted by ads' corner on Saturday, November 27, 2021
When I make changes in OpenStreetMap, I often need to extract the object colour from a picture or a video, as example for a building, bench or a roof. This collides with a feature in KDE which I really like: Dim Inactive Windows.
Posted by ads' corner on Wednesday, November 24, 2021