DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Alibaba Cloud ApsaraDB for PolarDB vs. MariaDB vs. MySQL vs. PostgreSQL vs. Riak TS

System Properties Comparison Alibaba Cloud ApsaraDB for PolarDB vs. MariaDB vs. MySQL vs. PostgreSQL vs. Riak TS

Editorial information provided by DB-Engines
NameAlibaba Cloud ApsaraDB for PolarDB  Xexclude from comparisonMariaDB  Xexclude from comparisonMySQL  Xexclude from comparisonPostgreSQL  Xexclude from comparisonRiak TS  Xexclude from comparison
DescriptionA cloud-native relational database compatible with MySQL, PostgreSQL, and Oracle. Designed for business critical applications.MySQL application compatible open source RDBMS, enhanced with high availability, security, interoperability and performance capabilities. MariaDB ColumnStore provides a column-oriented storage engine and MariaDB Xpand supports distributed SQL.Widely used open source RDBMSWidely used open source RDBMS infoDeveloped as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQLRiak TS is a distributed NoSQL database optimized for time series data and based on Riak KV
Primary database modelRelational DBMSRelational DBMSRelational DBMS infoKey/Value like access via memcached APIRelational DBMS infowith object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.Time Series DBMS
Secondary database modelsDocument store
Graph DBMS infowith OQGraph storage engine
Spatial DBMS
Document store
Spatial DBMS
Document store
Graph DBMS infowith Apache Age
Spatial DBMS
Vector DBMS infowith pgvector extension
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.52
Rank#257  Overall
#118  Relational DBMS
Score93.81
Rank#13  Overall
#9  Relational DBMS
Score1087.72
Rank#2  Overall
#2  Relational DBMS
Score645.05
Rank#4  Overall
#4  Relational DBMS
Score0.25
Rank#308  Overall
#26  Time Series DBMS
Websitewww.alibabacloud.com/­product/­polardbmariadb.com infoSite of MariaDB Corporation
mariadb.org infoSite of MariaDB Foundation
www.mysql.comwww.postgresql.org
Technical documentationwww.alibabacloud.com/­help/­en/­polardb/­product-overviewmariadb.com/­kb/­en/­librarydev.mysql.com/­docwww.postgresql.org/­docswww.tiot.jp/­riak-docs/­riak/­ts/­latest
DeveloperAlibabaMariaDB Corporation Ab (MariaDB Enterprise),
MariaDB Foundation (community MariaDB Server) infoThe lead developer Monty Widenius is the original author of MySQL
Oracle infosince 2010, originally MySQL AB, then SunPostgreSQL Global Development Group infowww.postgresql.org/­developerOpen Source, formerly Basho Technologies
Initial release2009 infoFork of MySQL, which was first released in 199519951989 info1989: Postgres, 1996: PostgreSQL2015
Current release11.3.2, February 20248.3.0, January 202416.2, February 20243.0.0, September 2022
License infoCommercial or Open SourcecommercialOpen Source infoGPL version 2, commercial enterprise subscription availableOpen Source infoGPL version 2. Commercial licenses with extended functionallity are availableOpen Source infoBSDOpen Source
Cloud-based only infoOnly available as a cloud serviceyesnononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Aiven for MySQL: Fully managed MySQL, deployable in the cloud of your choice, with seamless integrations and lightning-fast setup.Aiven for PostgreSQL: Fully managed PostgreSQL for developers with 70+ extensions and flexible orchestration tools.
Implementation languageC and C++C and C++CErlang
Server operating systemshostedFreeBSD
Linux
Solaris
Windows infoColumnStore storage engine not available on Windows
FreeBSD
Linux
OS X
Solaris
Windows
FreeBSD
HP-UX
Linux
NetBSD
OpenBSD
OS X
Solaris
Unix
Windows
Linux
OS X
Data schemeyesyes infoDynamic columns are supportedyesyesschema-free
Typing infopredefined data types such as float or dateyesyesyesyesno
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.yesyesyesyes infospecific XML-type available, but no XML query functionality.no
Secondary indexesyesyesyesyesrestricted
SQL infoSupport of SQLyesyes infowith proprietary extensionsyes infowith proprietary extensionsyes infostandard with numerous extensionsyes, limited
APIs and other access methodsJDBC
ODBC
ADO.NET
JDBC
ODBC
Proprietary native API
ADO.NET
JDBC
ODBC
Proprietary native API
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
HTTP API
Native Erlang Interface
Supported programming languagesJava
Python
Ada
C
C#
C++
D
Eiffel
Erlang
Go
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
.Net
C
C++
Delphi
Java infoJDBC
JavaScript (Node.js)
Perl
PHP
Python
Tcl
C infounofficial client library
C#
C++ infounofficial client library
Clojure infounofficial client library
Dart infounofficial client library
Erlang
Go infounofficial client library
Groovy infounofficial client library
Haskell infounofficial client library
Java
JavaScript infounofficial client library
Lisp infounofficial client library
Perl infounofficial client library
PHP
Python
Ruby
Scala infounofficial client library
Smalltalk infounofficial client library
Server-side scripts infoStored proceduresyesyes infoPL/SQL compatibility added with version 10.3yes infoproprietary syntaxuser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.Erlang
Triggersyesyesyesyesyes infopre-commit hooks and post-commit hooks
Partitioning methods infoMethods for storing different data on different nodesSharding infoImplicit feature of the cloud serviceseveral options for horizontal partitioning and Shardinghorizontal partitioning, sharding with MySQL Cluster or MySQL Fabricpartitioning by range, list and (since PostgreSQL 11) by hashSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoImplicit feature of the cloud serviceMulti-source replication
Source-replica replication
Multi-source replication
Source-replica replication
Source-replica replication infoother methods possible by using 3rd party extensionsselectable replication factor
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononoyes
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyEventual Consistency
Foreign keys infoReferential integrityyesyes infonot for MyISAM storage engineyes infonot for MyISAM storage engineyesno infolinks between datasets can be stored
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACID infonot for MyISAM storage engineACID infonot for MyISAM storage engineACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyes infotable locks or row locks depending on storage engineyesyes
Durability infoSupport for making data persistentyesyes infonot for in-memory storage engineyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes infowith MEMORY storage engineyesno
User concepts infoAccess controlfine grained access rights according to SQL-standardfine grained access rights according to SQL-standardUsers with fine-grained authorization concept infono user groups or rolesfine grained access rights according to SQL-standardno
More information provided by the system vendor
Alibaba Cloud ApsaraDB for PolarDBMariaDBMySQLPostgreSQLRiak TS
Specific characteristicsApsaraDB for PolarDB is a cloud-native relational database 100% compatible with MySQL...
» more
MariaDB is the most powerful open source relational database – modern SQL and JSON...
» more
Competitive advantagesWebinar: Top Scientists Live: Tech Secrets to Double 11's Success Revealed. White...
» more
MariaDB Servers have many features unavailable in other open source relational databases....
» more
Typical application scenariosCreating a Robust Cloud-Based Database for Fintech, E-Commerce and Gaming. Learn...
» more
Web, SaaS and Cloud operational applications that require high availability, scalability...
» more
Key customersDeutsche Bank, DBS Bank, Nasdaq, Red Hat, ServiceNow, Verizon and Walgreens Featured...
» more
Market metricsMariaDB is the default database in the LAMP stack supplied by Red Hat and SUSE Linux,...
» more
Licensing and pricing modelsSpecification and pricing. You can use either of the following billing methods to...
» more
MariaDB plc subscriptions cover our free, open source database, Community Server,...
» more

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 partiesNavicat for MariaDB provides a native environment for MariaDB database management and development.
» more
CData: Connect to Big Data & NoSQL through standard Drivers.
» more

