Port NULL handling across Oracle, SQL Server, MySQL and SQLite by fixing four portability points: how a NULL is tested, what a comparison against NULL returns, whether boolean contexts coerce NULL, and what an empty string means. Oracle treats a zero-length character as null but warns this may change, while SQL Server depends on ANSI_NULLS, MySQL returns NULL for comparisons and coerces 0 and NULL to false in boolean contexts, and SQLite's IS and IS NOT are an extension.
SQL portability / NULL handling / Oracle / SQL Server / MySQL / SQLite / empty string / ANSI_NULLS
How to read, modify, and synchronize environment variables in Python using os.environ and os.environb, handle encoding differences across platforms, and pass environment to child processes.
os.environ / os.environb / environment-variables / python-os / utf8-mode / cross-platform / child-process / reload_environ
Distinguish missing and empty settings, parse ports and booleans explicitly, and report configuration errors without exposing secrets.
Python / Configuration / Environment / Validation
A practical guide to using pathlib for file existence checks, extension manipulation, directory navigation, and path resolution without introducing platform-specific bugs on Windows or Unix systems.
pathlib / cross-platform / python / file-system / os.PathLike / PurePath / glob / resolve