Blog

Tutorials, guides, and insights on PostgreSQL, pgvector, and AI infrastructure.

pgvector with Node.js: Build Semantic Search on PostgreSQL
Latest
ยทRivestack Team

pgvector with Node.js: Build Semantic Search on PostgreSQL

Learn how to use pgvector with Node.js to store and query vector embeddings in PostgreSQL. Covers node-postgres, Drizzle ORM, OpenAI embeddings, HNSW indexes, and a complete RAG pipeline.

pgvector
nodejs
postgresql
vector search
RAG
typescript
Read more
Hybrid Search with pgvector and PostgreSQL Full-Text Search

Hybrid Search with pgvector and PostgreSQL Full-Text Search

Learn how to combine pgvector semantic search with PostgreSQL full-text search for better results. Covers reciprocal rank fusion, scoring, and production patterns.

pgvector
full-text search
hybrid search
Supabase pgvector Alternative: When to Move Vector Search to Managed PostgreSQL

Supabase pgvector Alternative: When to Move Vector Search to Managed PostgreSQL

Compare Supabase pgvector with focused managed PostgreSQL for vector-heavy workloads, including cost, latency, HNSW tuning, and migration paths.

Supabase
pgvector
PostgreSQL
pgvector Hosting Guide: How to Choose Managed PostgreSQL for Vector Search

pgvector Hosting Guide: How to Choose Managed PostgreSQL for Vector Search

A practical pgvector hosting checklist for production teams: storage, memory, HNSW indexes, backups, high availability, pricing, and migration support.

pgvector
hosting
PostgreSQL
pgvector HNSW Tuning on Managed PostgreSQL

pgvector HNSW Tuning on Managed PostgreSQL

Learn how to tune pgvector HNSW indexes on managed PostgreSQL, including ef_search, m, ef_construction, memory, filters, and storage latency.

pgvector
HNSW
PostgreSQL
Exoscale pgvector Alternative: Comparing European Managed pgvector Providers

Exoscale pgvector Alternative: Comparing European Managed pgvector Providers

Compare Exoscale managed pgvector with Rivestack for European teams running production RAG, semantic search, and vector-heavy PostgreSQL workloads.

Exoscale
pgvector
Europe
Elestio pgvector Alternative: Comparing Marketplace Hosting with Focused Managed PostgreSQL

Elestio pgvector Alternative: Comparing Marketplace Hosting with Focused Managed PostgreSQL

Compare Elestio managed pgvector with Rivestack for production vector search workloads, including infrastructure, tuning, pricing, and migration support.

Elestio
pgvector
managed PostgreSQL