Hosted Vector Stores vs. Rolling Your Own

Ma Mahalakshmi V Updated 16 Sep 2026
8 min read ·Lesson 45 of 224

Two Ways to Build the Same Capability

Lessons 1 through 3 built a complete, working retrieval pipeline entirely by hand: generate embeddings, store them alongside their source text and metadata, and rank stored documents against a query using cosine similarity. Unit 9, Lesson 2 covered a different way to get the same underlying capability: create a vector store, upload documents to it, and let the platform's file search tool handle chunking, embedding, and search internally. This lesson puts those two approaches side by side directly, since choosing between them — or knowing when to combine them — is one of the most consequential decisions in designing a retrieval system.

What a Hosted Vector Store Actually Handles for You

A hosted vector store, as Unit 9, Lesson 2 introduced it, takes care of an entire pipeline internally: splitting an uploaded document into appropriately-sized chunks, generating an embedding for each chunk, storing those embeddings in a way that scales to large collections, and executing similarity search efficiently — potentially using an approximate nearest-neighbor index rather than a naive linear scan, exactly the concern Lesson 3 raised about scaling a hand-rolled search.

vector_store = client.vector_stores.create(name="Policy Documents")

with open("return_policy.pdf", "rb") as f:
    client.vector_stores.files.upload(vector_store_id=vector_store.id, file=f)

response = client.responses.create(
    model="gpt-5.6-terra",
    input="How long do I have to return an item?",
    tools=[{"type": "file_search", "vector_store_ids": [vector_store.id]}],
)

Every one of the individual steps Lessons 1 through 3 built by hand — embedding generation, chunk-level storage, similarity ranking — happens inside this call, invisibly. This is the appeal of the hosted approach: a working retrieval system in a handful of lines, with no decisions required about chunk size, storage format, or which similarity metric to use.

What Rolling Your Own Actually Requires

The custom pipeline built across Lessons 1 through 3 requires deciding and implementing every one of those same steps explicitly: choosing how to split documents into pieces before embedding them (a step this course has not covered in depth but which any hand-rolled pipeline over documents longer than a paragraph or two eventually needs to address), choosing a storage format appropriate to the collection's scale, writing and maintaining the similarity search logic itself, and handling the transition to a more sophisticated index if and when a naive linear scan stops being fast enough.

def embed_and_store(client, texts: list[str]) -> list[dict]:
    response = client.embeddings.create(model="text-embedding-4", input=texts)
    return [{"text": text, "embedding": data.embedding} for text, data in zip(texts, response.data)]

def cosine_similarity(vector_a: list[float], vector_b: list[float]) -> float:
    import math
    dot_product = sum(a * b for a, b in zip(vector_a, vector_b))
    magnitude_a = math.sqrt(sum(a * a for a in vector_a))
    magnitude_b = math.sqrt(sum(b * b for b in vector_b))
    if magnitude_a == 0 or magnitude_b == 0:
        return 0.0
    return dot_product / (magnitude_a * magnitude_b)

def semantic_search(client, query: str, stored_documents: list[dict], top_k: int = 3) -> list[dict]:
    query_vector = client.embeddings.create(model="text-embedding-4", input=query).data[0].embedding
    scored = [
        {"text": doc["text"], "score": cosine_similarity(query_vector, doc["embedding"])}
        for doc in stored_documents
    ]
    scored.sort(key=lambda d: d["score"], reverse=True)
    return scored[:top_k]

None of this is difficult, as Lessons 1 through 3 demonstrated, but every one of these functions is now something you own: you are responsible for its correctness, its performance as the collection grows, and any bugs it develops, in a way that a hosted vector store's internal implementation simply isn't your responsibility to maintain.

Comparing the Two Approaches Directly

AspectHosted vector store (Unit 9, Lesson 2)Rolling your own (Lessons 1-3)
Setup effortMinimal — create a store, upload filesSignificant — embedding, storage, and search logic all written by you
Control over chunkingAutomatic, limited direct controlFull control over how and when documents are split
Control over similarity metricFixed to whatever the platform uses internallyAny metric you choose to implement
Scaling to large collectionsHandled by the platformYour responsibility — a linear scan needs replacing with a proper index at scale
Combining retrieval with other custom logicLimited to what the tool's parameters expose (filters, result count)Unlimited — you can combine similarity with any other ranking signal you write
Data source flexibilityBuilt around uploadable documentsWorks with any data source you can turn into text, including non-document data
Ongoing maintenanceNone — the platform maintains the retrieval infrastructureYours — bugs, performance issues, and scaling concerns are your responsibility
Cost modelStorage and retrieval pricing set by the platformEmbedding API costs plus your own storage and compute infrastructure

