← Writing · page 8 of 11

How-to guides

151 posts tagged how-to.

Oct 20, 2026

How to Self-Host n8n with Docker Compose in Queue Mode (2026)

Step-by-step n8n queue mode setup on Docker Compose: Postgres, Redis, a webhook processor, workers with task runner sidecars, the encryption key, N8N_WEBHOOK_URL, TLS with Caddy, backups, upgrades and patching. Tested on n8n 2.43.8.

16 min
Oct 20, 2026

How to Deploy a Secure Remote MCP Server with OAuth (2026)

Step-by-step: run a remote MCP server over Streamable HTTP as an OAuth 2.1 resource server with Keycloak 26.8.1 and MCP Python SDK 2.3.0, validate audience and scopes per tool, add rate limits and audit logs, deploy to Cloud Run, and fix 401 and discovery errors.

16 min
Oct 20, 2026

How to Stop Secrets Leaking Into Git: Gitleaks, Pre-commit, CI (2026)

Step-by-step guide to secret scanning in 2026: gitleaks 8.30.1 and TruffleHog 3.99.3 as pre-commit hooks, GitHub push protection, CI scanning with pinned actions, rotating a leaked key, and removing it from history with git filter-repo.

14 min
Oct 20, 2026

How to Run a Local LLM With Ollama: Setup, GPU and API Guide (2026)

Step-by-step Ollama guide for 2026 (v0.40): install on macOS, Linux, Windows or Docker, confirm NVIDIA, AMD or Apple GPU use, pick a model that fits, set context length, write a Modelfile, call the OpenAI-compatible API, connect coding tools, and fix slow or out-of-memory runs.

14 min
Oct 20, 2026

How to Run an AI Coding Agent in GitHub Actions Safely (2026)

Step-by-step hardening for claude-code-action v1.0.254 and codex-action v1.13: SHA pinning, least-privilege permissions, safe triggers, keeping prompt injection from issues away from secrets, tool allowlists, turn caps, rulesets and troubleshooting.

15 min
Oct 20, 2026

How to Reduce Docker Image Size: Multi-Stage Builds Guide (2026)

Shrink Docker images with multi-stage builds, distroless or slim bases, .dockerignore, layer ordering and BuildKit cache mounts. Measured Go, Node, Python and Java examples: 343 MB to 3.4 MB, 423 MB to 56 MB, plus a troubleshooting table.

12 min
Oct 20, 2026

How to Reduce Alert Fatigue with Alertmanager: Step-by-Step (2026)

A practical guide to cutting alert noise with Prometheus and Alertmanager v0.34: measure noise, alert on symptoms, set severity labels, then configure routing, grouping, inhibition, silences and time intervals, and fix Alertmanager not sending notifications.

15 min
Oct 20, 2026

How to Build a RAG Pipeline With Postgres and pgvector (2026)

Step-by-step RAG pipeline on Postgres 18 and pgvector 0.8.7: install, schema, chunking, OpenAI embeddings, an HNSW index, hybrid search with full-text and reciprocal rank fusion, a Python example, retrieval evals, and fixes for slow queries and poor recall.

17 min
Oct 20, 2026

How to Defend LLM Apps Against Prompt Injection: 8 Steps (2026)

A practical prompt injection defence guide for LLM apps and agents: break the lethal trifecta, split privileged and quarantined models, gate tool calls in code, sanitise output, add Prompt Guard 2 as a tripwire, and red team with garak 0.17.1 and promptfoo 0.124.1.

17 min
Oct 20, 2026

How to Fix Prometheus High Cardinality: Find and Drop Series (2026)

Step-by-step guide to finding and fixing high cardinality in Prometheus 3.x: the TSDB status page and API, topk count by __name__, promtool tsdb analyze, metric_relabel_configs drop rules, native histograms, recording rules, sample_limit guardrails and Prometheus OOM fixes.

13 min
Oct 20, 2026

How to Implement Multi-Tenancy with Postgres Row-Level Security (2026)

Step-by-step Postgres row-level security for multi-tenant SaaS: tenant_id schema design, FORCE RLS and non-owner roles, policies using current_setting, SET LOCAL with PgBouncer transaction pooling, indexes, CI isolation tests and fixes for common errors.

13 min
Oct 20, 2026

How to Tune pgvector Performance: HNSW, ef_search and Quantization (2026)

A step-by-step pgvector tuning guide for 0.8.x: HNSW vs IVFFlat, m, ef_construction and ef_search, maintenance_work_mem for fast builds, iterative scans for filtered queries, halfvec and binary quantization, EXPLAIN, and a troubleshooting table, with real timings.

14 min
Oct 20, 2026

How to Set Up the OpenTelemetry Collector on Kubernetes (2026)

Step-by-step OpenTelemetry Collector setup on Kubernetes with Helm chart 0.176.0 and Operator 0.161.0: agent DaemonSet vs gateway, k8s_attributes, auto-instrumentation with the Instrumentation CR, and fixes for dropped spans and memory_limiter refusals.

14 min
Oct 20, 2026

How to Build Multi-Region Failover with Route 53 and Cloud DNS (2026)

Step-by-step multi-region failover: active-passive vs active-active, Route 53 health checks and failover records in Terraform, ARC routing controls, Cloud DNS failover policies, Aurora Global Database and Spanner, failover testing, and fixes for DNS TTL and caching problems.

16 min
Oct 20, 2026

How to Use MLflow 3: Tracking, Model Registry and GenAI Tracing (2026)

Step-by-step MLflow 3.17 guide: run a tracking server on PostgreSQL and S3, log runs and LoggedModels, register models with aliases instead of stages, trace and evaluate a GenAI app with mlflow.genai, serve the champion model, and fix the errors you will actually hit.

12 min