DBMS > Amazon DocumentDB vs. PostgreSQL vs. TiDB
System Properties Comparison Amazon DocumentDB vs. PostgreSQL vs. TiDB
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Amazon DocumentDB Xexclude from comparison||PostgreSQL Xexclude from comparison||TiDB Xexclude from comparison|
|Description||Fast, scalable, highly available, and fully managed MongoDB-compatible database service||Widely used open source RDBMS Developed as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL||TiDB is an open source distributed Hybrid Transactional/Analytical Processing (HTAP) database that supports MySQL and Spark SQL syntaxes.|
|Primary database model||Document store||Relational DBMS with object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.||Relational DBMS|
|Secondary database models||Document store||Document store|
|Developer||PostgreSQL Global Development Group www.postgresql.org/developer||PingCAP, Inc.|
|Initial release||2019||1989 1989: Postgres, 1996: PostgreSQL||2016|
|Current release||12.2, February 2020||3.0.0, June 2019|
|License Commercial or Open Source||commercial||Open Source BSD||Open Source Apache 2.0|
|Cloud-based only Only available as a cloud service||yes||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Implementation language||C||Go, Rust|
|Server operating systems||hosted||FreeBSD|
|Typing predefined data types such as float or date||yes||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||yes specific XML-type available, but no XML query functionality.||no|
|SQL Support of SQL||no||yes standard with numerous extensions||yes|
|APIs and other access methods||proprietary protocol using JSON (MongoDB compatible)||ADO.NET|
native C library
streaming API for large objects
|Supported programming languages||Go|
|Server-side scripts Stored procedures||no||user defined functions realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.||no|
|Partitioning methods Methods for storing different data on different nodes||none||partitioning by range, list and (since PostgreSQL 11) by hash||horizontal partitioning (by key range)|
|Replication methods Methods for redundantly storing data on multiple nodes||Multi-availability zones for high availability, asynchronous replication for up to 15 read replicas||Master-slave replication other methods possible by using 3rd party extensions||Using Raft consensus algorithm to ensure data replication with strong consistency among multiple replicas.|
|MapReduce Offers an API for user-defined Map/Reduce methods||no may be implemented via Amazon Elastic MapReduce (Amazon EMR)||no||yes with TiSpark Connector|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||no typically not used, however similar functionality with DBRef possible||yes||no currently only supported in syntax|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||Atomic single-document operations||ACID||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes||yes|
|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||Access rights for users and roles||fine grained access rights according to SQL-standard||Users with fine-grained authorization concept. No user groups or roles.|
|More information provided by the system vendor|
|Specific characteristics||TiDB is an open source distributed scalable hybrid transactional and analytical processing...|
|Competitive advantages||In the current database landscape, infrastructure engineers often have to use one...|
|Typical application scenarios||TiDB is designed to support both OLTP and OLAP scenarios. You can use TiDB , the...|
|Key customers||Bank of Beijing (Banking) Mobike (Ridesharing) Toutiao (Media) Ele.me (Catering)...|
|Market metrics||InfoWorld’s 2018 Best of Open Source Software Award winners 15000+ stars on GitHub...|
|Licensing and pricing models||Open Source Apache 2.0 with either commercial licensing or fully-hosted DB-as-a-service...|
Early Impressions of Go from a Rust Programmer
Remote Work - Part 3
Remote Work - Part 2
Remote Work - Part 1
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||SQLPro for PostgreSQL: A simple but powerful PostgreSQL database client available on iPhone and iPad as well as macOS.|
Azure Database for PostgreSQL provides fully managed, enterprise-ready community PostgreSQL database as a service
Dremio is like magic for PostgreSQL accelerating your analytical queries up to 1,000x.
CYBERTEC: your professional partner for PostgreSQL services and Data Science based on PostgreSQL since 2000. With offices in Austria, Uruguay, Estonia and Switzerland, CYBERTEC operates worldwide!
General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
DBHawk: a web-based PostgreSQL/Greenplum database tool. Boost database development and BI productivity with an online Universal database tool.
pgDash: In-Depth PostgreSQL Monitoring.
Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
2ndQuadrant: PostgreSQL Solutions for the Enterprise.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|
PostgreSQL is the DBMS of the Year 2018
|Conferences and events|
PGCon 2020, PostgreSQL Conference for Users and Developers
|Recent citations in the news|
AWS: Your complete guide to Amazon Web Services & features
Amazon DocumentDB Speeds Up With Slow Queries Logging
AWS Announces Amazon DocumentDB (with MongoDB Compatibility)
OpsRamp Introduces AI-Driven Suggestions for Greater Transparency and Faster Incident Remediation
AWS DocumentDB and MongoDB Atlas: Friend or Foe?
provided by Google News
EnterpriseDB looks to grow market for PostgreSQL
Google lays out HarbourBridge to tempt PostgreSQL users onto Cloud Spanner • DEVCLASS
Crunchy PostgreSQL for Kubernetes 4.2 Receives Red Hat OpenShift Operator Certification
Database Management System (DBMS) Market Rising Demand 2019 | Microsoft, Software AG, IBM, Oracle, PostgreSQL, NCR
Database Management System (DBMS) Market Shaping from Growth to Value | Oracle, PostgreSQL, NCR
provided by Google News
True Influence Launches the True Influence Marketing Cloud Digital Marketing Platform
How TiDB combines OLTP and OLAP in a distributed database
TiDB developer PingCAP wants to expand in North America after raising $50M Series C
PingCAP offers titanium bullet to switch to its HTAP database
provided by Google News
Amazon DocumentDB Specialist SA
Solutions Architects - NoSQL and In-Memory Database
APPLICATIONS PROGR 5 (Release Engineer)
PostgreSQL Consultant - remote
Entry Level Data Scientist
MySQL DBA (US Hours) - remote
Head of People and Culture
Head of Resellers & Channels
Share this page