Smokes your problems, coughs fresh air.
There are many sites out there that describe how to emulate a Raspberry Pi with Raspberry Pi OS on it, so I won t give those details, but with the new Debian Trixie (13) based Raspberry Pi OS, I ran into trouble booting. It kept hanging or rebooting at: 8.849465 systemd 1 : Detected architecture arm64. 8.854622 systemd 1 : Detected first boot. Welcome to Raspbian GNU/Linux 13 trixie ! 8.995587…
Since my initial announcement here of pg_safer_settings , my extensions for safe (through per-column GRANT s), fast (through IMMUTABLE , auto-(re)generated accessor functions) settings has matured quite a bit, and is now at version 0.8.12 . Soon, later this month, still in the first quarter of 2024, I expect to release the first officially stable 1.0 version…
I just released pg_text_semver version 1.0.0 on PGXN. As usual, it s also available for your forking pleasure. Upgrading from 0.1.5 to 1.0.0 should be seamless. As usual, upgrade scripts are provided, though I didn t need to according to the Semantic Versioning for pre-1.0 releases. Since my initial release, I ve learned that, besides the pre-existing semver extension that I tried before…
My computer sometimes doesn t want to boot and/or shutdown anymore and gives the warning at boot time in plain text (not graphically): The ME FW of system was found abnormal . It happened last night and because I had this before, I still had a USB stick with firmwares on it from last time, it was quickly recovered. But, I did need to refresh my memory about which version to use. Last time I used…
Somehow, while working on the ranking of “De Schuilplaats” in the shittified 2023 Google Search, between writing and peddling guest blog posts to spammy website with reasonable PageRank, I overlooked the fact that I could add a profile for a holiday home for free to a website operated by the province of Drenthe to promote tourism in the region. So here is our new profile on the Drenthe.nl website,…
The following is a copy of an guest post of mine that was published on Hoogsensitief.NL on June 19, 2023: Overgevoelig voor programmeren? Programmeren lijkt bij uitstek een activiteit die geschikt is voor gevoelige mensen. Zolang je computer in een omgeving staat met prettige verlichting (het liefste daglicht) en zonder rumoerige collega’s of (veel erger!) achtergrondmuziek, zit je vaak in een…
What a mess After postponing this for many months because I knew what awaited me, I double-upgraded an Ubuntu 18.04 server today, and aside from MySQL breaking in some spectacular ways (corrupt redo log for one), the Roundcube package was broken, primarily due to MySQL. In MySQL 8, system is now a reserved keyword; a change that in my opinion was quite risky, because many people use that word.…
Early during the development of the PostgreSQL backend for FlashMQ.com—that is our amazing managed MQTT hosting service !—, I decided on using UUIDs rather than auto-incrementing integers wherever I needed or wanted surrogate keys. I am one of those people who prefers the use of natural keys where their use is … natural, but I certainly have nothing _against_ surrogate keys, only to their overuse,…
I needed to compare semantic versions within Postgres. I tried the existing semver extension, but when I found that it was a bit problematic to adjust to be fully compliant with the semantic versioning spec , I decided to write a simple domain-based alternative myself: pg_text_semver . (Version parsing was part of my effort for more robust pg_restore of FlashMQ extension data. I might write more…
My newest PostgreSQL extension— pg_extra_time —contains the date-time functions, operators and casts that I was surprised to not find in the standard library. Maybe one day… Again, this extension is a shoot-off from the PostgreSQL work I m doing for the backend of the high-performant FlashMQ.com MQTT hosting service , that is due to launch later this quarter. Like most of the FlashMQ.com…