Navicat Monitor is a safe, simple and agentless remote server monitoring tool for MySQL and many other database management systems.
» more

Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development.
» more

Aiven for MySQL: Fully managed MySQL, deployable in the cloud of your choice, with seamless integrations and lightning-fast setup.
» more
CYBERTEC is your professional partner in PostgreSQL topics for over 20 years. As our main aim is to be your single-source all-in-one IT service provider, we offer a wide range of products and services. Visit our website for more details.
» more

Aiven for PostgreSQL: Fully managed PostgreSQL for developers with 70+ extensions and flexible orchestration tools.
» more

Timescale: Calling all PostgreSQL users – the 2023 State of PostgreSQL survey is now open! Share your favorite extensions, preferred frameworks, community experiences, and more. Take the survey today!
» more

Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
» more

Redgate webinars: A series of key topics for new PostgreSQL users.
» more

pgDash: In-Depth PostgreSQL Monitoring.
» more

Fujitsu Enterprise Postgres: An Enterprise Grade PostgreSQL with the flexibility of a hybrid cloud solution combined with industry leading security, availability and performance.
» more

Navicat Monitor is a safe, simple and agentless remote server monitoring tool for PostgreSQL and many other database management systems.
» more

Instaclustr: Fully Hosted & Managed PostgreSQL
» more

