Convex vs PlanetScale

Convex

PlanetScale

Convex · 18 features

• Actions — Non-deterministic functions for external I/O (fetch, AI APIs, email). Cannot rea…
• Authentication — Convex Auth (built-in) or BYO provider (Clerk, Auth0, Kinde, WorkOS). ID tokens …
• Convex Agents — AI agent framework with durable memory, threads, tool use. Works with OpenAI / A…
• Convex Auth — First-party auth library: passwords, magic links, OAuth, phone — stored in your …
• Convex Components — Reusable backend modules (rate limiter, workflow, aggregate, action-retrier, etc…
• Cron Jobs — Recurring schedules defined in convex/crons.ts. UTC, cron-style patterns.
• Durable Workflows — Long-running multi-step workflows with retries and at-least-once guarantees.
• Exception Reporting — Auto-capture errors to Sentry, Axiom, Datadog.
• File Storage — Upload/download via storage API. Returns storage IDs referenced in documents.
• Full-Text Search — BM25 search index on table fields. withSearchIndex query helper.
• HTTP Actions — Expose public HTTP endpoints for webhooks, OAuth callbacks, third-party integrat…
• Log Streams — Stream function logs to Axiom, Datadog, Sentry. Pro+.
• Mutations — Transactional write functions. All reads + writes in one mutation are ACID; conf…
• Preview Deployments — Every Git branch gets its own isolated deployment. Integrates with Vercel/Netlif…
• Queries — Deterministic read-only TS functions. Automatically cached and re-run when under…
• Real-Time Subscriptions — useQuery auto-subscribes; server invalidates when data a query read changes. No …
• Scheduler — schedule.after / schedule.at — enqueue functions to run later. Durable, survives…
• Vector Search — Native vector index on tables. withIndex + filter fields. Up to 4096 dims.

PlanetScale · 12 features

• Backups — Automated daily backups with retention.
• Database Branching — Git-like branches of your DB schema (not data). Create, diff, merge via deploy r…
• Deploy Requests — Schema changes in a feature branch get reviewed + auto-applied to main with zero…
• HIPAA — HIPAA-compliant deployments (Enterprise).
• Metal (NVMe) — Dedicated NVMe local storage. 10x IOPS vs EBS, latency-critical workloads.
• PgBouncer Pooler — Managed PgBouncer for Postgres clusters. Optional dedicated pooler.
• PlanetScale Boost — Query result cache with sub-ms reads.
• Point-in-Time Recovery — Restore cluster to any point within retention window.
• Postgres on PlanetScale — PostgreSQL 15+ with the same branching + deploy-request flow. Launched 2024.
• Query Insights — Per-query performance analytics, slow query tracking, explain plans.
• Read-only Regions — Route reads to the nearest region for lower latency.
• Vitess (MySQL at scale) — Horizontally-sharded MySQL (YouTube-scale) — original PlanetScale offering.