Can we use MySQL db as a backend for prefect-io?

Help
, ,
1

Hey, I realise from the documents that the recommended backends for prefect are

  1. Sqlite3
  2. PostgreSQL

but I still want to know if MySQL can be patched in as a server database? We’d prefer to not use more backend databases than necessary. I was wondering if MySQL can be a supported backend DB since Sqlite3 is also supported and the queries are made via SQLAlchemy.

Thanks

2

MySql is not support by Prefect Server. I can’t attest to the portability of SqlAlchemy but we definitely make use of some postgres features. I would recommend sticking with what is documented.