TBase
github.com
What it is
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.
Spec sheet
- Product
- TBase is an enterprise-level distributed HTAP database that provides distributed database and data warehouse services through one cluster.Read 3 Oct 2026 · github.com
- Deployment
- The maker's quick-start guide describes compiling from source and deploying the cluster across one or more hosts, including basic x86 servers.Read 3 Oct 2026 · github.com
- Maker
- The repository is published under Tencent; the opened official pages do not state TBase's headquarters or founding year.Read 3 Oct 2026 · github.com
- Cluster administration
- The pgxc_ctl tool helps configure and manage clusters.Read 3 Oct 2026 · github.com
- Cluster architecture
- A TBase cluster uses Coordinator Nodes, DataNodes and a Global Transaction Manager; coordinators plan queries and DataNodes store user data.Read 3 Oct 2026 · github.com
- Database capabilities
- TBase supports an extended subset of SQL, including transactions, foreign keys, user-defined types and functions.Read 3 Oct 2026 · github.com
- Distribution
- Tables can be distributed or replicated, and TBase sends queries to data nodes and collects the results.Read 3 Oct 2026 · github.com
- Language connectivity
- The repository says TBase has language interfaces similar to PostgreSQL.Read 3 Oct 2026 · github.com
- Query and memory monitoring
- The V2.2.0 notes describe viewing session memory, inspecting execution details for operators on DataNodes, and viewing cluster-wide active sessions from a coordinator.Read 3 Oct 2026 · github.com
- Replication-table limit
- Replication tables store a full copy on every DataNode; the guide says they are unsuitable for large tables and have low update performance.Read 3 Oct 2026 · github.com
- Security and auditing
- The repository describes security and audit as included functions and specifies the BSD 3-Clause License, with a listed third-party component exception.Read 3 Oct 2026 · github.com
- Shard-table limit
- For shard tables, the distribution-key field's value, length and type cannot be modified.Read 3 Oct 2026 · github.com
- Table types
- The usage guide covers shard tables, partitioned shard tables, hot and cold partitioned shard tables, and replication tables.Read 3 Oct 2026 · github.com
Plans and prices
Strong points and limits
Strong points
- Combines database and data warehouse services in one cluster
- Supports transactions and foreign keys
- Offers distributed and replicated table options
- Includes session and cluster-wide monitoring
Limits
- Shard-table distribution keys cannot be modified
- Replication tables are unsuitable for large tables
- Replication tables have low update performance
- Deployment requires compiling from source
Who it suits
TBase suits teams needing a self-hosted distributed database for transactional and analytical workloads. It is also relevant to administrators who can compile and manage a multi-node cluster.
Verdict
TBase offers a self-hosted distributed database with SQL capabilities and cluster monitoring. Its table design constraints are worth considering before choosing shard or replication tables.
Where Specifiction places it
- Distributed SQL Databases#14 of 257.6