{"id":"prototype-rag","slug":"prototype-rag","name":"Prototype RAG in a day","shortName":"Prototype RAG in a day","problemStatement":"Hackathon/demo RAG with minimal setup.","whenNotTopPick":"Production traffic — graduate immediately.","categoryIds":["cat-vector-memory"],"depotPickProviderId":"chroma","depotPickRationale":"dx first; reliability discounted.","runnersUpIds":["supabase-pgvector","pinecone","upstash-vector"],"weights":{"capabilityFit":0.25,"pricePerformance":0.18,"latencyReliability":0.15,"developerDx":0.15,"privacyPosture":0.1,"lockInRisk":0.07,"maturity":0.1},"methodologyNotes":"dx first; reliability discounted.","tags":["prototype"],"depth":{"whenNotToUse":{"text":"Production traffic — graduate immediately.","source":"editorial `whenNotTopPick` (data/jtbds.json)"},"whenNotToUseReason":null,"runnerUp":{"providerId":"supabase-pgvector","name":"Supabase (pgvector)","overallForJob":8.64,"pickOverallForJob":7.88,"beatsPickOn":["capabilityFit","latencyReliability","developerDx","privacyPosture","maturity"],"source":"first resolvable entry of the job's editorially ranked `runnersUpIds`; scores are stored job-weighted scores"},"runnerUpReason":null,"lockIn":{"pickLockInRisk":2.5,"runnerUpLockInRisk":3,"scale":"0–10 stored curated estimate; higher = more lock-in (worse)","pickExitSignals":["open source (provider tag `oss`)"],"runnerUpExitSignals":[],"pickNotes":[],"selfHostFallback":[{"id":"chroma","name":"Chroma","license":"Apache-2.0","sourceUrl":"https://github.com/chroma-core/chroma/blob/main/LICENSE"}],"migration":"The pick has lower stored lock-in risk than runner-up Supabase (pgvector) (2.5 vs 3). Pick exit signals: open source (provider tag `oss`). Self-host fallback listed for this job: Chroma.","migrationReason":null,"derivedFrom":"stored lockInRisk scores, provider tags (oss, self-host, openai-compat, open-models), free rows that list this job, and verbatim provider notes. No migration guide was invented."}},"freshness":{"pick":{"score":{"asOf":"2026-09-14","ageDays":43,"stale":true,"staleAfterDays":30,"reason":null},"lastReviewed":{"asOf":"2026-09-14","ageDays":43,"stale":true,"staleAfterDays":30,"reason":null},"sourceCheck":{"checkedAt":"2026-10-27","sourceUrls":3,"sourcesReachable":3,"pricingRows":0,"pricingRowsReconfirmed":0,"note":"A source re-check confirms the page is reachable and, for pricing rows, that the stored amount and SKU name appear on it. It does not re-derive or change the score.","reason":null}}},"depotPick":{"id":"chroma","slug":"chroma","name":"Chroma","tagline":"Prototype on Chroma; graduate to Qdrant/pgvector/Pinecone before your corpus and QPS grow up.","overall":7.88},"runnersUp":[{"id":"supabase-pgvector","slug":"supabase-pgvector","name":"Supabase (pgvector)","tagline":"Depot default for most agent apps under ~25–50M vectors. Don't add Pinecone until Postgres actually hurts.","overall":8.64},{"id":"pinecone","slug":"pinecone","name":"Pinecone","tagline":"Still the zero-ops vector default. If you already run Postgres, try pgvector before paying Pinecone rents.","overall":7.95},{"id":"upstash-vector","slug":"upstash-vector","name":"Upstash Vector","tagline":"Prototype/edge RAG peer when you already on Upstash. Prefer Qdrant/Pinecone for serious filtered production…","overall":8.15}]}