DBMS > TiDB vs. YugabyteDB
System Properties Comparison TiDB vs. YugabyteDB
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||TiDB Xexclude from comparison||YugabyteDB Xexclude from comparison|
|Description||TiDB is an open source distributed SQL database that supports Hybrid Transactional/Analytical Processing (HTAP) workloads. It is MySQL compatible and features horizontal scalability, strong consistency, and high availability.||High-performance distributed SQL database for global, internet-scale applications. Wire and feature compatible with PostgreSQL.|
|Primary database model||Relational DBMS||Relational DBMS|
|Secondary database models||Document store||Document store|
Wide column store
|Developer||PingCAP, Inc.||Yugabyte Inc.|
|Current release||7.2.0, June 2023||2.18, May 2023|
|License Commercial or Open Source||Open Source Apache 2.0||Open Source Apache 2.0|
|Cloud-based only Only available as a cloud service||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|TiDB Cloud: Fully-managed TiDB Service. Bring everything great about TiDB to the cloud.||YugabyteDB Managed is the fully managed database-as-a-service offering of YugabyteDB. Get started quickly, and effortlessly ensure continuous availability and limitless scale of your cloud native applications.|
|Implementation language||Go, Rust||C and C++|
|Server operating systems||Linux||Linux|
|Data scheme||yes||depending on used data model|
|Typing predefined data types such as float or date||yes||yes|
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.||no||no|
|SQL Support of SQL||yes||yes, PostgreSQL compatible|
|APIs and other access methods||GORM|
YCQL, an SQL-based flexible-schema API with its roots in Cassandra Query Language
YSQL - a fully relational SQL API that is wire compatible with the SQL language in PostgreSQL
|Supported programming languages||Ada|
|Server-side scripts Stored procedures||no||yes sql, plpgsql, C|
|Partitioning methods Methods for storing different data on different nodes||horizontal partitioning (by key range)||Hash and Range Sharding, row-level geo-partitioning|
|Replication methods Methods for redundantly storing data on multiple nodes||Using Raft consensus algorithm to ensure data replication with strong consistency among multiple replicas.||Based on Raft distributed consensus protocol, minimum 3 replicas for continuous availability|
|MapReduce Offers an API for user-defined Map/Reduce methods||yes with TiSpark Connector||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Strong consistency on writes and tunable consistency on reads|
|Foreign keys Referential integrity||yes full support since version 6.6||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||Distributed ACID with Serializable & Snapshot Isolation. Inspired by Google Spanner architecture.|
|Concurrency Support for concurrent manipulation of data||yes||yes|
|Durability Support for making data persistent||yes||yes based on RocksDB|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no||no|
|User concepts Access control||Fine grained access rights according to SQL-standard||yes|
|More information provided by the system vendor|
|Specific characteristics||TiDB is an advanced open-source, distributed SQL database for modern application...|
|YugabyteDB is an open source distributed SQL database for cloud native transactional...|
|Competitive advantages||- HORIZONTAL SCALING : TiDB grants total transparency into your data workloads without...|
|PostgreSQL compatible: Get instantly productive with a PostgreSQL compatible RDBMS....|
|Typical application scenarios||TiDB is ideal for transactional applications that require extreme scalability and...|
|Systems of record and engagement for cloud native applications that require resilience,...|
|Key customers||Block, Pinterest, Catalyst, Bolt, Capcom, Shopee (E-commerce), JD Cloud & AI (Cloud...|
|Market metrics||34K+ GitHub stars 5K+ members in TiDB Community Slack 1K+ community contributors...|
|2 Million+ lifetime clusters deployed, 6.5K+ GitHub stars, 7K YugabyteDB Community...|
|Licensing and pricing models||TiDB Community : Free open source software (Apache 2.0) TiDB Self-Hosted : Enterprise...|
|Apache 2.0 license for the database|
Related products and services
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|Recent citations in the news|
PingCAP Achieves AWS Data and Analytics Competency Status ...
PingCAP Unveils TiDB 7.1, the Latest Advancement In Open Source ...
PingCAP Launches TiDB Serverless, a Cutting-Edge Solution to ...
PingCAP APAC launches TiDB Serverless, a fully-managed ...
PingCAP’s Innovative TiDB Database – Techstrong.TV
provided by Google News
vitagroup Selects Yugabyte to Underpin Patient Health Care ...
Yugabyte Announces Keynote and Expert Speakers for the Fifth ...
YugabyteDB 2.19: Bridging an Application's Journey from Lift-and ...
Yugabyte adds multiregion Kubernetes support to YugabyteDB 2.18
There are lots of ways to put a database in the cloud – here's what to consider
provided by Google News
Software Engineer Graduate (Database Team) - 2024 Start (BS/MS)
Senior Database Engineer
Principal Software Engineer I - PaaS_IaaS PostgreSQL (REMOTE)
Senior Demand Generation Marketing Manager
Sales Development Representative
Principal Financial Analyst
Senior Product Manager, Core Database
Java Lead Developer
Account Executive, Central
Share this page