Do I need a dedicated vector database?

Not at first. pgvector in PostgreSQL handles millions of embeddings well. Move to Pinecone or similar when scale or latency demands it, which is rarer than vendors suggest.

Data

PostgreSQL

PostgreSQL as the default database, with pgvector for retrieval when a separate vector store is not justified.

How I use it

PostgreSQL is my default for anything relational. For RAG systems at small and medium scale I often use pgvector inside it rather than adding a separate vector database, because one database is one fewer thing to operate. I have also shipped on SQL Server in an enterprise .NET environment.

Offered through

Shipped with PostgreSQL

All projects →

Shapes.inc

Platform to create AI-powered 'shapes' (models) with customizable traits like audio, personality, and reasoning, featuring Discord bot integration and private SDK

South Carolina First Steps

Multi-tenant web application for managing household enrollments in South Carolina's First Steps program with role-based access and WCAG 2.0 compliance

Questions clients ask about PostgreSQL

Do I need a dedicated vector database?: Not at first. pgvector in PostgreSQL handles millions of embeddings well. Move to Pinecone or similar when scale or latency demands it, which is rarer than vendors suggest.

Work with me

Need PostgreSQL work done?

I work remotely with clients across the US, Canada, the UK, the UAE, Brazil and Australia. Tell me what you are building and I will reply with questions, a plan and an estimate.

Email me Hire on Upwork All services

MongoDB