使用pypyodbc，pymssql和pyodbc的优点和缺点是什么? [英] What are the advantages and disadvantages of using pypyodbc, pymssql, and pyodbc?

问题描述

我知道Pypyodbc是Pyodbc的较新版本.之前有人问过这两者之间的比较问题，但我想将Pymssql添加到混合中.

I know that Pypyodbc is the newer version of Pyodbc. A question before asked about the comparison between these two but I want to add Pymssql into the mix.

推荐答案

截至2019年12月:

As of December 2019:

pyodbc 正在积极开发中，

pyodbc is under active development, is officially supported by Microsoft (when using the current version of Microsoft's ODBC Driver for SQL Server), and has a couple of Microsoft employees contributing bug fixes and new features that relate to accessing SQL Server and Azure SQL.

pypyodbc 出现在pyodbc之后，但不是"pyodbc的较新版本"，它是另一种纯Python实现.自2017年1月以来，该产品尚未正式发布.

pypyodbc came along after pyodbc but is not "the newer version of Pyodbc", it is an alternative pure-Python implementation. It has not seen an official release since January 2017.

pymssql 失去了很多动力，并且

pymssql lost a lot of momentum and has been discontinued.

这篇关于使用pypyodbc，pymssql和pyodbc的优点和缺点是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！