Tagged articles
pgvector
21 articles · Page 1 of 1
Laravel 13 ships a provider-agnostic AI SDK with agents, tool calling, and multimodal support, adds native pgvector-powered semantic search, JSON:API resources, PHP attributes for declarative configuration, CSRF hardening, centralized queue routing, and atomic cache renewal — all with a near-zero-breaking-change upgrade path from Laravel 12.
AI SDKCSRFCache Touch
0 likes · 14 min read

This final installment of a 12-part RAG series demonstrates a complete, deployable enterprise knowledge base system using Spring Boot 3.2, Spring AI 2.0, PgVector, BGE embeddings, hybrid retrieval with RRF fusion, reranking, multi-turn chat with memory, and a Vue 3 frontend, including Docker deployment and production checklist.
BGEEnterprise Knowledge BaseHybrid Retrieval
0 likes · 16 min read

MaxKB is an open-source AI knowledge base Q&A system from Fit2Cloud that uses RAG with pgvector and LangChain to provide model-neutral, out-of-the-box intelligent question answering, supporting Docker deployment, multi-format documents, visual workflows, and zero-code embedding via iframe or API for enterprise knowledge bases, customer service, and developer portals.
LLMLangChainMaxKB
0 likes · 18 min read

This comprehensive guide covers end-to-end RAG system operations, from vector database selection and workload profiling to HNSW parameter tuning, filtering strategies, index freshness monitoring, embedding upgrades, capacity planning, backup validation, and troubleshooting methodologies with concrete examples and evaluation frameworks.
Backup RecoveryHNSWMilvus
0 likes · 64 min read

This article details the evolution of a product semantic recall system using Spring AI Embedding, covering architecture design, reliable vector indexing with Outbox pattern, hybrid search fusion, pgvector HNSW tuning, and safe migration to Milvus, with production readiness criteria and observability practices.
EmbeddingMilvusOutbox Pattern
0 likes · 20 min read

This article compares PostgreSQL and MySQL across complex query optimization, data types, MVCC implementation, transaction rollback capabilities, and cloud ecosystem support, explaining why PostgreSQL is increasingly preferred for complex analytics, vector search, and geospatial applications.
Cloud NativeJSONBMVCC
0 likes · 6 min read

The author shares hands‑on experiences with Milvus, pgvector, and Qdrant, detailing performance at different data scales, index trade‑offs, operational complexity, and provides practical guidance on selecting the most suitable vector database for a RAG system.
MilvusQdrantRAG
0 likes · 6 min read


ITPUBAug 5, 2026 · Artificial Intelligence
An interview story reveals that storing embeddings in MySQL forces a full‑table scan, leading to second‑level latency, while production‑grade RAG requires a vector database with ANN indexing such as HNSW or IVFFLAT, offering millisecond response, high recall, and scalable storage.
ANNHNSWIVFFLAT
0 likes · 20 min read


XikeAug 4, 2026 · Artificial Intelligence
This article introduces xi‑ops, an open‑source AI assistant that lets users query data and troubleshoot incidents with natural language while enforcing strict execution rights and key management, and details its architecture, security principles, deployment model, and first‑phase feature set.
AI assistantOperational AISecurity
0 likes · 10 min read

PostgreSQL is attracting renewed interest not because it magically becomes an all‑purpose AI database, but because AI applications in production demand a unified, consistent platform that can manage business records, vector embeddings, agent state, permissions and tooling, and PostgreSQL’s extensible ecosystem—pgvector, serverless architectures, branching, and MCP—offers exactly that blend of relational reliability and AI‑native capabilities.
AIDatabase BranchingMCP
0 likes · 15 min read

This article walks Java developers through turning Spring AI into an enterprise‑grade AI agent that can query internal databases, access a vector‑based knowledge base, enforce role‑based permissions, persist chat sessions in Redis, add full observability, and be container‑deployed with Docker and Kubernetes.
AI AgentJavaSpring AI
0 likes · 10 min read

The article explains why RAG systems cannot rely on MySQL for embedding storage, shows the O(n) brute‑force search latency for hundreds of thousands of chunks, and demonstrates how vector databases with ANN indexes such as HNSW or IVFFLAT provide millisecond‑level response, high recall, and scalable storage.
ANNHNSWRAG
0 likes · 19 min read

An end‑to‑end multi‑agent Retrieval‑Augmented Generation platform is presented, featuring compositional reasoning, systematic multi‑dimensional evaluation, and a controlled prompt‑improvement loop that automatically identifies weak prompt dimensions, proposes diffs, and requires human approval before deployment, with full observability via SSE and persisted logs.
EvaluationFastAPIRAG
0 likes · 19 min read


ITPUBMay 13, 2026 · Databases
The article questions whether dedicated vector databases are truly needed for AI applications, examining market hype, the rapid emergence of many vector‑DB products, real‑world examples like PostgreSQL pgvector and major vendor integrations, and the hidden costs of data fragmentation and operational complexity.
AIPostgreSQLRAG
0 likes · 15 min read

PostgreSQL’s extensible architecture lets it evolve from a relational DB into a true multi‑model system supporting graphs, vectors, full‑text, time‑series, GIS and key‑value data, with detailed architecture explanations, practical code demos, cross‑model queries, extension selection, and production‑grade best‑practice tips.
Apache AGEJSONBPostGIS
0 likes · 39 min read

GBrain, an open‑source AI memory hub created by YC partner Garry Tan, combines Postgres tsvector keyword search with pgvector semantic search via RRF, manages thousands of Markdown notes, and runs an automated nightly agent that refines and links memories, offering a practical long‑term recall layer for agents like OpenClaw and Hermes.
AI MemoryGBrainHermes
0 likes · 4 min read

This comprehensive guide explains how to design, implement, and operate a production‑ready Retrieval‑Augmented Generation (RAG) platform using Spring AI and PostgreSQL PGVector, covering architecture, indexing, hybrid retrieval, prompt engineering, scaling, security, observability, deployment, and common pitfalls for enterprise knowledge‑base applications.
Enterprise AIHybrid RetrievalRAG
0 likes · 42 min read

This guide explains why pure vector retrieval often fails for version‑specific queries, introduces hybrid search that combines semantic and keyword matching, and provides step‑by‑step code and SQL examples for enabling PgVector hybrid search in LangChain4j 1.11.0.
LangChain4jRAGSQL
0 likes · 11 min read

The article examines how PostgreSQL’s latest pgvector 0.8.0 release adds iterative index scans and smart query planning, enabling fully free vector search within an existing relational database, compares performance, cost, and architecture against dedicated vector databases like Pinecone, and outlines migration steps and best‑practice guidelines.
AIPostgreSQLbenchmark
0 likes · 14 min read


ITPUBNov 15, 2024 · Databases
This article explains the need for vector databases in the AI era, reviews PostgreSQL's extensible ecosystem, compares vector‑database options, provides step‑by‑step PgVector installation and usage, shares operational best practices, performance tuning tips, and real‑world Qunar & Tujia case studies.
AIPerformance TuningPostgreSQL
0 likes · 27 min read

This article explains the necessity of vector databases for AI workloads, reviews the PostgreSQL ecosystem, compares vector database options, provides detailed PgVector installation and usage steps, shares operational best‑practices, performance tuning tips, and real‑world deployment cases at Qunar and Tujia.
AIPerformance TuningPostgreSQL
0 likes · 24 min read
