Azure stopping support for MariaDB — Is using PostgreSQL or MySQL for Frappe production advisable?

Frappe Framework
, ,
1

Hello Frappe community,

I am planning to deploy a Frappe/ERPNext site on Azure, but I noticed that Azure has stopped offering managed MariaDB.

I am considering using either PostgreSQL or MySQL as the database backend.

My questions are:

  1. Is it safe and recommended to use MySQL for a production Frappe site?
  2. Can PostgreSQL be used reliably in production, or will it cause login/authentication or feature issues?
  3. Are there any known limitations or pitfalls when running Frappe on these databases instead of MariaDB?
  4. If PostgreSQL is not advisable, what is the best approach to deploy Frappe on Azure given the lack of MariaDB support?

Any guidance, experiences, or best practices would be highly appreciated.

Thank you!