#database
6 articles tagged with #database
I Turned PostgreSQL Into a Multimodal Search Engine With pgvector β Here's How
Text, images, and audio β all searchable with one SQL query. I built a multimodal search pipeline using Gemini Embedding 2 + pgvector 0.8.0, and the results surprised me. Here's the real code, real gotchas, and when this actually makes sense.
Spring AI + RAG in Production: Structured Output, Ollama, and pgvector β What Actually Works
I built a production RAG pipeline with Spring AI, Ollama, and pgvector. Here's the structured output pattern, local dev setup, and the hybrid search approach that survived 6 months of real traffic.
HNSW vs IVFFLAT in pgvector: I Benchmarked Both, Here's What Actually Matters
IVFFLAT and HNSW are the two index types in pgvector. I benchmarked both on 500K embeddings β the winner depends on your workload, not the hype.
PostgreSQL Vector Search: pgvector Tricks I Wish I Knew Sooner
You don't need Pinecone or Weaviate. PostgreSQL with pgvector handles vector search, hybrid queries, and semantic retrieval β and it's already in your stack.
7 PostgreSQL Performance Tricks I Wish I Knew Earlier
Index tuning, query planning, and connection pooling β the PostgreSQL performance techniques that made my apps 10x faster. NoεΊθ―.
PostgreSQL Tricks I Wish I Knew 5 Years Ago
After years of writing raw SQL in production, these are the PostgreSQL features that actually changed how I think about databases.