Difference between MySQL and PostgreSQL

 

Difference between MySQL and PostgreSQL.

1. MySQL:

    Relational database.

    Case-insensitive.

    Limited basic data type support.

    Uses indexes: R, B, Hash.

    Concurrency control.

2. PostgreSQL:

    Object-relational database (DB).

    Case-sensitive.

    Advanced data type support.

    Multiple types of indexes.

    Multiversion concurrency control (MVCC).