Technical guide
Install dependencies from requirements.txt with pip
Install a project dependency list in the intended environment, understand version constraints and target directories, and distinguish a snapshot from a reproducible lock.
Technical guide
Install pip on macOS
Choose a user-managed Python installation, verify the matching pip, and install project dependencies in a virtual environment.
Technical guide
Install pip for the Python interpreter you use
Check for pip, choose a supported installation method, and keep project packages separate from a system-managed Python.
Explainer
Synchronize MySQL data to Elasticsearch
Choose JDBC polling, binlog-based CDC, or an application integration, with explicit handling of checkpoints, deletes, and consistency.
Explainer
Iterate over a Python dictionary with a for loop
Choose keys, values, or items, preserve insertion-order expectations, and avoid changing a dictionary’s keys during iteration.
Explainer
Join two metrics in PromQL with vector matching
Align metric series using on or ignoring, copy information labels, and diagnose missing or many-to-many matches.
Explainer
Preserve source paths when copying with rsync
Use archive mode for a directory tree and --relative to reproduce the desired source path at the destination.
Technical guide
Check whether a Git branch has been merged
Check commit ancestry against an explicit target, distinguish squash merges from ordinary merges, and review a branch before deleting it.
Explainer
List Ubuntu’s trusted CA certificates
Inspect Ubuntu’s CA bundle and hashed certificate directory, add or remove an approved local CA, and account for application-specific trust stores.
Technical guide
List the files changed by a Git commit
List changed paths or a complete commit snapshot, handle root and merge commits explicitly, and process unusual filenames without splitting them.
Explainer
Find cron jobs across users and system schedules
Inventory user crontabs, system cron files, periodic directories, timers and container schedules without overlooking their different scopes.
Technical guide
Find Git branches that contain a commit
Check which branch and tag histories contain a commit, refresh remote-tracking refs, and distinguish ancestry from a backported patch.