{"id":"edge-sqlite-agent-db","slug":"edge-sqlite-agent-db","name":"Edge / per-tenant SQLite for agents","shortName":"Edge / per-tenant SQLite for agents","problemStatement":"Need many lightweight per-user or per-agent SQL databases at the edge (libSQL/SQLite), not a single Postgres or Redis cache.","whenNotTopPick":"Want shared serverless Postgres branching — Neon; Auth+Storage suite — Supabase; sub-ms shared KV — Redis.","categoryIds":["cat-vector-memory","cat-object-storage"],"depotPickProviderId":"turso","depotPickRationale":"pricePerf + dx for numerous small DBs. Distinct from serverless-db (Postgres) and agent-memory-kv (Redis).","runnersUpIds":["cloudflare-workers","neon","supabase-pgvector"],"weights":{"capabilityFit":0.25,"pricePerformance":0.18,"latencyReliability":0.15,"developerDx":0.15,"privacyPosture":0.1,"lockInRisk":0.07,"maturity":0.1},"methodologyNotes":"pricePerf + dx for numerous small DBs. Distinct from serverless-db (Postgres) and agent-memory-kv (Redis).","tags":["edge"],"depth":{"whenNotToUse":{"text":"Want shared serverless Postgres branching — Neon; Auth+Storage suite — Supabase; sub-ms shared KV — Redis.","source":"editorial `whenNotTopPick` (data/jtbds.json)"},"whenNotToUseReason":null,"runnerUp":{"providerId":"cloudflare-workers","name":"Cloudflare Workers","overallForJob":8.53,"pickOverallForJob":8.22,"beatsPickOn":["capabilityFit","pricePerformance","latencyReliability","maturity"],"source":"first resolvable entry of the job's editorially ranked `runnersUpIds`; scores are stored job-weighted scores"},"runnerUpReason":null,"lockIn":{"pickLockInRisk":3.6,"runnerUpLockInRisk":5.5,"scale":"0–10 stored curated estimate; higher = more lock-in (worse)","pickExitSignals":[],"runnerUpExitSignals":[],"pickNotes":[],"selfHostFallback":[{"id":"sqlite","name":"SQLite","license":"Public Domain","sourceUrl":"https://www.sqlite.org/copyright.html"},{"id":"sqlite-vec","name":"sqlite-vec","license":"MIT","sourceUrl":"https://raw.githubusercontent.com/asg017/sqlite-vec/main/LICENSE-MIT"}],"migration":"The pick has lower stored lock-in risk than runner-up Cloudflare Workers (3.6 vs 5.5). Self-host fallback listed for this job: SQLite, sqlite-vec.","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":"turso","slug":"turso","name":"Turso","tagline":"Depot pick for edge/per-tenant SQLite agent state. Serverless Postgres pick stays Neon; hot KV stays Redis…","overall":8.22},"runnersUp":[{"id":"cloudflare-workers","slug":"cloudflare-workers","name":"Cloudflare Workers","tagline":"Best edge runtime for lightweight agent gateways and tools. Heavy LLM loops still belong on Modal/Fly/GPU…","overall":8.53},{"id":"neon","slug":"neon","name":"Neon","tagline":"Excellent serverless Postgres for agent apps that want branching + pgvector without Supabase's full BaaS.","overall":8.59},{"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}]}