Neither row in this table makes one approach strictly better; each is a genuine trade-off between convenience and control.

When to Choose a Hosted Vector Store

For the majority of retrieval-augmented use cases — answering questions from a company's internal documentation, building a support assistant grounded in policy documents, searching a collection of PDFs or text files — a hosted vector store is the right default. The documents are naturally file-shaped, the platform's default chunking and similarity behavior is good enough for the task, and there is no requirement to combine semantic similarity with a custom ranking signal the built-in tool doesn't expose. Choosing the hosted approach here isn't a compromise; it's simply not paying an implementation and maintenance cost for a capability that's already available and well-built.

When to Roll Your Own

A custom pipeline earns its additional complexity when a specific requirement genuinely falls outside what a hosted vector store supports: retrieval over data that isn't naturally document-shaped (structured database records, short user-generated snippets, product listings assembled from several fields), a need for a similarity metric other than whatever the platform uses internally, a need to combine semantic similarity with other ranking signals a hosted store's parameters don't expose (recency weighting, a business-specific boost, a signal from a different part of the system entirely), or a requirement to inspect, audit, or directly manipulate the embedding vectors themselves — none of which a hosted vector store is designed to expose, since it deliberately treats the underlying vectors as an internal implementation detail.

def rank_with_custom_signal(query_score: float, recency_weight: float, popularity_score: float) -> float:
    """Illustrative — combining a semantic similarity score with other signals
    that a hosted vector store's built-in ranking has no way to express."""
    return (query_score * 0.7) + (recency_weight * 0.2) + (popularity_score * 0.1)

A weighted combination like this — semantic similarity blended with recency and popularity — is exactly the kind of custom ranking logic a hosted vector store's fixed internal ranking cannot accommodate, and exactly the kind of case where the extra implementation cost of a hand-rolled pipeline is worth paying.

A Middle Ground: Starting Hosted, Migrating If Needed

A practical strategy for a new application is to start with a hosted vector store by default, given its low setup cost, and migrate to a custom pipeline only if a specific, concrete limitation is actually encountered — rather than guessing upfront that custom retrieval logic will eventually be needed and building it prematurely.

def should_consider_custom_pipeline(needs_custom_metric: bool, needs_non_document_data: bool, needs_custom_ranking_signals: bool) -> bool:
    """Illustrative decision check — a custom pipeline is worth its added cost
    only when a hosted vector store demonstrably can't meet a real requirement,
    not merely because building one yourself is possible."""
    return needs_custom_metric or needs_non_document_data or needs_custom_ranking_signals

print(should_consider_custom_pipeline(False, True, False))  # True — non-document data source

This mirrors a pattern this course has applied repeatedly to other built-versus-buy decisions — reasoning effort settings (Unit 3), image resolution (Unit 7), and the built-in tools of Unit 9 generally: default to the simpler, platform-provided option, and escalate to a custom implementation deliberately, when a specific requirement demonstrates the default genuinely isn't enough, rather than as a default starting posture.

Common Mistakes

Building a custom embeddings and retrieval pipeline by default, before checking whether a hosted vector store would already meet the actual requirements, and taking on unnecessary implementation and maintenance cost as a result.

Choosing a hosted vector store for a use case that genuinely needs a custom similarity metric or ranking signal, and then working around the tool's fixed behavior with awkward workarounds instead of building the custom pipeline the use case actually calls for.

Underestimating the ongoing maintenance cost of a hand-rolled retrieval pipeline, treating it as a one-time implementation effort rather than a system that needs to keep scaling and working correctly as the underlying collection grows and changes.

Assuming a custom pipeline will eventually be necessary and building one preemptively, rather than starting with the simpler hosted option and migrating only once a concrete limitation is actually encountered.

Best Practices

