ITNotes - Page 11 of 83 - From Terminal to Cloud

PostgreSQL Performance Analysis with pg_stat_statements: Find and Fix Slow Queries

May 25, 2026

pg_stat_statements is a built-in PostgreSQL extension that tracks aggregated execution statistics for every query — total time, call count, cache hit rate, and more. This guide walks through enabling it, querying the data to find your worst bottlenecks, and turning those stats into concrete index and query optimizations for production.

Linux

Stop Hardcoding SMTP: Set Up a Postfix Mail Relay for Linux Alerts

May 25, 2026

Learn how to configure Postfix as a send-only mail relay on Linux. This guide covers installation, security hardening, and address rewriting to ensure your system alerts and Cron jobs deliver emails reliably.

Networking

Stop Sending Users Across the Globe: Building GeoDNS with PowerDNS

May 25, 2026

Stop wasting milliseconds. Learn how to build a self-hosted GeoDNS using PowerDNS to route global traffic to the nearest server for maximum performance.

Deploying Microsoft Phi-4 with Ollama: High-Performance SLMs for Edge and Local Hardware

May 25, 2026

Learn how to deploy Microsoft's Phi-4 Small Language Model locally using Ollama. This guide covers hardware specs, Python integration, and optimization for edge devices.

Programming

Stop Writing API Clients by Hand: A Guide to OpenAPI Generator

May 25, 2026

Eliminate manual API updates and type mismatches. Learn how to use openapi-generator to automate Client SDKs and Server Stubs directly from your OpenAPI spec.

High-Performance LLMs on Intel CPUs: A Practical OpenVINO Guide

May 25, 2026

Ditch the expensive GPUs. This guide shows you how to use Intel OpenVINO and 4-bit quantization to run LLMs like Llama 3 on standard CPUs with production-grade performance.

HomeLab

Stop Renting Your Music: Build a Private Streaming Server with Navidrome and Docker

May 25, 2026

Build a high-performance, private music server with Navidrome and Docker. Stop paying for Spotify and stream your FLAC/MP3 collection to any device using the Subsonic API.

DevOps

Service Discovery and Dynamic Configuration with HashiCorp Consul

May 25, 2026

Learn how to eliminate hardcoded IP addresses and manage microservices effectively using HashiCorp Consul for Service Discovery and Dynamic Configuration.

Database

Scaling Database Performance: A Practical Guide to Read Replicas in PostgreSQL and MySQL

May 24, 2026

Is your database hitting 100% CPU? This guide shows you how to implement Read Replicas in PostgreSQL and MySQL to offload traffic and keep your app fast.

HomeLab

Stop Adding Movies Manually: Deploy Jellyseerr on Docker for Your HomeLab

May 24, 2026

Automate your media library by deploying Jellyseerr on Docker. This guide shows you how to connect Jellyfin, Radarr, and Sonarr for a hands-off request system.

Beyond APT: A Field Guide to Snap, Flatpak, and AppImage

Native MySQL High Availability: A Practical Guide to InnoDB Cluster and Router

Shipping Cross-Platform: A Production-Grade Guide to Flutter and Dart

Self-Hosting Penpot on Docker: The Private, Open-Source Figma Alternative

Reboot Linux in Seconds: Using kexec to Skip BIOS and POST

Telepresence: Local Microservices Debugging Without the 10-Minute Rebuild

Stop Guessing: Use Flame Graphs to Pinpoint Linux CPU Bottlenecks

HTMX: Building Interactive Web Apps Without the JavaScript Fatigue

Ditch GRUB for systemd-boot: A Leaner, Faster Way to Boot Linux

Automating Prompt Optimization with DSPy: Declarative LLM Programming That Replaces Manual Prompt Engineering

PostgreSQL Performance Analysis with pg_stat_statements: Find and Fix Slow Queries

Stop Hardcoding SMTP: Set Up a Postfix Mail Relay for Linux Alerts

Stop Sending Users Across the Globe: Building GeoDNS with PowerDNS

Deploying Microsoft Phi-4 with Ollama: High-Performance SLMs for Edge and Local Hardware

Stop Writing API Clients by Hand: A Guide to OpenAPI Generator

High-Performance LLMs on Intel CPUs: A Practical OpenVINO Guide

Stop Renting Your Music: Build a Private Streaming Server with Navidrome and Docker

Service Discovery and Dynamic Configuration with HashiCorp Consul

Scaling Database Performance: A Practical Guide to Read Replicas in PostgreSQL and MySQL

Stop Adding Movies Manually: Deploy Jellyseerr on Docker for Your HomeLab