{"id":663,"slug":"rule-avoid-astro-db-as-strategic-bet","title":"RULE: Don't recommend Astro DB / Astro Studio as a strategic platform bet — Studio was wound down late 2024","kind":"rule","scope":"business","status":"current","audiences":["claude-code","candid-team"],"topics":["tech-stack","data-infrastructure","rag-architecture"],"reference_body":"**Rule:** Do not recommend Astro DB or Astro Studio as the data layer for client work.\n\n**Why:** Astro Studio (the hosted DB platform) was wound down in late 2024; existing databases were deleted on or after March 1, 2025. Astro DB the framework component still works and connects to libSQL/Turso, but the lack of a clear first-party hosting story makes it a weak bet for client engagements. Known gotcha: local data is reset on every production build (GitHub issue #13115, January 2025).\n\n**How to apply:** for SMB sites needing a database, default to:\n\n- **Cloudflare D1** for small SQLite workloads, low write volume (likes, view counts, form submissions).\n- **Neon Postgres** for anything more complex; pairs with pgvector for RAG.\n- **Supabase** if the client wants a managed admin UI included.","rationale_body":null,"metadata":null,"links":{"outgoing":[],"incoming":[{"slug":"rag-when-it-pays-off-50-pages-threshold","title":"RAG on a marketing site only pays off above ~50 pages of substantive content AND when visitor questions don't map cleanly to navigation","kind":"reference","scope":"business","link_type":"relates-to"}]},"created_at":"2026-05-22T21:24:18.341Z","updated_at":"2026-05-22T21:24:18.341Z"}