Latest Articles

If a Django MySQL connection still hits 'No DB engine substitution' despite setting `ENGINE` to `django.db.backends.mysql`, here is the root cause and fix.

When installing `google-crc32c` ≥1.1.3 on Alpine Linux fails to build, work around it by setting CFLAGS to enable SSE4.2 explicitly.

Format a USB stick as FAT32 + MBR on a Mac — explicit MBR via `diskutil eraseDisk` arguments.

When saving secret information locally in a file named .env and registering it with Kubernetes:

Replace legacy log analyzers (Webalizer / Analog) with GoAccess for Apache / nginx access logs — sample configuration and example output.

When an Intel MacBook Pro suddenly becomes slow after waking from standby, check and tune the `hibernate` / `standby` modes with `pmset`.

Build a tiny HTTP server in Python (bottle + gevent) that takes a screenshot of any URL using headless Chromium and returns it as an image.

Downgrade Flutter from v2 back to v1 — use `flutter downgrade` and how to realign dependent package versions with the older SDK.

When a MySQL 8.0 client connects to a MySQL 5.7 server, the client overrides charset to utf8mb4 and breaks Japanese on a latin1 server — here is the fix.

Creating a dashboard and advertisement slideshow as a web application on a website, and displaying it on Windows digital signage.

Here's an introduction to a code snippet that waits for an element to disappear, using Pyppeteer, which is Python's version of Puppeteer. The same approach should work similarly in Puppeteer's JavaScript version.

Why specifying `choices` on a Django `CharField` makes `list_filter` faster — it bypasses the DISTINCT query the admin runs to enumerate filter values.

Even though the Pipfile specifies ```plaintext [packages] ... Werkzeug = "<1.0.0" ``` running ```plaintext pipenv install --system --skip-lock --dev --deploy ``` installs version 1.0.1.

Launch VSCode (`code.cmd`) from a Flutter Windows app via `Process.run`. Covers how to pass arguments and handle quoting issues correctly.

Dart's `dio` HTTP client lowercases all request header names, which can break authentication against old servers that treat header casing as significant.

Sometimes, USB memory sticks that have been used for creating OS installation media may have a corrupted partition table, making it impossible to format them using the "Disk Utility" app.

When Django uses multiple databases and `ForeignKey` cannot traverse across them — `router.allow_relation` behavior and raw SQL workarounds.

Fix `zlib`-related errors when `pip install mysqlclient` (old MySQL-python) — `brew install zlib` and add the right `LDFLAGS`.

Notes on porting a JAN code check-digit validation script from ASP.NET / JavaScript to PHP, with a working PHP sample.

Install ChromeDriver 126 on Ubuntu 22.04 and run Selenium against it — apt + manual download steps, plus matching the Chromium / Chrome version.