RAG Archives - ITNotes

Building a Production-Ready Text-to-SQL Engine with Vanna.ai and Python

October 19, 2026

Build a reliable Text-to-SQL engine using Vanna.ai and Python. Learn how to index schema DDL, business rules, and golden queries while implementing production security guardrails.

Build Visual Document RAG with ColPali and Byaldi: Zero-OCR PDF Retrieval

October 18, 2026

Tired of broken OCR pipelines scrambling tables and charts? Learn how to implement visual document retrieval with ColPali and Byaldi to index complex PDF pages directly without text extraction.

Database

Building Hybrid Search in PostgreSQL: Combining pgvector and Full-Text Search with Reciprocal Rank Fusion (RRF) for RAG

October 17, 2026

Combine pgvector semantic search with PostgreSQL full-text search using Reciprocal Rank Fusion (RRF). Build a resilient, high-accuracy hybrid retrieval engine for production RAG systems without external vector databases.

Building Modular AI Pipelines with Haystack 2.0: A Clean Alternative to LangChain for Production RAG

October 16, 2026

Tired of opaque framework abstractions breaking in production? Discover how Haystack 2.0 uses explicit modular component architecture to build reliable, maintainable RAG pipelines and agents in Python.

Crawl4AI and Python: Extracting Clean Markdown for LLMs and RAG Systems

October 16, 2026

Raw HTML wrecks RAG pipelines with token bloat and noise. Here is how to use Crawl4AI and Python to scrape dynamic pages into clean, structured Markdown while reducing embedding token usage by over 50%.

Parsing Complex Documents with IBM Docling and Python for Production RAG Pipelines

October 12, 2026

A hands-on guide to using IBM Docling and Python for document parsing in production RAG systems. Extract complex tables, formulas, and layouts into clean semantic chunks.

Scaling PostgreSQL Vector Search: HNSW Tuning and Table Partitioning for Production RAG

October 11, 2026

Scaling enterprise RAG with PostgreSQL and pgvector demands more than basic indexes. Discover how combining HNSW index tuning with declarative partitioning dropped p95 query latency from 2.8s to 14ms across 8 million vectors.

Build a Lightweight Graph-Based RAG System with LightRAG and Python

October 9, 2026

Standard vector RAG fails when queries require multi-hop reasoning across docs, while enterprise GraphRAG setups run up massive token bills. Learn how to build a lean, dual-level Graph RAG pipeline in Python with LightRAG.

Database

Deploying Qdrant on Docker: A 6-Month Production Review for RAG and Semantic Search

October 5, 2026

A hands-on production review of running Qdrant on Docker for 20M+ embeddings. Includes Docker Compose templates, scalar quantization benchmarks, gRPC tuning, and Prometheus monitoring configs.

HomeLab

Deploy a Local AI Server with Ollama and Open WebUI on Docker: Self-Hosted RAG and Web Search

October 2, 2026

Build a self-hosted AI server using Ollama, Open WebUI, and SearXNG on Docker. Complete guide with GPU passthrough, local RAG document ingestion, and private web search.