Category: editorial note

Seasonic modular power supply accessory cables list (#E19)

Here’s a quick PSA: Seasonic power supply cables. There are many, and apparently an important aspect is undocumented.

This week I sold a Seasonic PSU that was part of a full system build. I didn’t need it, I already got two reasonably-sized Seasonic PSUs for my two active systems, and since I only swapped boards, I had a surplus one. Unfortunately (thanks, modular power supplies!) it didn’t come with all the cables installed. But since most Seasonic modular cables are interchangeable across all product lines, I could just fill in the gaps with spare parts from my stock, right? […]


MariaDB/SQL query gotcha and optimized solution (#E18)

Haven’t had a general advice post for a while, have we.

My small fleet of ESP32 boards across the apartment is still gathering information for the AVM Fritz DECT 301 radiator control units that just started the heating season. While their queries are really simple, quick and fully automated, I also have an HighCharts overview plot of all data with user-defined query depth, usually 300 minutes / 5 hours, but I think there’s no arbitrary limit to it. One could plot all 2 million rows of data…but I’m not gonna try.

Anyway, I recently noticed query times went up significantly, and the whole thing never was blazing fast in the first place. […]


Disqus and their WordPress integration are a joke (#E17F1)

There, I said it. I did use stronger wording in the first revision, though.

In no particular order:

Disabling the plugin and re-enabling breaks the comment integration. The three comments made via Disqus are still available on their page, they can still be exported to an XML file that cannot be imported anywhere, but they don’t show up here. That’s a fundamental no-go. It’s broken if it cannot do that. I will not enter a vendor lock-in when my benefits are ads over which I have no control or paying 132 bucks a year.

The Disqus plugin settings menu is utterly pointless if something goes wrong. […]


Disqus comment system (#E17)

I just pulled the plug on the onboard WordPress comment system in favour of a Disqus plugin. While I’m not entirely sure if that is a good idea and will stay that way, the regular comment system is utterly broken in today’s internet. There’s not too many visitors to the site in general and registering for a comment is a hassle, but leaving the comment system open to any bot out there simply doesn’t cut it. Even with the former regulations in place, the spam-to-comment ratio was around 150:1, and the spam detection isn’t 100% accurate as well. […]


First Sunday in Advent & the PCB Tree (#E16)

Well, looks like it’s the first Sunday in Advent already and I’m too lazy preparing a new post. I’ve been working a bit more than usual lately due to our products likely playing a role in the whole temperature controlled Covid vaccine logistics thing. On the remaining Sundays I’ve been extending my old PCB Christmas tree. It’s been using diffused slow RGB (self) fading LEDs ever since (“100pcs LED Diod 5mm RGB Blink Slow Flash Diffused Light Emitting Diode Rainbow 2Pins Lamp Red Green Blue RGB Flashing 5mm LED”, around 2€ per pack of 100) and quite a few of old PCBs now, some bare and scrapped before assembly, some from tests or failed revisions, and some from defective commercial products like routers, access points, projectors, SAS backplanes, RAM, IoT gateways, hard disks, you name it. […]


Ubuntu and Firefox update (#E15)

Funny how UI changes in some of the most popular websites on earth can nudge you upgrading stuff. Oh, and how crappy (defective) hardware can finally flip the switch.

I’ve recently heard about the Ubuntu 20.10 release (Groovy Gorilla), which made me remember I’m still on 18.04 LTS (Bionic Beaver). Since I’m only jumping from LTS to LTS releases as my hardware gets older, I was determined to make the 20.04 (Focal Fossa) jump once I hit 256 days of uptime with my laptop.

I didn’t. Testing some old, almost forgotten, Ultrabay slice battery last week

+++ ThinkPad Battery Status: BAT1 (Ultrabay / Slice / Replaceable)
/sys/devices/platform/smapi/BAT1/manufacturer               = SONY
/sys/devices/platform/smapi/BAT1/model                      = 41U4890
/sys/devices/platform/smapi/BAT1/manufacture_date           = 2007-10-10
/sys/devices/platform/smapi/BAT1/first_use_date             = 2012-07-20
/sys/devices/platform/smapi/BAT1/cycle_count                =     44

caused an unexpected shutdown. […]


Server migration before server migration (#E14)

Quick update post: My all-time favourite hoster Uberspace veeery recently announced that the entire U6 generation of their servers will be moved to a different data center this very evening, as the old one will be torn down. Wan Hung Lo was hosted on those. Starting time about 8 o’clock in the evening local time, downtime probably four to eight hours in total, but servers are moved in smaller batches.

With two hours notice I decided to upgrade to the U7 server generation which everybody will be forced to by the end of the year (EOS of CentOS6 with EOM by Uberspace). […]


Sneaked into BigCliveLive (#E13)

As you might have heard already, bigclive(dotcom) is running a separate channel nowadays for live streams such as the occasional Manx Beard Club or the more recent weekly corona streams. It’s called BigCliveLive and I’m obviously subscribed to both of them. Aside from the last two livestreams I’ve watched the entirety of those channels…it should be trivial to find out the total playtime with the very handy youtube_dl tool that I use for all of my YouTube subscriptions, but it’s probably comparable to EEVblog, that is, in the medium to high 100s of hours. […]


3D models now available on thingiverse (#E12)

Quick note mixed with a bit of a “this is stupid” rant – as there’s quite a bit of 3D models coming in the near future (say…1.5 meters of them), I decided to put that stuff on thingiverse as well. It’s still hosted and linked here on this blog, but having it duplicated on an easy-to-search platform like thingiverse might be helpful for people with limited Google-fu. It’s also a nice source of somewhat standardized renderings from those parts, which I exploited in the previous post already.

Now to the “stupid! […]


A pleasant Jetpack support surprise (#E11)

Now something wholesome from grumpy me – around two weeks ago, one of the many WordPress updates caused the subsequent Jetpack update to fail. Jetpack, for those who do not know, is to me mainly a stats extension to the whole WordPress shebang, but they do offer quite a bit more than that, especially in the paid plans (which I do not have). Login security, backups, SEO, you name it. When hosting on wordpress.com, that stuff is included by default, and for self-hosted WordPress installations, it’s basically the first plugin to activate. […]