ITNotes - Page 26 of 119 - 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.

Speed Up Python with Numba JIT: Make Heavy Data Processing 100x Faster

CDK for Terraform (CDKTF) with Python: Deploy Cloud Resources Without Writing HCL

Clean Up Your Java Code: A Practical Guide to Vavr

Stop Deploying Broken Docker Images: A Guide to Container Structure Tests

Mastering Golang Memory Profiling: A Practical Guide with pprof

Stop Storing Secrets in Git: A Guide to 1Password Connect on Kubernetes

Building a Network Performance Testbed: High-Speed Testing with TRex on Linux

Stop Writing Boilerplate: A Guide to Python Dataclasses, Attrs, and Pydantic

Build Your Own Private 5G Network: A Hands-On Guide with Open5GS and srsRAN

Mastering Socket.IO in Node.js: Building Secure, Production-Ready Real-Time Apps

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