
WRITINGS & INSIGHTS
Thoughts & Articles
Practical insights on full-stack development, Shopify engineering, AI, performance, and building production software.
EngineeringSep 19, 2026•28 min read
PostgreSQL + pgvector: Building Semantic Search and RAG Without a Separate Vector Database
A complete, practical tutorial for adding semantic search, hybrid search, and RAG to an existing PostgreSQL application using pgvector — covering embeddings, HNSW, metadata filtering, Reciprocal Rank Fusion, and background embedding pipelines.

EngineeringNov 3, 2026•13 min read
React Performance Optimization: A Practical Guide to Faster Rendering
A practical guide to React performance: memo, useMemo, useCallback, state placement, list keys, virtualization, lazy loading, and context — plus when not to optimize at all.

© 2025 Yash Nandvana. All rights reserved