+1 (non binding) I agree with Jareks statement that a migration path need to be offered. Actually in my former company I was a strong fanboy of MSSQL and the DB engine has good capabilities, but of course if the user base is small does not make sense to support it. (I would rather drop MySQL if I would need to drop any DB but I assume the user base for this is larger 😃)
Mit freundlichen Grüßen / Best regards Jens Scheffler Deterministik open Loop (XC-DX/ETV5) Robert Bosch GmbH | Hessbruehlstraße 21 | 70565 Stuttgart-Vaihingen | GERMANY | http://www.bosch.com/ Tel. +49 711 811-91508 | Mobil +49 160 90417410 | jens.scheff...@de.bosch.com Sitz: Stuttgart, Registergericht: Amtsgericht Stuttgart, HRB 14000; Aufsichtsratsvorsitzender: Prof. Dr. Stefan Asenkerschbaumer; Geschäftsführung: Dr. Stefan Hartung, Dr. Christian Fischer, Dr. Markus Forschner, Stefan Grosch, Dr. Markus Heyn, Dr. Tanja Rückert -----Original Message----- From: Michał Modras <michalmod...@google.com.INVALID> Sent: Freitag, 18. August 2023 15:29 To: dev@airflow.apache.org Subject: Re: [DISCUSS] Drop MsSQL as supported backend +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://gi/ > > thub.com%2Fapache%2Fairflow%2Fpull%2F9973&data=05%7C01%7CJens.Scheff > > ler%40de.bosch.com%7Ce9f2c5bf46614006683d08db9fef272b%7C0ae51e1907c8 > > 4e4bbb6d648ee58410f4%7C0%7C0%7C638279621718009025%7CUnknown%7CTWFpbG > > Zsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn > > 0%3D%7C3000%7C%7C%7C&sdata=7em5NIhWjH9qQ4MOcpPuRsVeHwYAdAYXXmm%2FkNB > > 7aSY%3D&reserved=0 > > Mailing list announcement: > > https://li/ > > sts.apache.org%2Fthread%2Fbyx4czfyowwm3qy8c8p2o65vd53fyvsd&data=05%7 > > C01%7CJens.Scheffler%40de.bosch.com%7Ce9f2c5bf46614006683d08db9fef27 > > 2b%7C0ae51e1907c84e4bbb6d648ee58410f4%7C0%7C0%7C638279621718009025%7 > > CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6I > > k1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=quD7GivIsSsB4OGin3uSqgjS > > YAa5CWhE%2Bdl6U85lrgE%3D&reserved=0 > > > > 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://gith/ > ub.com%2Fapache%2Fairflow%2Fissues%3Fq%3Dis%253Aissue%2Blabel%253Aback > end-mssql-experimintal%2Bis%253Aopen&data=05%7C01%7CJens.Scheffler%40d > e.bosch.com%7Ce9f2c5bf46614006683d08db9fef272b%7C0ae51e1907c84e4bbb6d6 > 48ee58410f4%7C0%7C0%7C638279621718009025%7CUnknown%7CTWFpbGZsb3d8eyJWI > joiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7 > C%7C%7C&sdata=7BeYitqfIP8X2ptQowz3JDfgb7E%2Fw9Hx8NK4lfPmF4E%3D&reserve > d=0 > > > > > 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 > > >
