英文:
What is msnodesqlv8 to node-mssql?
问题
https://www.npmjs.com/package/msnodesqlv8 与 https://www.npmjs.com/package/mssql 之间的关系是什么？
文档很令人困惑，我可以以几种不同的方式解释它。
英文:
What is the relationship between https://www.npmjs.com/package/msnodesqlv8 and https://www.npmjs.com/package/mssql?
The documentation is confusing and I can interpret it a few different ways.
答案1
得分: 3
> 这个库完全兼容使用 MS ODBC 驱动程序的 MS SQL Server。许多功能，如打开、查询、连接池、准备、事务、关闭，都可以与任何兼容ODBC驱动程序及其相应数据库的驱动程序一起使用。
mssql 使用 Tedious，它是：
> Tedious 是一种纯 JavaScript 实现的 TDS 协议，用于与 Microsoft 的 SQL Server 实例交互。它旨在是协议的相对精简实现，没有太多额外的功能。
因此，一个是官方支持的 Microsoft ODBC 驱动程序的包装器，但需要在您的操作系统或容器中安装该ODBC驱动程序，而另一个是纯 JavaScript TDS 客户端的包装器，因此您可以通过 NPM 完全添加它，但它不是官方的 Microsoft 驱动程序，尽管有一些 Microsoft/Github 贡献者。
您应该预期 Tedious 可能不支持最新的 TDS 协议版本以及 TDS 协议的一些不常用功能，并且如果发现任何问题，您将无法为其打开 Microsoft 支持案例；这些问题将由社区在 Github 存储库中处理。
英文:
> This library has full compatibility with MS SQL Server using an MS
> ODBC driver. Many functions e.g. open, query, connection pool,
> prepare, transactions, close will work with any ODBC compatible driver
> with its respective database.
mssql uses Tedius which is:
> Tedious is a pure-Javascript implementation of the TDS protocol, which
> is used to interact with instances of Microsoft's SQL Server. It is
> intended to be a fairly slim implementation of the protocol, with not
> too much additional functionality.
So one is a wrapper around the official Microsoft supported ODBC driver, but requires installing that ODBC driver in your OS or container, while the other is a wrapper around a pure-Javascript TDS client so you can add it purely through NPM, but which is not an official Microsoft driver, even though there are some Microsoft/Github contributors.
You should expect that Tedius may lack support for the very latest TDS protocol versions and for some less-used features of the TDS protocol, and that you won't be able to open a Microsoft support case for any issues you find; those would go to the Github repo to be addressed by the community.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论