#postgresql
6 articles tagged with #postgresql
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.
Rust + PostgreSQL: Building a Backend That Actually Scales β Without the JVM Tax
I built a production API with Rust, Axum, and PostgreSQL. Here's what the memory footprint, query performance, and deploy pipeline taught me about Spring Boot's blind spots.
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.