#tutorial
9 articles tagged with #tutorial
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.
Traefik Middleware Patterns for Production β What Actually Works After 6 Months
After migrating 47 Ingress resources from NGINX to Traefik, I learned which middleware patterns survive contact with production. Here are 6 that do β with real YAML and the mistakes I made so you don't have to.
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εΊθ―.
Docker Compose Patterns Every Developer Should Know
From health checks to profiles, these Docker Compose patterns will save you hours of debugging and make your dev workflow actually enjoyable.
Git Rebase vs Merge: When to Use Which (2026 Edition)
After years of flame wars and bad rebase-induced incidents, here's the pragmatic rule set I actually follow for branching strategy.
TypeScript 5.x: The Features That Make Type-Safe Code Actually Enjoyable
TypeScript 5 brought const type parameters, using declarations, and decorators. Here's what actually improves your day-to-day coding.
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.