Google Cloud Spanner vs TBase

Google Cloud Spanner is a paid database service combining relational, graph, key-value, and search capabilities. It provides Strong-ACID transactions ordered with TrueTime, horizontal read and write scaling, automatic sharding, and geo-partitioning. Configurations include single-region, dual-region, and multi-region deployments, with Google describing availability up to 99.999%. Spanner Graph, vector search, and built-in full-text search are included. A columnar engine supports ad hoc analytics on live data, and BigQuery integration enables federated queries. Spanner Omni is downloadable for on-premises, cross-cloud, or laptop deployment. Client libraries cover C++, C#, Go, Java, Node.js, PHP, Python, and Ruby. Integrations include Cloud Run, Dataflow, Cloud Storage, Compute Engine, GKE, Gemini Enterprise Agent Platform, and Looker. Security includes encryption in transit and identity and access controls. PostgreSQL compatibility, horizontal scaling, multi-region deployment, geo-partitioning, and HTAP workloads are listed.

TBase is Tencent-published, open-source database software for distributed hybrid transactional and analytical processing. It provides database and data warehouse services through one cluster and supports an extended subset of SQL, including transactions, foreign keys, user-defined types, and functions. A cluster uses Coordinator Nodes to plan queries, DataNodes to store user data, and a Global Transaction Manager. Tables can be distributed or replicated, with queries sent to DataNodes and results gathered. Deployment is self-hosted; setup guidance describes compiling from source and deploying across one or more hosts, including basic x86 servers. Administrators can use pgxc_ctl to configure and manage clusters. Table options include shard, partitioned shard, hot-and-cold partitioned shard, and replication tables. Shard-table distribution-key values, lengths, and types cannot be modified. Replication tables keep a full copy on every DataNode, and the guide cautions against using them for large tables. Monitoring includes session memory, DataNode operator details, and cluster-wide active sessions. TBase is listed as free under the BSD 3-Clause License.