When Should You NOT Use SpacetimeDB

SpacetimeDB has limitations that make it unsuitable for certain use cases. It only partially supports the PostgreSQL wire protocol and lacks features like interactive transactions and full ORDER BY support in subscriptions, making it a poor fit for existing systems relying on full Postgres compatibility. Additionally, SpacetimeDB stores data on a single machine, unlike CockroachDB which distributes data across a cluster. This makes SpacetimeDB a poor choice for large-scale analytics (OLAP) workloads involving petabytes of data or high-parallelism, low-contention write patterns across many nodes.