How does mysql-python compare to pymssql and pyodbc? #21
-
|
So far I was using pymssql and pyodbc to connect to MSSQL and Azure SQL from Python. Both mostly work OK with some issues, and it was never clear to me which one was better or recommended. Now with |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments 4 replies
-
|
Thank you for your feedback! We understand that choosing the right SQL driver can be confusing, especially with multiple options available. Our goal with the new mssql-python driver is to provide a modern, well-supported, and performant solution for connecting to Microsoft SQL Server and Azure SQL from Python. Specifically, we aim to bring improved reliability, better async support, and a more streamlined developer experience. Here is our roadmap: https://github.com/microsoft/mssql-python/blob/alpha/ROADMAP.md In the meantime, if there are specific aspects you’re curious about, feel free to ask—we’d love to hear what’s most important to you! |
Beta Was this translation helpful? Give feedback.
-
|
new article about the benchmark Im curious to see the benchmark with connector-x on select |
Beta Was this translation helpful? Give feedback.
-
|
Great. Thanks devs who work on The first benchmark with SELECT having such a large variance with And yes, would be interesting to extend the benchmarks to cover analytics use cases where the goal is usually to get DB <-> Arrow memory for many MB or even few GB of data which is what polars, pandas, duckdb etc use. |
Beta Was this translation helpful? Give feedback.
-
|
Hi @cdeil Thanks for sharing your feedback. We will triage this and evaluate internally. As of now, there are more items which are on our priority list, but nevertheless we shall take your suggestions as soon as are done with high priority items. Thank you again for your follow up. |
Beta Was this translation helpful? Give feedback.
-
|
I am converting my python analysis code from mssql+pyodbc to mysql-python because new internal security policies require I use ActiveDirectoryInteractive for login, and that doesn't work with pyodbc on linux - but it does with this driver! Thank you for providing it! Looking forward to more functionality - e.g. handling type -155 as described in Issue #213. |
Beta Was this translation helpful? Give feedback.
-
|
Thanks for sharing your feedback @oyvbjork This is encouraging for the team. |
Beta Was this translation helpful? Give feedback.
new article about the benchmark
https://devblogs.microsoft.com/python/mssql-python-vs-pyodbc-benchmarking-sql-server-performance/
Im curious to see the benchmark with connector-x on select
https://github.com/sfu-db/connector-x