SharePlex is the reliable and affordable data replication solution for PostgreSQL migrations, high availability and more.
» more

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

More resources
Alibaba Cloud ApsaraDB for PolarDBMariaDBMySQLPostgreSQLRiak TS
DB-Engines blog posts

MariaDB strengthens its position in the open source RDBMS market
5 April 2018, Matthias Gelbmann

PostgreSQL is the DBMS of the Year 2017
2 January 2018, Paul Andlinger, Matthias Gelbmann

Big gains for Relational Database Management Systems in DB-Engines Ranking
2 February 2016, Matthias Gelbmann

show all

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

MariaDB strengthens its position in the open source RDBMS market
5 April 2018, Matthias Gelbmann

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

show all

PostgreSQL is the DBMS of the Year 2023
2 January 2024, Matthias Gelbmann, Paul Andlinger

Snowflake is the DBMS of the Year 2022, defending the title from last year
3 January 2023, Matthias Gelbmann, Paul Andlinger

Snowflake is the DBMS of the Year 2021
3 January 2022, Paul Andlinger, Matthias Gelbmann

show all

Recent citations in the news

Top Data Backup Certifications in 2022
25 August 2022, Enterprise Storage Forum

provided by Google News

Progress Software (PRGS) says MariaDB acquisition makes sense
5 April 2024, StreetInsider.com

Struggling database company MariaDB could be taken private in $37M deal
19 February 2024, TechCrunch

MariaDB Receives Takeover Bid | DealFlow's SPAC News
29 March 2024, DealFlow's SPAC News

Progress Software Confirms Bid to Acquire MariaDB
26 March 2024, The Wall Street Journal

Why Is MariaDB (MRDB) Stock Up 82% Today?
27 March 2024, InvestorPlace

provided by Google News

PostgreSQL or MySQL: What Should I Choose for My Full-Stack Project?
10 April 2024, hackernoon.com

Amazon Aurora MySQL version 2 (with MySQL 5.7 compatibility) to version 3 (with MySQL 8.0 compatibility) upgrade ...
18 March 2024, AWS Blog

GitHub Upgrades its MySQL Infrastructure from v5.7 to 8.0
3 February 2024, InfoQ.com

General Availability: Azure MySQL Import feature for Azure Database for MySQL Single to Flexible Server migrations ...
17 January 2024, azure.microsoft.com

MySQL Shorts - Episode #57 is Released
12 March 2024, Oracle

provided by Google News

PostgreSQL or MySQL: What Should I Choose for My Full-Stack Project?
10 April 2024, hackernoon.com

Timescale Acquires PopSQL to Bring a Modern, Collaborative SQL GUI to PostgreSQL Developers
4 April 2024, PR Newswire

Introducing OCI Database with PostgreSQL: Completing Our Cloud Database Suite for Every Need
14 November 2023, Oracle

General availability: Microsoft Entra ID integration with Azure Cosmos DB for PostgreSQL | Azure updates
13 March 2024, azure.microsoft.com

Oracle Introduces PostgreSQL Running Native on OCI
17 December 2023, IDC

provided by Google News

NoSQL pioneer Basho stamps its mark on time stamp data with Riak TS
6 October 2015, The Register

What you missed in the Smart World: Amazon enters IoT space
12 October 2015, SiliconANGLE News

Best open source databases for IoT applications
26 May 2017, Open Source For You

provided by Google News



Share this page

Featured Products

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Ontotext logo

GraphDB allows you to link diverse data, index it for semantic search and enrich it via text analysis to build big knowledge graphs. Get it free.

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

SingleStore logo

Build AI apps with Vectors on SQL and JSON with milliseconds response times.
Try it today.

Present your product here