ITNotes - Page 50 of 143 - From Terminal to Cloud

PostgreSQL pg_trgm: Build Fuzzy Search, Typo-Tolerant Queries, and Autocomplete with Trigram Indexes

June 28, 2026

Learn how to use PostgreSQL's pg_trgm extension to build fuzzy search that handles typos, powers autocomplete, and accelerates LIKE queries with trigram indexes. Includes practical GIN index setup, similarity threshold tuning, and hybrid search patterns.

Linux

Mount Remote Storage as Local Drives: A Guide to FUSE and SSHFS on Linux

June 28, 2026

Learn how to use FUSE and SSHFS to mount remote directories and cloud storage as local drives on Linux. This guide covers installation, performance tuning, and how to manage mounts without root access.

Database

Self-Hosting Apache Superset with Docker: Stop Exporting CSVs and Start Visualizing

June 25, 2026

Ditch expensive BI tools and manual SQL exports. This guide shows you how to deploy Apache Superset on Docker, connect your databases, and optimize performance for a professional dashboard experience.

DevOps

Beyond ‘Works on My Machine’: Testing Ansible Playbooks with Molecule and Docker

June 25, 2026

Move beyond manual testing. Discover how to use Molecule and Docker to automate Ansible playbook verification, ensuring your infrastructure is reliable and idempotent.

Machine Learning Directly in PostgreSQL: Train and Predict Using SQL

June 25, 2026

Stop moving data. Learn how to train and deploy XGBoost and Scikit-learn models directly inside PostgreSQL using PostgresML and standard SQL queries.

Database

ERD Design with dbdiagram.io: From Concept to Auto-Generated SQL

June 24, 2026

Jumping straight into SQL without a plan leads to messy schemas that are painful to refactor later. This guide walks through designing an ERD with dbdiagram.io using DBML syntax, then automatically exporting production-ready SQL — no boilerplate required.

How to Deploy Arize Phoenix on Docker: Monitor and Debug LLM, RAG, and AI Agents in Real Time

June 24, 2026

Arize Phoenix is an open-source observability platform that gives you full trace visibility into every LLM call, RAG retrieval step, and AI agent action in real time. This guide walks you through deploying it with Docker and connecting your Python app to start monitoring prompts, completions, latency, and evaluation scores from day one.

Database

DBeaver Guide: Manage PostgreSQL, MySQL, and SQL Server from One Interface

June 24, 2026

Managing PostgreSQL, MySQL, and SQL Server from separate native tools is fine until you're debugging across all three at 2 AM. This guide covers how to set up DBeaver as a single unified interface for all your databases — including SSH tunnels, connection organization, cross-database queries, and data export between database types.

LLM Merging with Mergekit: Build Custom Models Without the GPU Tax

June 24, 2026

Ditch the expensive GPU rentals. Learn how to use Mergekit on Linux to fuse LLMs using SLERP, TIES, and Passthrough techniques for custom AI performance.

Programming

Beyond the Basics: Hardening Microservices with Resilience4j and Spring Boot

June 24, 2026

Don't let one failing microservice take down your entire system. Learn how to implement Resilience4j Circuit Breakers, Retries, and Rate Limiters with production-ready configurations.

Fast LLM Fine-Tuning with Unsloth on Linux: Cut 80% VRAM on Consumer GPUs

Mastering ScyllaDB on Docker: Deploying Ultra-Fast C++ NoSQL for High-Throughput Writes

Building an Internal Developer Portal with Spotify Backstage: Software Catalog, TechDocs, and Platform Automation

Kubernetes Disaster Recovery with Velero and MinIO: Complete Cluster Backup Guide

Build Real-Time Apps with Phoenix LiveView: Server-Side State Without JavaScript

Deploy a TACACS+ Server on Linux with tac_plus: Centralized AAA and Command Authorization

Deploy Immich on Docker: Self-Hosted Google Photos Alternative with AI

GitOps for HomeLab: Automate Kubernetes and K3s Deployments with Argo CD

Structured Data Extraction with BAML and Python: Faster LLM Output and Visual Prompt Testing

Mastering HugePages and Transparent HugePages on Linux for PostgreSQL and Redis

PostgreSQL pg_trgm: Build Fuzzy Search, Typo-Tolerant Queries, and Autocomplete with Trigram Indexes

Mount Remote Storage as Local Drives: A Guide to FUSE and SSHFS on Linux

Self-Hosting Apache Superset with Docker: Stop Exporting CSVs and Start Visualizing

Beyond ‘Works on My Machine’: Testing Ansible Playbooks with Molecule and Docker

Machine Learning Directly in PostgreSQL: Train and Predict Using SQL

ERD Design with dbdiagram.io: From Concept to Auto-Generated SQL

How to Deploy Arize Phoenix on Docker: Monitor and Debug LLM, RAG, and AI Agents in Real Time

DBeaver Guide: Manage PostgreSQL, MySQL, and SQL Server from One Interface

LLM Merging with Mergekit: Build Custom Models Without the GPU Tax

Beyond the Basics: Hardening Microservices with Resilience4j and Spring Boot