Index WP MySQL For Speed

Consider using his plugin by default:
https://wordpress.org/plugins/index-wp-mysql-for-speed/

You only have to run it once, to create better indexing keys on the database tables, which in my eyes should be default in WordPress.
Unbelievable what I see in speed performance so far!

(Found this plugin actually by following the steps in this blog article for a client.)

But wait, there is more!
https://www.plumislandmedia.net/wordpress/performance/optimizing-wordpress-database-servers/

Wifi to Zigbee

My wifi is not slow at all, but I started getting more and more connection problems from random devices. The solution for me was to replace some wifi devices with zigbee versions.

I started with adding a SMLIGHT SLZB-06 to my network. This is a Zigbee 3.0 to Ethernet USB WiFi Gateway Coordinator with PoE and it works with Home Assistant using ZHA or Zigbee2MQTT.
So I gave it a fixed IP address, and on my NAS, where Home Assistant is running in a Docker container, I installed eclipse-mosquitto and koenkk/zigbee2mqtt. Next I added the SMLIGHT SLZB-06 and MQTT integration in Home Assistant and everything started coming together and working like a charm.

First added devices were temperature and humidity sensors, Sonoff SNZB-02P and SNZB-02D. Next I started adding smart plugs Sonoff S60ZBTPF and IHOMECAM Smart power plugs, replacing my HomeWizard wifi energy sockets.

And guess what? With more devices on zigbee, my wifi is stable again and I get a lot more data out of my smart home!

That’s all folks!
Have a nice day…

Thunderbird 140 Manual Folder Sorting

Yes! The option is back!
Natively now, without the old plugin that was no longer supported for way too long. However, when I tried to drag and drop a folder, I could move one folder into another, but not change the order.

What’s wrong? I am using unified folders, and sorting does not work there.
You would have to use the ‘All Folders’ view, and drag/drop/re-order your folders there. This luckily also changes the order in the ‘Unified Folders’ view, so problem solved! Now let’s hope the developers will fix that in the next version.

That’s all Folks!
Have a nice day…

Update HA docker container

So I installed Home Assistant on a Synology NAS, using the official instructions. Now, one of my HACS Integrations started complaining about an update, but it required a newer version of Home Assistant, which I was not receiving. After a long search I figured out that using the ‘stable’ tag would not give me any updates for Home Assistant. I would have to use ‘latest’…
Unfortunately, you cannot change this in the downloaded docker Image.

So, what to do? My system was running for a month and I did not want to lose my config and history/data. Simple solution; I downloaded a new Image with the correct settings and pointed a new Container to the same /config folder on my NAS.

Since the instructions on the Home Assistant website were not quite correct for my version of Synology DSM 7.2.2-72806 Update 3, below the updated steps:

Install Home Assistant Container

Continue reading Update HA docker container

Home Assistant Formuler Z11 Remote

As mentioned before, I started using Home Assistant to create my own smart home and as it goes, you start playing with other smart devices in the home. You connect lights, heating, tv, sound system, router, and, in my case, the Formuler Z11 box. You start with little scripts to turn everything on (or off) with a single button press, instead of having to grab three separate remotes. And then you find the Universal Remote Card… a remote control card, within Home Assistant!

Standard buttons for zapping and volume were added quickly, but the ‘Groups’ and ‘Guide’ buttons turned out to be a little bit more of a challenge. But… I got it working, and below is the how-to, if you want to add custom buttons for your android tv box in Home Assistant as well.

Continue reading Home Assistant Formuler Z11 Remote

Height of CSS block containing floats

How to give that block the correct height? Read here.
How can I make a div grow its height when it has floats inside of it? I know that defining a value for the width and setting overflow to hidden works. The problem is that I need a div with the overflow visible.

The answer is this: In order for a parent to wrap around children elements which are floated, a new block formatting context needs to be set on the parent. This can be done with:

.wrap {
    display: flow-root;
}

or

.wrap {
    contain: layout;
}

The latter is a bit newer. Either of these have an advantage over overflow: auto; because they have the explicit purpose of creating a new block formatting context, while overflow: auto works as a side effect. Interestingly, flow-root can be also used alongside block or inline for better layout control. For example:

.wrap {
    display: inline flow-root;
}

Read more:

That’s all folks!
Have a nice day…