mik-laj commented on issue #10713: URL: https://github.com/apache/airflow/issues/10713#issuecomment-698134930
This is a community managed project so it's a bit complicated. We only focus on MySQL and PostgresSQL as this is the most used database and we have automatic tests run on CI. We do not have the technical, time and personal resources to fully support the RDBS. As far as technical resources are concerned, we lack the hardware to run build on the CI, this time using MSSQL. As far as time resources are concerned, core committers have limited time, so they only focus on environments they know well and use in production. As far as personal resources are concerned, Maybe some committers are familiar with MSSQL, but most know PostgresSQL and MySQL better. Airflow is mainly compatible with Linux, and MSSQL on Linux is quite a fresh product, so not everyone has the skills to use MSSQL yet. On the other hand, it is an open-source project and is open to any contribution. If someone wants to support MSSQL support on their own, we are open to accept the patches. This doesn't seem to be a big problem as all the minor incompatibility bugs need to be corrected. And then test each new release while there is [a public vote](https://lists.apache.org/[email protected]:lte=12M:VOTE%20release%20Apache%20Airflow) on a new release. When we are sure that there will be a person willing to maintain MSSQL in the long-term, we can decide to fully support MSSQL. This will mean that we will have to find hardware resources, but I think we can do it. The biggest challenge for us is the lack of people and time to support MSSQL. Would you like to help us with this task? I think there are also other people who will be willing to help you with some issue. See: https://github.com/apache/airflow/pull/9973/files This change adds MSSQL to our development environment so that we can easily test Airflow with MSSQL. When we do this, it will be easier for us to fix the incompatibility issues. CC: @NadimYounes @NadimYounes ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected]
