Home assistant yellow and what I wished would be clearly written elsewhere

I have bought a Home Assistant yellow which has been serving me well for a while. Recently I started getting errors from Zigbee2mqtt (Z2M).Some research suggested that I needed to use the new ember driver in Z2M, but instructions where very unclear. The Home Assistant Yellow contains a radio from Silabs and there is an… Continue reading Home assistant yellow and what I wished would be clearly written elsewhere

Preparing a Windows laptop with WSL for work

Neat packages to install VS Code + peacock Altsnap WinCompose (disabled Xorg conf) CopyQ From Windows 11. Source: https://kskroyal.com/run-ubuntu-24-04-on-windows-11-with-gui-using-wsl/ Add the key to github etc. cat ~/.ssh/id_ed25519https://github.com/settings/ssh/new Add eternal bash history Disable password on sudo

Eternal Bash History

If you want an eternal bash history (including stuff you do in parallel terminals) put this in your .bashrc file: To load your existing history do this: This will add a breaker between each command. The only downside is that all the commands will be listed as having occured in 1970 🙂 Source: https://stackoverflow.com/questions/9457233/unlimited-bash-history

Connecting from Azure Databricks to Azure SQL with AAD auth (with and without service principal)

If you need to load data from Azure SQL server to Azure Databricks you have several options. Using JDBC Using JDBC you can simple paste username/password, however this only works with sql authentication i.e. NOT with Azure Active Directory (AAD) Auth. A guide is available here: https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/sql-databases However, I recommend using the Spark Connector as… Continue reading Connecting from Azure Databricks to Azure SQL with AAD auth (with and without service principal)

RuntimeError: module compiled against API version 0xf but this version of numpy is 0xd

If you ever get this error when using numpy e.g. with Azure ML: RuntimeError: module compiled against API version 0xf but this version of numpy is 0xd You probably have mismatched versions of Numpy.Check the version and API version of your Numpy like this: You can check the mapping from Numpy version to C_API_VERSION here:… Continue reading RuntimeError: module compiled against API version 0xf but this version of numpy is 0xd