I am also in favor of dropping MSSQL. We have seen a lot of trouble with this particular backend, and with the data points you mentioned it definitely seems that it's not worth all the efforts to maintain it.
Le ven. 18 août 2023 à 16:28, Wei Lee <weilee...@gmail.com> a écrit : > +1 (non binding) > > I agree with this direction. It would be helpful to guide users on their > next steps as Jarek suggested. > > Best, > Wei > > > On Aug 18, 2023, at 9:29 PM, Michał Modras <michalmod...@google.com.INVALID> > wrote: > > > > +1 - I strongly agree with the direction too. > > > > On Fri, Aug 18, 2023 at 2:31 PM Jarek Potiuk <ja...@potiuk.com> wrote: > > > >> I am strongly for it. I wanted to raise the same proposal after we see > the > >> results of the survey (which I hope we will run after the Summit) - in > >> order to get more data points on how many users use it. But I agree the > >> datapoints we have support the "low usage, high trouble" status of it. > >> MSSQL creates a lot of troubles, it has bitten us more than once. > >> > >> One comment though: I think an important point of this removal should be > >> some viable way for our users to move out to (likely) Postgres. We > should > >> provide at least a description, ideally some scripts that will be able > to > >> move data from MSSQL to Postgres as part of this "support dropping". > >> > >> I hate to say to anyone "sorry, no more support, deal with it yourself". > >> > >> But saying: "sorry, no more support, here is a way how you can migrate > to > >> what we support" is a much better message . > >> > >> J. > >> > >> > >> J. > >> > >> > >> On Fri, Aug 18, 2023 at 2:06 PM Elad Kalif <elad...@apache.org> wrote: > >> > >>> Hello everyone, > >>> > >>> In May 2021 we added MsSQL as an experimental backend. PR > >>> https://github.com/apache/airflow/pull/9973 > >>> Mailing list announcement: > >>> https://lists.apache.org/thread/byx4czfyowwm3qy8c8p2o65vd53fyvsd > >>> > >>> During this time we hoped it would become stable and widely adopted. > >>> To my taste MsSQL a backend has left a niche and is *not* worth the > >>> maintenance of it in our CI. > >>> > >>> Some data points: > >>> > >>> 1. Only 5 issues > >>> < > >>> > >> > https://github.com/apache/airflow/issues?q=is%3Aissue+label%3Abackend-mssql-experimintal+is%3Aopen > >>>> > >>> were > >>> reported on MsSQL as a backend which suggests it's not widely > adopted. > >>> These issues also don't have much traffic. > >>> 2. None of the Airflow as service cloud vendors use it as a backend > or > >>> expressed interest in it (to the best of my knowledge) > >>> 3. We had many PRs trying to fix issues related to MsSQL. To name a > >> few: > >>> https://github.com/apache/airflow/pull/33265 > >>> https://github.com/apache/airflow/pull/32433 > >>> https://github.com/apache/airflow/pull/31815 > >>> each one required diagnostic and effort to address the problems (in > >> some > >>> cases required also rebasing of all other PRs after fix was merged) > >>> > >>> > >>> I think that after 2+ years of experiment we can terminate it. > >>> Since this is experimental we can drop support for this feature as this > >> is > >>> not considered a breaking change. > >>> > >>> *My Proposal:* > >>> Drop support for MsSQL as official/supported backend. > >>> > >>> WDYT? > >>> > >>> Elad Kalif > >>> > >> > >
