# Task OP-4551 - General goal: Make PostgreSQL default instead of MySQL

Project: OpenProject
Status: rejected
URL: https://community.openproject.org/work_packages/OP-4551

## Details

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Date |  |
| Priority | Medium |
| Target versions | 8.0.0 |
| Category |  |
| Labels |  |

## Description

\[This is a long shot work package. Tasks need to be divided into child work packages.\]

We have been discussing this a lot lately and agreed that we should push PostgreSQL over MySQL. Reasons are various (please feel free to add to the list):

  - PostgreSQL fulltext search (FTS) capabilities look better. Maintaining two distinct solutions is too costly. First features using fulltext search are already developed, such as attachment content filters.
  - Transactional migrations: PostgreSQL supports transactions with statements that change the schema. MySQL not.
  - Unicode issues with emojis for MySQL versions older than 5.7.
  - Convenience argument: OP SaaS runs on PostgreSQL.