Database caching and optimization that reduces infrastructure costs 30-70%

Convex
Reactive backend combining a document database, TypeScript server functions and live queries, source-available under the Functional Source Licence.
As of 13 November 2026, Convex is free to use. Convex replaces the database, the API layer and the subscription plumbing with TypeScript functions whose results update automatically when the underlying data changes. Softwr lists it under Databases.
Overview
What Convex does
Convex is a backend platform rather than a database on its own. It provides a document store, server-side functions written in TypeScript that run inside the platform, scheduled jobs and workflows, file storage, text and vector search, and a reactive query layer. Queries are deterministic functions over the database; Convex records what each one read and re-runs it for subscribed clients when any of that data changes, so a React or mobile client receives updated results without polling or manually invalidating a cache. Mutations are transactions, so a function either commits entirely or not at all. The backend source is published under FSL-1.1-Apache-2.0, the Functional Source Licence, which permits self-hosting and internal use, forbids competing use, and converts each release to Apache 2.0 two years after it was made available. The thing that distinguishes it is that reactivity is a property of the database, not a library on top of one. Building the same behaviour on Postgres means change data capture, a subscription server, cache invalidation logic and a plan for what happens when the two drift; Convex makes that the default path and the correctness of it the vendor's problem. The commercial consequence is that this is not a component you can swap later. Your data access, your authorisation checks, your transaction boundaries and your client subscription model are all written against Convex's function API, so the application is coupled to the platform at a much deeper level than a connection string. The buyers are product teams building collaborative or live-updating applications, and increasingly teams building agent backends, who would otherwise spend months on infrastructure that is not their product. The trade-off is the transaction envelope. A query or mutation gets one second of user code, may read and write at most 16 MiB, may scan 32,000 documents and write 16,000, and each document is capped at 1 MiB, so any bulk operation must be chunked and scheduled rather than run as a single transaction. There is no SQL and no query planner; you declare indexes, up to 32 per table, and traverse them, which means an access pattern you did not anticipate is a schema change rather than a new query. That is a reasonable trade for a young product moving fast and a poor one for a system whose query patterns are unknown.
What people use it for
- Collaborative applications where several users see the same data and every client must reflect a change immediately
- Agent backends that need durable state, scheduled work and transactional writes without assembling a queue, a database and a cache
- Small product teams who need a complete backend, including auth integration, file storage and subscriptions, without hiring infrastructure engineers
- Prototypes that must become production without a rewrite of the data layer, where end-to-end TypeScript types remove a class of integration bugs
The honest half
Where it falls short
Concrete and checkable, so you can decide whether any of them matter to you. This is the half of a review a vendor will not write about Convex.
- The Functional Source Licence is not an OSI open source licence: competing use is prohibited until each release reaches its second anniversary and converts to Apache 2.0, so you may self-host but you may not build a service on it.
- Transactions are bounded at one second of user code, 16 MiB read and written, 32,000 documents scanned and 16,000 written, so every backfill, migration or bulk import has to be chunked into scheduled batches rather than written as a single operation.
- There is no SQL and no query planner; you declare up to 32 indexes per table and traverse them, and joins are loops in TypeScript, so an unanticipated access pattern requires a schema and index change rather than a new query.
- It is not an analytical database, so reporting means streaming data out to a warehouse and BI tools cannot be pointed at Convex directly, which adds a pipeline the architecture diagram did not originally include.
- The application is written against Convex's function and client APIs rather than a standard protocol, so leaving means rewriting the data access layer and replacing the reactivity model, not repointing a connection string.
Pricing
What Convex costs
Taken from the vendor's own pricing page. Prices move, so check before you buy.
Free & Starter
Free
- Supports 1-6 developers
- Reactive database
- File storage
- Text and vector search
- Crons
- Authentication
Professional
$25 /month per developer
- Supports up to 20 developers
- All Starter features
- Log streaming
- Exception reporting
- Daily backups
- Custom domains
Business & Enterprise
$2,500 /month minimum
- Supports 50+ developers
- SAML/SSO
- Service SLAs
- Dedicated deployments
- Custom agreements
Capabilities
Features
Reactive queries
Subscribed clients receive updated results automatically when any data a query read changes
TypeScript server functions
Queries, mutations and actions written in TypeScript and executed inside the platform
ACID transactions
Mutations commit atomically, with reads and writes isolated within a single function call
Document database
Schema-optional documents with optional validators, and declared indexes for query paths
Scheduling and workflows
Functions scheduled for later execution and long-running workflows with durable state
File storage
Blob storage integrated with the same authorisation model as the database
Text and vector search
Search indexes over documents so retrieval does not require a separate service
End-to-end types
Types flow from the schema through server functions to the client without a generation step
Self-hosting
The backend, dashboard and CLI can be run on your own infrastructure under the FSL licence
Streaming export
Change streams out to a warehouse or ETL tool for analytics that Convex itself does not serve
Answered, with sources
Questions people ask
Each answer names the page it came from, so you can check it rather than take our word for it.
Is Convex open source?
It is source-available under FSL-1.1-Apache-2.0. You may read, modify and self-host it, but competing use is prohibited until each release converts to Apache 2.0 on its second anniversary.
Can I self-host it?
Yes. The backend, dashboard and CLI can run on your own infrastructure, with most of the features of the cloud product. Self-hosted instances include a telemetry beacon that can be disabled.
Does it support SQL?
No. Data is accessed through a TypeScript query builder over declared indexes. Relationships are traversed in code, which is explicit and type-safe but means no ad hoc querying.
What happens if a mutation exceeds the limits?
It fails rather than running longer, so bulk work must be split into batches and scheduled. The limits are per transaction: one second of user code, 16 MiB read and written, 32,000 documents scanned and 16,000 written.
How does reactivity actually work?
Queries are deterministic functions and Convex records the data each one read. When a mutation changes that data, affected queries are re-run and subscribed clients receive the new result, so cache invalidation is handled by the platform.
Keep looking
Where to go from Convex
- Convex alternativesEvery product people weigh against it
- Convex pricingPlans, floors and what the tiers exclude
- Convex badgesWhich rules it meets, and the figure behind each
- All Databases softwareThe full category
- Best Databases softwareThe shortlist, and how it was cut
Best Databases software for
Compare Convex with
- Readyset
- DynamoDB
- FaunaDB
- LanceDB
- Xata
- Materialize
- BigQuery
- dbt
- OpenSearch
- TiDB
- Tinybird
- Canary Labs
- Aiven
- CosmosDB
- DataStax
- EMQX
- Firebase Realtime Database
- Firestore
Other Databases software
- Free plan10 researched notes
AWS-only managed key-value and document database with fixed per-partition throughput limits and no ad hoc queries.
Free, then $0.625/million writes10 researched notesDocument-relational database whose hosted service closed in 2025 and whose core is now unmaintained Apache 2.0 code.
Free plan12 researched notesEmbedded retrieval library over the Apache 2.0 Lance columnar format, with proprietary Cloud and Enterprise tiers for serving at scale.
Pricing on request10 researched notesApache 2.0 platform for running many Postgres instances on Kubernetes, with copy-on-write branching and scale-to-zero.
Free plan12 researched notesLive context layer for AI agents using real-time SQL transformations
Free, then $1.5/compute-credit10 researched notesGoogle Cloud's serverless analytical warehouse, billed either by bytes scanned per query or by reserved compute slots.
Free plan13 researched notesSQL transformation framework enabling analytics engineers to version, test and deploy models
Free plan8 researched notesOpen-source search and analytics suite forked from Elasticsearch
Open source9 researched notesApache 2.0 distributed SQL database with MySQL wire compatibility and a separate columnar replica for analytical queries.
Free plan12 researched notesManaged ClickHouse with a workflow that turns SQL queries into hosted HTTP APIs
Free, then $25/mo12 researched notesIndustrial process historian with published per-tag pricing and no client licence fees
From $3,000/yr12 researched notesErlang MQTT broker for large IoT fleets, relicensed to BSL with production free use limited to one node
Free, then $234/mo12 researched notesStore and sync data in real-time across all clients
Free plan8 researched notes
Softwr does not host reviews and shows no star rating for Convex, because a rating we did not collect is not ours to publish. What is here is the pricing and platform detail from the vendor’s own pages, limitations we could state concretely, and alternatives a reviewer confirmed people weigh against it. Tell us if any of it is wrong.
More on Convex
Convex alternatives
What people switch to, and what they give up
Convex pricing
Every tier, and where the cost actually lands
Compare Convex
Put it head to head with anything we hold
Convex badge
Its rating, and an embed for your own site
Best Databases software alternatives
Industrial process historian with published per-tag pricing and no client licence fees
Per tag band per yearNetApp-owned managed service for Cassandra, Kafka, OpenSearch, PostgreSQL and Cadence with a bring-your-own-cloud model
quoteErlang MQTT broker for large IoT fleets, relicensed to BSL with production free use limited to one node
Per month by connection and session volumeAttribute-based access control and masking applied inside Snowflake, Databricks and BigQuery
quoteMPP analytical database with a MySQL wire protocol and sub-second aggregation on wide tables
Open source, no licence feeStreaming database that maintains incremental materialised views in SQL instead of Flink jobs
Per RisingWave Unit hourCentralised data access governance from the creators of Apache Ranger, now rebranding as Trust3 AI
quoteThe Meta-lineage distributed SQL query engine, distinct from the Trino fork
Open source, no licence fee