Default to a hosted vector store (Unit 9, Lesson 2) for standard document-based retrieval, reserving a custom pipeline for cases with a specific, concrete requirement the hosted tool doesn't support.

Identify the specific limitation driving a decision to build custom retrieval logic, rather than building one out of a general sense that more control is always better.

Weigh the ongoing maintenance burden of a custom pipeline honestly against its flexibility benefit, since the cost of a hand-rolled system is not just the initial implementation but everything required to keep it correct and performant over time.

Start with the simpler option and migrate only when a real limitation is encountered, rather than guessing upfront which approach a use case will eventually need.

0 Comments

Reviewed before they appear

No comments yet.

OpenAI SDK
Introduction to the OpenAI SDK Setting Up Python Creating an API Key Your First Call — client.responses.create() and response.output_text Understanding Billing, Credits, and What a Request Costs Why Responses Replaced Chat Completions Anatomy of a Request: model, input, and instructions Anatomy of a Response: The Typed output Array, Not Just Text Roles: User, Assistant, and Developer/System Choosing a Model, and Reading the Models Page Instead of Memorizing Names Instructions vs. Input Writing Prompts That Get Consistent Results Few-Shot Examples Reasoning Models and the reasoning Parameter Debugging a Prompt That Misbehaves Why Streaming Matters for User Experience stream=True and Iterating Over Events Handling the Event Types You Actually Care About Background Mode for Long-Running Jobs Project — Add Live Streaming to Your Chatbot The Problem With Parsing Free Text JSON Schema and Strict Mode Pydantic Models With the SDK's Parse Helpers Handling Refusals and Validation Failures Project — A Resume-to-JSON Extractor Working With input_image input_file, PDFs, and the Files API Image Generation Speech-to-Text and Text-to-Speech Project: A PDF Question-Answering Script What Function Calling Is Defining a Tool Schema The Full Loop Multiple Tools Errors, Timeouts, and Untrusted Arguments Project: A Weather Assistant Web Search File Search and Vector Stores Code Interpreter Remote MCP Servers and Connectors Project: A Research Assistant What an Embedding Is, Without the Maths Generating and Storing Embeddings Similarity Search From Scratch Hosted Vector Stores vs. Rolling Your Own A Small RAG App Over a Folder of Notes Agents vs. a Single API Call — When You Need One pip install openai Giving Agents Tools Handoffs and Multi-Agent Triage Guardrails and Approvals Tracing and Observing What Your Agent Did A Multi-Agent Support Desk Error Codes and What Each One Means Retries, Timeouts, and Backoff Rate Limits and Spend Limits Prompt Caching and Cost Optimisation The Batch API for Bulk Work Async Clients and Concurrency Moderation and Safety Best Practices Designing the App Backend With FastAPI Streaming to a Simple Frontend Deploying and a Cost/Safety Checklist Why Web Search Is Useful for Current Information Using the Web Search Tool with the Responses API Configuring Search Behavior for Application Use Cases Understanding Citations and Source Attribution Where to Go Next Building a Research Assistant with Web Search Combining Web Search with Structured Outputs Handling Conflicting or Low-Quality Web Sources Reducing Unsupported Claims with Grounded Generation Testing Freshness-Sensitive AI Answers Production Considerations for Web-Grounded Applications Understanding File Search and Retrieval-Augmented Generation Creating and Organizing Vector Stores Uploading Documents for Retrieval Connecting Vector Stores to Responses API Requests Designing Document Metadata and Filtering Strategies Building a PDF Question-Answering Application Improving Retrieval Quality With Better Document Preparation Handling Missing Evidence and Retrieval Failures Combining File Search With Web Search Building a Production Knowledge-Base Assistant What the Code Interpreter Tool Is Designed For Running Python-Based Analysis Through the OpenAI SDK Uploading Datasets for Analysis Analyzing CSV and Spreadsheet Data Generating Charts and Data Summaries Handling Generated Files and Downloadable Artifacts Building a Data-Analysis Assistant Combining Code Execution with Structured Outputs Validating Generated Calculations and Results Security and Sandbox Considerations for Code Execution Understanding Multimodal Input with the OpenAI SDK Sending Images to a Model Image Analysis from URLs and Uploaded Files Extracting Text and Information from Screenshots Building an Image-Question-Answering Application Combining Image Input with Structured Output Analyzing Multiple Images in One Request Handling Image Quality and Input Limitations Designing Multimodal Prompts for Reliable Results Building a Practical Vision-Powered Python Application Understanding Speech-to-Text and Text-to-Speech Workflows Transcribing Audio with the OpenAI SDK Working with Uploaded Audio Files Handling Timestamps and Transcription Metadata Building a Meeting Transcription Workflow Generating Spoken Responses from Text Handling Long Audio and Processing Failures Combining Audio with Text and Tool Calling Building an End-to-End Python Voice Application What Embeddings Are and When to Use Them Generating Embeddings With the OpenAI API Preparing Text for Embedding Comparing Vectors With Cosine Similarity Building a Simple Semantic Search Engine in Python Storing Embeddings in a Database Metadata Filtering for Semantic Search Chunking Strategies for Better Retrieval Evaluating Semantic Search Quality Building a Document Similarity Application When Batch Processing Makes Sense Designing Large-Volume AI Processing Pipelines Using Asynchronous Python with the OpenAI SDK Running Concurrent Requests Safely Controlling Concurrency and Avoiding Rate Limits Tracking Batch Job Progress Handling Partial Failures in Bulk Workloads Retrying Failed Items Without Duplicating Successful Work Designing Resumable AI Processing Jobs Building a Production Batch-Processing Pipeline Batch Processing Makes Sense Large-Scale AI Processing Pipelines Async Python with OpenAI SDK Safe Concurrent Requests Concurrency & Rate Limits Batch Progress Tracking Partial Failure Handling Safe Retry Handling Resumable AI Jobs Production Batch Pipeline System–User Data Separation Reusable App Instructions Prompt Templates & Variables Extraction & Classification Prompts Summarization & Transformation Prompts Explicit Output Requirements Prompt Version Management Prompt Testing & Evaluation Reusable Python Prompt Library API Key Security Secure API Key Storage Secure Secret Management Prompt Injection Prevention Trusted vs. Untrusted Content Tool Argument Validation Sensitive Data Handling Secure Logging AI Action Authorization Production AI Security Checklist Why AI Applications Need Evaluation Beyond Unit Tests Unit Testing OpenAI SDK Integration Code Mocking API Responses in Python Tests Testing Structured Outputs Against Schemas Testing Tool-Calling Workflows Building a Small Evaluation Dataset Measuring Accuracy, Consistency, and Failure Rates Regression Testing Prompts and Model Changes Human Evaluation Versus Automated Evaluation Creating a Repeatable Evaluation Pipeline AI Request Monitoring Token Cost Management Usage Metrics Design Reducing Model Calls Prompt & Context Optimization Model Selection & Optimization AI Caching Strategies Interactive Latency Optimization Usage Dashboards & Budget Alerts Performance & Cost Checklist Every API Call Starts Fresh Fixing API Statelessness Server-Side Conversation Memory Limits of Response Chaining What We're Building Conversation Memory Challenges Preparing an OpenAI SDK Application for Deployment Environment-Specific Configuration for Development and Production Deploying a Python AI Service with Docker Container Health Checks and Startup Configuration Managing Secrets in Cloud Deployments Background Workers for Long-Running AI Tasks Queues and Asynchronous Job Architectures Scaling AI Workloads Horizontally Monitoring Production Incidents and Failures Production Deployment Checklist for OpenAI SDK Applications Reusable OpenAI Service Classes AI Client Dependency Injection Typed AI Responses Python Configuration Management AI Request Decorators Centralized AI Error Handling Clean SDK Abstractions Reusable OpenAI Utilities Internal AI Python Libraries SDK Integration Maintenance Production AI Chatbot Document Q&A System Web Research Assistant Customer Support Agent AI Data Analysis Assistant Image Analysis App Meeting Transcription & Summary Semantic Document Search Multi-Tool AI Agent Production OpenAI SDK App Why "It Looked Fine When I Tested It" Isn't Enough Timing Note Status Note Pre-Decision Status Note Current Availability Note
Ask about this post
AI Ask about this post

Ask questions about Hosted Vector Stores vs. Rolling Your Own and get answers drawn from it.

Signed-in readers only.