Comparison MySQL vs. PostgreSQL vs. SQLite

System Properties Comparison MySQL vs. PostgreSQL vs. SQLite

Please select  another system  to include it in the comparison.

Name MySQL    X PostgreSQL    X SQLite    X
Description Widely used open source  RDBMS Based on the object relational DBMS Postgres Widely used in-process  RDBMS
DB-Engines Ranking  
Trend Chart
Rank 2
Score 1290.21
Rank 4
Score 235.06
Rank 8
Score 92.98
Website www.mysql.com www.postgresql.org sqlite.org
Technical documentation dev.mysql.com/ ­doc www.postgresql.org/ ­docs/ ­manuals sqlite.org/ ­docs.html
Developer Oracle   PostgreSQL Global Development Group   Dwayne Richard Hipp
Initial release 1995 1989   2000
License Open Source   Open Source   Public Domain
Implementation language C and C++ C C
Server operating systems FreeBSD
Linux
OS X
Solaris
Windows
HP-UX
Linux
OS X
Solaris
Unix
Windows
server-less
Database model Relational DBMS   Relational DBMS   Relational DBMS
Data scheme yes yes yes  
Typing   yes yes yes
Secondary indexes yes yes yes
SQL yes   yes   yes  
APIs and other access methods ADO.NET
JDBC
ODBC
native C library
streaming API for large objects
ADO.NET
JDBC
ODBC
ADO.NET  
JDBC  
ODBC  
Supported programming languages Ada
C
C#
C++
D
Eiffel
Erlang
Haskell
Java
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
.Net
C
C++
Java  
Perl
Python
Tcl
Actionscript
Ada
Basic
C
C#
C++
D
Delphi
Forth
Fortran
Haskell
Java
JavaScript
Lisp
Lua
MatLab
Objective-C
OCaml
Perl
PHP
PL/SQL
Python
R
Ruby
Scala
Scheme
Smalltalk
Tcl
Server-side scripts   yes   user defined functions   no
Triggers yes yes yes
Partitioning methods   horizontal partitioning in MySQL Cluster no, but can be realized using table inheritance   none
Replication methods   Master-master replication
Master-slave replication
MySQL Cluster
Master-slave replication   none
MapReduce no no no
Foreign keys   yes   yes yes
Transaction concepts   ACID   ACID ACID
Concurrency   yes   yes yes  
Durability   yes yes yes
User concepts   Users with fine-grained authorization concept   Users with fine-grained authorization concept no
Specific characteristics open source, since 2010 owned by Oracle Developed as objectoriented DBMS, gradually enhanced with ‘standards’ like SQL
Typical application scenarios Applications with small to medium data volume and little concurrent access
Source:  http://db-engines.com/

The Indispensable Man

The Indispensable Man

(by Saxon White Kessinger)

Sometime when you’re feeling important;
Sometime when your ego ‘s in bloom;
Sometime when you take it for granted,
You’re the best qualified in the room:
Sometime when you feel that your going,
Would leave an unfillable hole,
Just follow these simple instructions,
And see how they humble your soul.    

Take a bucket and fill it with water,
Put your hand in it up to the wrist,
Pull it out and the hole that’s remaining,
Is a measure of how much you’ll be missed.
You can splash all you wish when you enter,
You may stir up the water galore,
But stop, and you’ll find that in no time,
It looks quite the same as before.    

The moral of this quaint example,
Is to do just the best that you can,
Be proud of yourself but remember,
There’s no indispensable man.