Skip to main content
Craft CMS

Return to Question

Citation author edited
Source Link
Romain P.
Romain P.
  • 1.9k
  • 17
  • 32

Craft 3 now supports PostgreSQL.

I know this a very general question, but:

  • I have absolutely no experience with PostgreSQL
  • I don't know when should I use it instead of MySQL

To quote BradBob Olde Hampsink:

PostgreSQL is the most innovative and hot database engine at the moment. It has better UTF-8 support and better overall performance.

Also, for example, on Heroku it is much cheaper to host with Postgres than with MySQL. Thus it becomes more attractive for people to pick a CMS/framework with Postgres support.

Is there another good reasons to know, to choose one instead of the other when starting a new project? For example, in general what would be the gains in terms of performance, compared to MySQL?

Craft 3 now supports PostgreSQL.

I know this a very general question, but:

  • I have absolutely no experience with PostgreSQL
  • I don't know when should I use it instead of MySQL

To quote Brad:

PostgreSQL is the most innovative and hot database engine at the moment. It has better UTF-8 support and better overall performance.

Also, for example, on Heroku it is much cheaper to host with Postgres than with MySQL. Thus it becomes more attractive for people to pick a CMS/framework with Postgres support.

Is there another good reasons to know, to choose one instead of the other when starting a new project? For example, in general what would be the gains in terms of performance, compared to MySQL?

Craft 3 now supports PostgreSQL.

I know this a very general question, but:

  • I have absolutely no experience with PostgreSQL
  • I don't know when should I use it instead of MySQL

To quote Bob Olde Hampsink:

PostgreSQL is the most innovative and hot database engine at the moment. It has better UTF-8 support and better overall performance.

Also, for example, on Heroku it is much cheaper to host with Postgres than with MySQL. Thus it becomes more attractive for people to pick a CMS/framework with Postgres support.

Is there another good reasons to know, to choose one instead of the other when starting a new project? For example, in general what would be the gains in terms of performance, compared to MySQL?

Source Link
Romain P.
Romain P.
  • 1.9k
  • 17
  • 32

Craft 3 : What are the advantages to use PostgreSQL and when should I use it instead of MySQL?

Craft 3 now supports PostgreSQL.

I know this a very general question, but:

  • I have absolutely no experience with PostgreSQL
  • I don't know when should I use it instead of MySQL

To quote Brad:

PostgreSQL is the most innovative and hot database engine at the moment. It has better UTF-8 support and better overall performance.

Also, for example, on Heroku it is much cheaper to host with Postgres than with MySQL. Thus it becomes more attractive for people to pick a CMS/framework with Postgres support.

Is there another good reasons to know, to choose one instead of the other when starting a new project? For example, in general what would be the gains in terms of performance, compared to MySQL?