vs

Appwrite vs Convex

Appwrite: Open-source backend platform with databases, auth, storage, functions and realtime, self-hosted or cloud. Convex: Reactive TypeScript backend with a transactional document database, server functions and live queries.

key differences

  • Appwrite is primarily a relational database; Convex is document.
  • Licensing: Appwrite is open source (permissive) (BSD 3-Clause License); Convex is source-available (FSL-1.1-Apache-2.0 (backend); Apache-2.0 client).
  • Horizontal scaling is manual in Appwrite and none in Convex.
  • Transactions: Appwrite offers limited ACID; Convex offers full.
  • Only Appwrite has triggers, role-based access.
  • Only Convex has transactions, change data capture, stored procedures.
  • Convex has a serverless option; Appwrite does not.

choose appwrite for

  • +Self-hosted backend for mobile and web apps
  • +Firebase replacement with data sovereignty requirements
  • +Internal tools needing auth, storage and functions quickly

best at · OLTP, Content, Vector search

choose convex for

  • +Realtime collaborative SaaS apps
  • +AI chat and agent apps with vector search
  • +Startups replacing a hand-built API plus cache
  • +Apps scaffolded by AI coding tools

best at · OLTP, Vector search, RAG

overview
Primary model
Relational
Document
Also supports
Document, Vector
Vector, Search Engine
Type
Backend platform
Backend platform
Status
Active
Active
Developer
Appwrite
Convex, Inc.
First release
2019
2022
Latest version
2.6.2 (Oct 24, 2026)
1.48.0 (npm client) (Oct 22, 2026)
License
Open source (permissive)BSD 3-Clause License
Source-availableFSL-1.1-Apache-2.0 (backend); Apache-2.0 client
Free tier
✓
✓
popularity
WhichDB Score
27.2
26.0
Rank
#106
#114
GitHub stars
57.8K
12.8K
Stack Overflow questions
216
–
scale & guarantees
Comfortable data size
Medium (≤ 10 TB)
Medium (≤ 10 TB)
Horizontal scaling
Manual
None
Multi-region
None
None
ACID
Limited
Full
Consistency
Strong
Strong
Schema
Flexible
Flexible
Architecture
Client server
Serverless, Client server
deployment
Self-hosted
✓
✓
Vendor-managed cloud
✓
✓
Serverless
—
✓
Embedded
—
—
Edge
—
—
Clouds
–
–
capabilities
Transactions
—
✓
Joins
—
—
Secondary indexes
✓
✓
Full-text search
✓
✓
Vector search
✓
✓
Geospatial
—
—
JSON
✓
✓
Change data capture
—
✓
Triggers
✓
—
Stored procedures
—
✓
Materialized views
—
—
TTL / expiry
—
—
Pub/Sub
✓
✓
Columnar storage
—
—
In-memory
—
—
Durable persistence
✓
✓
Compression
—
—
Encryption at rest
—
—
Role-based access
✓
—
Time travel
—
—
Branching
—
—
Online schema changes
—
—
Streaming ingest
—
—
Offline sync
—
—
Runs in WebAssembly
—
—
interfaces
Query languages
Appwrite Query API, GraphQL
TypeScript query functions
Client languages
JavaScript, Dart, Swift, Kotlin, Python, PHP, Ruby, Go
TypeScript, Python, Rust, Swift, Kotlin
Best for
OLTP, Content, Vector search
OLTP, Vector search, RAG, Search

Appwrite vs Convex: FAQ

What is the difference between Appwrite and Convex?

Appwrite: Open-source backend platform with databases, auth, storage, functions and realtime, self-hosted or cloud. Convex: Reactive TypeScript backend with a transactional document database, server functions and live queries. Appwrite is primarily a relational database; Convex is document. Licensing: Appwrite is open source (permissive) (BSD 3-Clause License); Convex is source-available (FSL-1.1-Apache-2.0 (backend); Apache-2.0 client). Horizontal scaling is manual in Appwrite and none in Convex.

When should I choose Appwrite over Convex?

Choose Appwrite for self-hosted backend for mobile and web apps; firebase replacement with data sovereignty requirements; and internal tools needing auth, storage and functions quickly. Choose Convex for realtime collaborative SaaS apps; AI chat and agent apps with vector search; and startups replacing a hand-built API plus cache.

Is Appwrite or Convex more popular?

Appwrite ranks #106 on the WhichDB Score (27.2/100) and Convex ranks #114 (26.0/100). Popularity is not fit: check the requirements that matter for your project.

Are Appwrite and Convex open source?

Yes. Appwrite is open source. License: BSD 3-Clause License. Not in the OSI sense. Convex is source-available: you can read the code, but the license restricts some uses, typically offering it as a competing managed service. License: FSL-1.1-Apache-2.0 (backend); Apache-2.0 client.