Convex vs Supabase

Convex

Supabase

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.

Supabase · 24 features

• Authentication — Complete JWT-based auth: passwords, magic links, OTP, OAuth, SSO, phone, MFA.
• Backups & PITR — Automatic daily backups + Point-in-Time Recovery (WAL-G). 14-day default PITR wi…
• Compute Instances — Upgradeable DB compute: Micro, Small, Medium, Large. Affects CPU, RAM, and conne…
• Connection Pooling — Supavisor pooler: Session mode (persistent) and Transaction mode (serverless). D…
• Cron Jobs — Scheduled recurring jobs via pg_cron. Trigger DB functions, edge functions, or H…
• Custom Domains — Configure custom hostname for API endpoints with SSL certificate management.
• Database Webhooks — Async HTTP callbacks on INSERT/UPDATE/DELETE via pg_net extension.
• Edge Functions — TypeScript (Deno runtime) functions deployed globally at the edge. Supports secr…
• Full-Text Search — PostgreSQL native FTS: to_tsvector, to_tsquery, GIN indexes, fuzzy matching, wei…
• Image Transformations — On-the-fly resize, crop, quality (20-100), WebP auto-format. Smart CDN caching. …
• Log Drains — Route all stack logs to HTTP, Datadog, Loki, Sentry, S3, OTLP, or Axiom. Up to 2…
• Metrics API — ~200 Prometheus-compatible Postgres metrics. OpenTelemetry export to Datadog, Gr…
• Network Restrictions — CIDR allowlist for database access. Multiple IP ranges supported. Pro+ plan.
• OAuth 2.1 Server — Use Supabase Auth as OAuth provider. Custom Access Token Hooks for claim injecti…
• pgvector — Store and search vector embeddings in Postgres. Supports HNSW/Flat indexes, cosi…
• PostgreSQL Database — Full PostgreSQL per project: SQL editor, table editor, CSV import, 50+ extension…
• PostgreSQL Extensions — 50+ pre-installed extensions: uuid-ossp, pgvector, pg_cron, plv8, pgtap, pg_net,…
• Preview Branches — Ephemeral or persistent DB branches for isolated testing. Git integration, auto-…
• Queues — Exactly-once message queues built on pgmq. Stored in Postgres with configurable …
• Read Replicas — Async read-only replicas in multiple regions. Geo-routing, replication lag monit…
• Realtime — WebSocket subscriptions for DB changes (INSERT/UPDATE/DELETE), broadcast, and pr…
• Row Level Security — SQL-native access control; policies auto-filter rows based on auth.uid() / auth.…
• SSL Enforcement — Require TLS for all DB connections. Configurable: required, preferred, disabled.
• Storage — Files, Analytics (Iceberg), and Vector buckets with global CDN (285+ cities) and…