| Editorial information provided by DB-Engines | |||
|---|---|---|---|
| Name | MySQL X | Oracle X | PostgreSQL X |
| Description | Widely used open source RDBMS | Widely used RDBMS | Widely used open source RDBMS  |
| Primary database model | Relational DBMS |
Relational DBMS | Relational DBMS |
| Secondary database models | Document store Spatial DBMS | Document store Graph DBMS RDF store Spatial DBMS |
Document store Spatial DBMS |
DB-Engines Ranking  Trend Chart |
Score1238.22Rank#2 Overall#2 Relational DBMS | Score1269.26Rank#1 Overall#1 Relational DBMS | Score577.05Rank#4 Overall#4 Relational DBMS |
| Website | www.mysql.com | www.oracle.com/database | www.postgresql.org |
| Technical documentation | dev.mysql.com/doc | docs.oracle.com/en/database | www.postgresql.org/docs |
| Developer | Oracle |
Oracle | PostgreSQL Global Development Group |
| Initial release | 1995 | 1980 | 1989 |
| Current release | 8.0.26, July 2021 | 19c, February 2019 | 13.3, May 2021 |
| License |
Open Source |
commercial |
Open Source |
| Cloud-based only |
no | no | no |
| DBaaS offerings (sponsored links) |
ScaleGrid for MySQL: Fully managed MySQL hosting on AWS, Azure and DigitalOcean with high availability and SSH access on the #1 multi-cloud DBaaS. | ScaleGrid for PostgreSQL: Fully managed PostgreSQL hosting on AWS, Azure and DigitalOcean with high availability and SSH access on the #1 multi-cloud DBaaS. | |
| Implementation language | C and C++ | C and C++ | C |
| Server operating systems | FreeBSD Linux OS X Solaris Windows | AIX HP-UX Linux OS X Solaris Windows z/OS | FreeBSD HP-UX Linux NetBSD OpenBSD OS X Solaris Unix Windows |
| Data scheme | yes | yes |
yes |
| Typing |
yes | yes | yes |
| XML support |
yes | yes | yes |
| Secondary indexes | yes | yes | yes |
| SQL |
yes |
yes |
yes |
| APIs and other access methods | ADO.NET JDBC ODBC Proprietary native API | JDBC ODBC ODP.NET Oracle Call Interface (OCI) | ADO.NET JDBC native C library ODBC streaming API for large objects |
| Supported programming languages | Ada C C# C++ D Delphi Eiffel Erlang Haskell Java JavaScript (Node.js) Objective-C OCaml Perl PHP Python Ruby Scheme Tcl | C C# C++ Clojure Cobol Delphi Eiffel Erlang Fortran Groovy Haskell Java JavaScript Lisp Objective C OCaml Perl PHP Python R Ruby Scala Tcl Visual Basic | .Net C C++ Delphi Java JavaScript (Node.js) Perl PHP Python Tcl |
| Server-side scripts |
yes |
PL/SQL |
user defined functions |
| Triggers | yes | yes | yes |
| Partitioning methods |
horizontal partitioning, sharding with MySQL Cluster or MySQL Fabric | Sharding, horizontal partitioning | partitioning by range, list and (since PostgreSQL 11) by hash |
| Replication methods |
Multi-source replication Source-replica replication | Multi-source replication Source-replica replication | Source-replica replication |
| MapReduce |
no | no |
no |
| Consistency concepts |
Immediate Consistency | Immediate Consistency | Immediate Consistency |
| Foreign keys |
yes |
yes | yes |
| Transaction concepts |
ACID |
ACID |
ACID |
| Concurrency |
yes |
yes | yes |
| Durability |
yes | yes | yes |
| In-memory capabilities |
yes | yes |
no |
| User concepts |
Users with fine-grained authorization concept |
fine grained access rights according to SQL-standard | fine grained access rights according to SQL-standard |
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
