Vecstore vs Pinecone

Pinecone: 3 calls

// 1. Generate embedding
const embedding = await openai.embeddings
  .create({
    model: 'text-embedding-3-small',
    input: query
  });

// 2. Query Pinecone
const results = await index.query({
  vector: embedding.data[0].embedding,
  topK: 10
});

// 3. Fetch actual records
const ids = results.matches.map(m => m.id);
const records = await db.query(
  'SELECT * FROM items WHERE id = ANY($1)',
  [ids]
);

Vecstore: 1 call

const results = await fetch(
  `https://api.vecstore.app/databases/${dbId}/search`,
  {
    method: 'POST',
    headers: {
      'X-API-Key': apiKey,
      'Content-Type': 'application/json'
    },
    body: JSON.stringify({ query })
  }
);