Enfocus Community

Posted: **Wed Feb 17, 2021 7:22 am**

Hi

I will need to connect to a MSSQL database in some NodeJS scripts.
There are ODBC packages as well as MSSQL packages available for NodeJS
Does anyone have any experience with these packages?
I would like to know how they differ in speed and stability.
We will run many queries with small result-sets.

Robert

Posted: **Tue Feb 23, 2021 8:04 pm**

Hi,
iiiiiiih ms...

I would prefer mssql

Code: Select all

npm install mssql

https://www.npmjs.com/package/mssql
Good examples with promise - for MariaDB I use mysql2

Posted: **Tue Feb 23, 2021 10:32 pm**

https://sequelize.org/

This is a great ORM for node. It will connect to a mssql db and return an object.

Enfocus Community

Connect to MSSQL - to ODBC or not to ODBC?

Connect to MSSQL - to ODBC or not to ODBC?

Re: Connect to MSSQL - to ODBC or not to ODBC?

Re: Connect to MSSQL - to ODBC or not to ODBC?