Read-Only SQL Analyst Agent for Postgres
Give an agent a SELECT-only Postgres role and a table allowlist so it can explain slow queries and row counts without ever writing to production.
AI Agents8 min read
NetBay journal
Guides for operators
Practical guides for Linux, containers, CI/CD, self-hosting, and running VPS infrastructure from Netbay Engineering.
599 articles · 24 topics
AllLinuxLinux AdministrationWindowsLinux SecurityLinux NetworkingContainersContainers & OrchestrationKubernetesCI/CDGitHubSelf-HostingBackups & DataDatabasesApp DeploymentDNS & TLSObservabilityEmailAI AgentsAI InfrastructureAPI & AutomationProxiesCloud ArchitectureHardware & PerformanceDevOps Practices
Fine-Tuning Is Usually the Wrong First LLM Step
Evaluate prompts, retrieval, and routing on a VPS before you collect a fine-tune set, because most quality gaps are instructions and data, not weights.
AI Infrastructure8 min read
systemd Units and journalctl: Inspecting Services Properly
Learn how systemd units define services, how to control them, and how journalctl gives you structured service logs.
Linux6 min read
openSUSE Leap vs Tumbleweed: The Server Deep Dive
Leap for point-release calm, Tumbleweed for rolling freshness on the same project. Compare patches, snapshots, and testing before you host anything.
Linux8 min read
Podman Basics: Rootless Containers and Quadlets
Run containers without root and manage them with systemd Quadlets — a rootless-first workflow that fits systemd-based VPS hosts cleanly.
Containers & Orchestration7 min read
Managing Terraform State: Local, Locking, and Caution
Manage Terraform state safely: keep it in a remote backend with locking, never hand-edit it, and use state commands for real renames.
API & Automation7 min read
sqlite3 CLI: .schema, EXPLAIN QUERY PLAN, ANALYZE
Use sqlite3 .schema, EXPLAIN QUERY PLAN, and ANALYZE on the live file to see what SQLite stores, how it will read it, and which indexes it trusts.
Databases8 min read
Let's Encrypt with Certbot and Nginx on Ubuntu
Issue a Let's Encrypt certificate with certbot and nginx on Ubuntu, complete HTTP-01, and wire the live cert into a working TLS server block.
DNS & TLS8 min read
SSH ControlMaster Multiplexing for Slow Links
Reuse one SSH TCP handshake with ControlMaster and ControlPersist so scp, git, and extra shells stay fast on high-latency links into Lucknow.
Linux Administration8 min read
Deployment Strategies Review: Blue-Green, Canary, Rolling
Compare blue-green, canary, and rolling deployments, and learn how CI gates each so you release with less risk and faster rollback.
CI/CD8 min read
Hosting Your Own RSS Reader With Miniflux
Deploy Miniflux on a VPS to aggregate thousands of feeds into a fast, keyboard-driven RSS reader with a Postgres backend and complete privacy.
Self-Hosting5 min read
Disk Quotas and Capacity Monitoring: VPS Basics
Per-user and per-filesystem disk quotas on Linux, plus a capacity monitoring loop with thresholds and alerting so no volume ever fills silently.
Hardware & Performance6 min read