DB-EnginesInfluxDB download bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Snowflake vs. SwayDB vs. TiDB

System Properties Comparison Snowflake vs. SwayDB vs. TiDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameSnowflake  Xexclude from comparisonSwayDB  Xexclude from comparisonTiDB  Xexclude from comparison
DescriptionCloud-based data warehousing service for structured and semi-structured dataAn embeddable, non-blocking, type-safe key-value store for single or multiple disks and in-memory storageTiDB is an open source distributed Hybrid Transactional/Analytical Processing (HTAP) database that supports MySQL and Spark SQL syntaxes.
Primary database modelRelational DBMSKey-value storeRelational DBMS
Secondary database modelsDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score10.10
Rank#42  Overall
#26  Relational DBMS
Score0.10
Rank#306  Overall
#50  Key-value stores
Score2.34
Rank#117  Overall
#57  Relational DBMS
Websitewww.snowflake.comswaydb.iopingcap.com
Technical documentationdocs.snowflake.net/­manuals/­index.htmldocs.pingcap.com/­tidb/­stable
DeveloperSnowflake Computing Inc.Simer PlahaPingCAP, Inc.
Initial release201420182016
Current release4.0, July 2020
License infoCommercial or Open SourcecommercialOpen Source infoGNU Affero GPL V3.0Open Source infoApache 2.0
Cloud-based only infoOnly available as a cloud serviceyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageScalaGo, Rust
Server operating systemshostedLinux
Data schemeyes infosupport of semi-structured data formats (JSON, XML, Avro)schema-freeyes
Typing infopredefined data types such as float or dateyesnoyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.yesnono
Secondary indexesnoyes
SQL infoSupport of SQLyesnoyes
APIs and other access methodsCLI Client
JDBC
ODBC
JDBC
ODBC
Proprietary protocol
Supported programming languagesJavaScript (Node.js)
Python
Java
Kotlin
Scala
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
Server-side scripts infoStored proceduresuser defined functionsnono
Triggersno infosimilar concept for controling cloud resourcesnono
Partitioning methods infoMethods for storing different data on different nodesyesnonehorizontal partitioning (by key range)
Replication methods infoMethods for redundantly storing data on multiple nodesyesnoneUsing Raft consensus algorithm to ensure data replication with strong consistency among multiple replicas.
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyes infowith TiSpark Connector
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesnono infocurrently only supported in syntax
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDAtomic execution of operationsACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesno
User concepts infoAccess controlUsers with fine-grained authorization concept, user roles and pluggable authenticationnoUsers with fine-grained authorization concept. No user groups or roles.
More information provided by the system vendor
SnowflakeSwayDBTiDB
Specific characteristicsTiDB is an open-source NewSQL database built by PingCAP. TiDB supports Hybrid Transactional...
» more
Competitive advantagesIn the current database landscape, infrastructure engineers often have to use one...
» more
Typical application scenariosTiDB is designed to support both OLTP and OLAP scenarios. You can use TiDB , the...
» more
Key customersShopee (E-commerce) BookMyShow.com (E-commerce) Yiguo.com (E-commerce) JD Cloud &...
» more
Market metrics25K+ GitHub Stars for TiDB, and 8K+ GitHub Stars for TiKV 1.6K+ members in TiDB Community...
» more
Licensing and pricing modelsOpen Source Apache 2.0 with either commercial licensing or fully-hosted DB-as-a-service...
» more
News

How a Top Game Company Uses Chaos Engineering to Improve Testing
26 November 2020

Best Practices for TiDB on AWS Cloud
24 November 2020

PingCAP, the Company Behind TiDB, Raises $270 Million in Series D Funding
17 November 2020

TiDB on KubeSphere: Run a Cloud-Native Distributed Database on a Hybrid-Cloud Kubernetes Platform
16 November 2020

Flink + TiDB: A Scale-Out Real-Time Data Warehouse for Second-Level Analytics
11 November 2020

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services
3rd partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
SnowflakeSwayDBTiDB
Recent citations in the news

Database Platform as a Service Market is in huge demand | Snowflake Computing, Salesforce, Alibaba Cloud
27 November 2020, Murphy's Hockey Law

Snowflake embraces data programming (and Slootman writes another book)
27 November 2020, Blocks and Files

Database as a Service Market: 3 Bold Projections for 2020 | Microsoft, Google, Snowflake Computing
26 November 2020, The Market Feed

How Snowflake plans to change a flawed data warehouse model
14 November 2020, SiliconANGLE News

Snowflake Stock: 3 Key Risks
13 November 2020, Forbes

provided by Google News

PingCAP, the open-source developer behind TiDB, closes $270 million Series D
17 November 2020, TechCrunch

PingCAP raises $270M to develop core technologies and advance global expansion of its offerings
18 November 2020, Help Net Security

Cloud Native Computing Foundation Announces etcd Graduation | State
24 November 2020, thepress.net

Space Tech startup joins the unicorn club & a report on the trillion-dollar fresh food industry | China's Venture Roundup Volume 11
27 November 2020, KrASIA

PingCAP Announces TiDB Cloud, Bringing Fully-Managed TiDB Service to AWS and GCP
23 June 2020, PRNewswire

provided by Google News

Job opportunities

SQL Developer
Piper Companies, Norristown, PA

Database Engineer/DBA
Piper Companies, Philadelphia, PA

Business Intelligence Developer
Enertia Software, Midland, TX

Developer, Database
T-Mobile, Overland Park, KS

Database Developer
Pet Supermarket, Ontario, CA

Database Administrator
Backblaze, San Mateo, CA

Senior Software Engineer (Storage), Cash App
Cash App, New York, NY

Senior Software Engineer (Storage), Cash App
Cash App, San Francisco, CA

jobs by Indeed




Share this page

Featured Products

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

Datastax Astra logo

Cassandra made easy in the cloud. Build cloud-native applications faster with CQL, REST and GraphQL APIs.
Try for Free.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Vertica logo

The fastest unified analytical warehouse at extreme scale with in-database Machine Learning. Try Vertica for free with no time limit.

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

Present your product here