March 2021

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`.