Skip to content

DEV Community

pgvector vs Pinecone: cost and performance

egor romanov on October 23, 2023

At Supabase, we believe that a combination of Postgres and pgvector serves as a better alternative to single-purpose databases like Pinecone for AI...

Read full post

awalias • Oct 23 '23

For anyone interested there's a good guide here on how to generate vector embeddings easily with pgvector on Supabase: supabase.com/docs/guides/ai/quicks...

and another guide here on how to build Q&A into something like a documentation site: supabase.com/docs/guides/ai/exampl...

Which can look something like this:

Lastly we have an awesome python library for interacting with vectors called vecs which you can find here: supabase.com/docs/guides/ai/python...

And works a bit like this:

# add records to the collection
docs.upsert(
    records=[
        (
         "vec0",           # the vector's identifier
         [0.1, 0.2, 0.3],  # the vector. list or np.array
         {"year": 1973}    # associated  metadata
        ),
        (
         "vec1",
         [0.7, 0.8, 0.9],
         {"year": 2012}
        )
    ]
)

Oliver Rice • Oct 23 '23

pumped for the pgvector 0.5.1 rollout! It'll make HNSW index builds even faster

egor romanov • Oct 23 '23

btw vecs library is the one we use in all our postgres+pgvector bencmarks 😉

supabase.com/docs/guides/ai/python... 👀

Steve_Val • Oct 23 '23

is there any advantage to using Python vs Javascript when working with pgvector?

egor romanov • Oct 23 '23

not really, but python is just more widely used. also vecs for example, exposes nice apis to make your life easier when working with vectors

Kamil Ogórek • Oct 23 '23

It's getting so easy these days 😌

Tyler Shukert • Oct 23 '23

The AI chat bot example app is really nice. Everyone looked l liked it when I demoed it at Deno Fest Tokyo!

Long Hoang • Oct 24 '23

👀 👀 👀

Greg Richardson • Oct 23 '23

So happy we can generate embeddings directly in edge functions now 🔥

Thor 雷神 • Oct 24 '23

This is so awesome, @huggingface for the win 🙌

Chase Granberry • Oct 23 '23

Amazing

Monica El Khoury • Oct 24 '23

Awesome! 🚀

Thor 雷神 • Oct 24 '23

The vecs library is great. Had me up and running building image search in no time 🚀

Navraj Chohan • Nov 10 '23

I created a simple wrapper to pgvector that is inspired by Pinecone's simplicity: github.com/UpMortem/simple-pgvecto...

timnpalmer • Oct 23 '23

This is a game changer.