Posts tagged "PostgreSQL"
Essays, field notes, and engineering write-ups by Al Amin Ahamed covering PostgreSQL — practical patterns, gotchas from production code, and lessons learned shipping real systems. Topics include architecture decisions, performance tuning, debugging stories, and integration notes you can apply directly to your own PostgreSQL work.
· 8 min read
Building a RAG Pipeline in Laravel with pgvector
How I built the AI chat on this site: chunking documents, generating embeddings with Voyage AI, storing them in pgvector, and answering questions with Claude.
· 8 min read
Hunting N+1 Queries in Laravel: Tools, Strict Mode, and Fixes
How to find N+1 queries with Telescope, Debugbar, and preventLazyLoading() — and the eager-loading patterns that fix them, including the polymorphic gotcha.
· 9 min read
10 Eloquent Query Optimizations, in Order of Effectiveness
A systematic optimization checklist for Eloquent — select(), chunk(), chunkById(), withCount(), pluck(), subquery selects, and when to bypass the model layer entirely.
· 9 min read
Semantic Search with pgvector and Laravel Scout
Add meaning-based search to your Laravel app using a custom Scout driver, pgvector HNSW index, and Voyage AI embeddings — with a hybrid keyword fallback.