Which disadvantages of MySQL?


The documentation said:

We strongly recommend using postgres instead of mysql. The system has been optimized for features not found in mysql.

Can you describe in more detail what I lose if I use MySQL?

This is important for our company. We use MySQL because we are used to working with it and I have no arguments to suggest moving to Postgres.


Sqlite and Postgres both support partial indexes and mysql does not. Drone uses partial indexes for critical functionality, but has to emulate this feature for mysql. Some notable projects like GitLab [1] deprecated support for mysql completely. We have no plans to deprecate support, however, both Postgres and Sqlite are safe choices.

[1] https://about.gitlab.com/blog/2019/06/27/removing-mysql-support/

1 Like