When I started using foreign keys in SQLite, I was surprised to find an empty table after updating another one. I was using the REPLACE conflict resolution algorithm, and the empty table had foreign keys with cascading delete. This behavior was unexpected, so let’s dig in.

Does your application start indefinite vibrations that you stop some time later, e.g. in a BroadcastReceiver? Have you received bug reports that your application won’t stop vibrating? Me too, and here is my solution.

Here is a way to clean-up ASUS router’s NVRAM without full factory reset. Yes, it is possible :)

I like JetBrains’ Rider; it’s much better than Visual Studio (VS), but it can fail running .NET applications in the debug mode. So here is a workaround.

Earlier this year, I deployed my first Cloudflare (CF) Page built with Hugo, and it failed with several build errors. The root cause was a different Hugo version running on my computer compared to the one in the CF build pipeline. Let’s solve this.

After many years, I have finally launched my blog, a place to jot down random thoughts.