Never stop exploring!

Main menu

Post navigation

Recently I’ve switched my Internet provider. The new one delivers Internet trough optic fiber to the last mile and the speed should be 100MBit/s. Speed tests over a cable confirm the speed is very close to 100 MBit/s. I however noticed some lags and slowness on my laptop when using WiFi which was not expected. Speedtest.netshowed this:

The results are far away from what I would expect! Again, when attached via LAN cable – everything is fine.

For reports on my timeseries data I really needed Windowing functions like LAG(), LEAD(), ROW_NUMBER() etc. The speed and flexibility you gain using Windowing functions is incredible compared to imitating LAG() using “self-join” tricks. But these function are supported as of MySQL 8 and as of MariaDB 10.2.

For numerous of reasons I prefer to use MariaDB which is compatible drop-in replacement for MySQL.

Recently a Prestigio smartbook had to be reinstalled with latest Windows 10 1803. This laptop came with 32 bit Windows but had 64bit CPU. So I [wrongly] assumed 64-bit Windows would work. That was not the case!

I’d made 64-bit Windows 10 installation USB stick using Rufus (MBR:UEFI). But when booting I’ve received an error: