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
Connect to MSSQL - to ODBC or not to ODBC?
-
- Member
- Posts: 93
- Joined: Fri Jul 08, 2011 10:31 am
- Location: The Netherlands
Re: Connect to MSSQL - to ODBC or not to ODBC?
Hi,
iiiiiiih ms...
I would prefer mssql
https://www.npmjs.com/package/mssql
Good examples with promise - for MariaDB I use mysql2
iiiiiiih ms...
I would prefer mssql
Code: Select all
npm install mssql
Good examples with promise - for MariaDB I use mysql2
-
- Newbie
- Posts: 12
- Joined: Mon Jan 25, 2021 8:24 pm
Re: Connect to MSSQL - to ODBC or not to ODBC?
https://sequelize.org/
This is a great ORM for node. It will connect to a mssql db and return an object.
This is a great ORM for node. It will connect to a mssql db and return an object.