Nimesh Kumar

01/28/2023, 1:19 PM
Hi everyone, I was just going through the database that prefect support and it supoort SQLite, Postgres but not Mysql. Can anyone please tell me why ? because all three i.e. SQLite, postgres and mysql comes under same family.

Rajvir Jhawar

01/29/2023, 7:27 AM
If by "family" you mean they are all open source rdbms then that is true. The real reason only 2 databases were selected comes down to practical reasons: 1. SQLite is lightweight and embeddable (this is default if no "production" grade db is used) 2. Postgres is arguably the most performant production ready sql db of the three Each database may run sql queries, but each database has its own quirks and performance issues you have to optimize for. Why invest the time in up-keeping MySQL when Postgres will meet the needs for production.

Nimesh Kumar

01/29/2023, 8:10 AM
Thanks Rajvir for the response Actually we are using MySQL for our product so we were just curious if we can use MySQL for prefect also.