That is - how MSSQL performs w/ Airflow (not in general). And also, nice work Aneesh!
On Wed, May 26, 2021 at 9:56 AM Ry Walker <r...@rywalker.com> wrote: > Curious - was any performance analysis done comparing how MSSQL > performance compares w/ MySql and Postgres? > > On Wed, May 26, 2021 at 9:53 AM Kaxil Naik <kaxiln...@gmail.com> wrote: > >> Yeah Kudos to Aneesh -- Sometimes it just takes a lot of patience but >> this will surely be helpful for many users using MSSQL >> >> On Wed, May 26, 2021 at 2:22 PM Shaw, Damian P. < >> damian.sha...@credit-suisse.com> wrote: >> >>> Thanks Aneesh, and all who helped! >>> >>> >>> >>> Damian >>> >>> (he/him) >>> >>> >>> >>> *From:* Jarek Potiuk <ja...@potiuk.com> >>> *Sent:* Wednesday, May 26, 2021 06:55 >>> *To:* dev@airflow.apache.org >>> *Subject:* Re: MSSQL compatbility for Airflow, YAY! >>> >>> >>> >>> I was just helping a bit :) and Kaxil, and Ash and others :) But Aneesh >>> did all the hard work :) >>> >>> >>> >>> J. >>> >>> >>> >>> >>> >>> On Wed, May 26, 2021 at 12:46 PM Sumit Maheshwari < >>> sumeet.ma...@gmail.com> wrote: >>> >>> Awesome.. Great work Aneesh & Jarek.. 👏👏 >>> >>> >>> >>> On Wed, May 26, 2021 at 3:11 PM Jarek Potiuk <ja...@potiuk.com> wrote: >>> >>> Hello everyone, >>> >>> >>> >>> After a looooong struggle and ENORMOUS effort from Aneesh Joseph we have >>> just merged the PR that adds MSSQL for the Dev version of Airflow. >>> https://github.com/apache/airflow/pull/9973 >>> >>> >>> >>> It has full support for MSSQL - on-par with MySQL and Postgres to run >>> Airflow in production. >>> >>> >>> >>> We will likely have to sort out some documentation and do some more >>> verification on how well it copes with Scheduler HA scenario and update the >>> docs but it looks like the next "minor" release of Airflow will have >>> full support for MSSQL backend. >>> >>> >>> >>> It would be great if people who are interested in MSQL in the community >>> could take it for a spin and test it more in "production like" settings. >>> >>> >>> >>> Thanks Aneesh for your patience and persistence! You needed a lot of it. >>> >>> >>> >>> The PR was started in July 2020 (!) but it went through many comments >>> and iterations and I think it touched nearly every part of Airflow - >>> starting from core changes to accommodate MSSQL limits, CI configuration, >>> Breeze, SQLAlchemy migrations - you name it. And countless rebases and >>> conflict resolution along the way! And Countless comments from many >>> committers who helped to move this forward. >>> >>> >>> >>> Fantastic job! This is great to have such people in the community who >>> can deliver huge things like this. >>> >>> >>> >>> J. >>> >>> >>> >>> -- >>> >>> +48 660 796 129 >>> >>> >>> >>> >>> -- >>> >>> +48 660 796 129 >>> >>> >>> ============================================================================== >>> Please access the attached hyperlink for an important electronic >>> communications disclaimer: >>> http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html >>> >>> ============================================================================== >>> >>
