postgresql - Abrarqasim Blogs

pgvector in 2026: Why I Deleted Pinecone From Half My Side Projects

pgvector plus HNSW replaced Pinecone on half my side projects. The schema, the index picks, hybrid search with FTS, and where I still reach for…

Rayyan | July 10, 2026 | 10 min

Postgres Full-Text Search in 2026: When I Reach For It Over Elasticsearch

Real experience with Postgres full-text search in 2026: when tsvector and GIN indexes beat Elasticsearch, and the queries I actually ship in production.

Rayyan | July 8, 2026 | 9 min

PostgreSQL JSONB in 2026: When I Reach for It (and When I Don’t)

JSONB in Postgres is great in the right place and a slow tax everywhere else. Here's the decision tree, indexing tips, and ORM patterns I…

Rayyan | May 9, 2026 | 8 min