Hans Harhoff Andersen

(For the uninitiated: a Ralph Wiggum loop is when you wrap an agent in a while true with a trivial “keep going” prompt and see how far it gets. Named after the Simpsons character who’d happily say “more!” forever.) Here’s what I did. I had given Claude Code some vague instructions — build an integration… Continue reading I left Claude Code in a Ralph Wiggum loop while on holiday. It tried to ghost me.

I have published a small VS Code extension called Git Remote Changes Alert. It does one simple thing: it makes remote Git changes easier to notice while you work. The extension adds a status bar indicator that shows when your current branch is behind its remote, and it can also show when the default branch… Continue reading New VS Code Extension: Git Remote Changes Alert

I recently had to build a Dash Ag Grid where multiple columns interact i.e. changing Width or Length changes the calculated Area and changing Area changes either Width or Length correspondingly. This was slightly confsuing so here is a simple example of how to do it. To get started Then run the code using main.py:… Continue reading How to handle multiple dependent columns on Dash Ag Grid

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

Neat packages to install VS Code + peacock Altsnap Claude Code WinCompose (disabled Xorg conf) CopyQ chezmoi (sudo snap install chezmoi –classic) 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 Docker Az cli curl -sL https://aka.ms/InstallAzureCLIDeb | sudo bash az login See… Continue reading Preparing a Windows laptop with WSL for work

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

Using Dynaconf for settings and secrets in Python projects is my favorite approach. Connecting it to Hashicorp vault as the backend is a bit tricky though since the documentation for this is very sparse. The documentation here gives a working example, but does not explain how you set up the same with a config.py file… Continue reading Connecting Dynaconf to Hashicorp Vault

How do I access my Azure Devops hosted python packages via poetry? Simply add the feed url e.g. Source: https://python-poetry.org/docs/master/repositories/

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)