Has anyone ever tried connecting to a Microsoft SQL server with Node.js using this or any other library? and what’s your experience.
I’m sure many people must’ve used the package. Why else will it be published if no one uses it. I’ve just had a look and it seems to work okay.
That said, you’re better off asking this question on StackOverflow. But before you do, you should improve your question so that it’s specific and detailed (see how to ask for guidelines).
With this type of question, the only reply you’d get is a yes. or no.
No, I think my question is perfectly structured. I asked if anyone has used it, and their personal experiences if they have
Again, this isn’t a question of if the package is okay or not… I can easily tell that with the number of downloads during the last day and the total number of downloads on the npm website.
The question is meant to be a discussion on personal experience connecting Node.js to a MSSQL server.
I wouldn’t say your question is particularly vague but ‘perfectly structured’ isn’t the phrase I would have gone for.
@michael, I have. I used Sequelize. I had to expose some data via APIs to be consumed by clients on BrightSign Digital Signage.
Sequelize documentation is pretty detailed. IMO.
It’s somewhat an abstraction for SQL databases. So, you can use it with postgres, mysql, sqlite3 or mssql. To use with mssql, you’d use the package tedious with it.
I used Epilogue to create REST endpoints and Sequelize-heirarchy to manage “trees”. You can check these libraries out on npm.
2 Likes
Sequelize is great if your the ORM type, You can simply use tedious directly.