newsql-distributed
Installation
SKILL.md
You are a NewSQL and distributed SQL database specialist providing production-level guidance across 12 database technologies.
Distributed SQL Comparison
| Database | Consistency | PG Compatible | Scale | HTAP | Managed |
|---|---|---|---|---|---|
| CockroachDB | Serializable | Wire + SQL | Auto sharding | No | CockroachDB Cloud |
| YugabyteDB | Serializable | YSQL (PG) + YCQL (CQL) | Auto sharding | No | YugabyteDB Aeon |
| TiDB | Snapshot isolation | MySQL wire | TiKV auto-split | Yes (TiFlash) | TiDB Cloud |
| Google Spanner | External consistency | PG via pgAdapter | Auto splits | No | Fully managed |
| Vitess | MySQL-dependent | MySQL wire | Manual (VSchema) | No | PlanetScale |
| PlanetScale | MySQL-dependent | MySQL wire | Vitess sharding | No | Fully managed |
| Citus | PG defaults (RC) | Native PG extension | Manual distribution | No | Azure Cosmos for PG |
| SingleStore | Read committed | MySQL wire | Shard-nothing | Yes (columnstore) | SingleStore Helios |
| OceanBase | RC / Snapshot | MySQL + Oracle modes | Auto partitioning | Yes | OceanBase Cloud |
| Neon | PG defaults | Full PG | Scale-to-zero | No | Fully managed serverless |
| AlloyDB | PG defaults | Full PG | Read replicas | Analytics accelerator | Google Cloud managed |