One of the best ways to access MS SQL is to use .NET Framework's ADO.NET. You can use ADO.NET from within your Node.js application via Edge.js (http://tjanczuk.github.io/edge), which supports running CLR and Node.js code in-process and provides an interop model between the two. If your MS SQL access needs are simple (CRUD), you can use the edge-sql extension to Edge.js (https://github.com/tjanczuk/edge#how-to-script-t-sql-in-a-nodejs-application), which allows you to simply script parameterized T-SQL within your Node.js application.
Edge.js currently only works on Windows, but support for MacOS and Linux via Mono is just around the corner (you can actually use the bits from GitHub on MacOS and Linux even today; I am performing some last rites before pushing to NPM). There are many folks who are using Edge.js specifically to access MS SQL via ADO.NET - this is one of the more frequent applications. The one web app I know is using Edge.js to acces MS SQL is http://www.cellartracker.com/. @danpolivy has done extensive benchmarking of available solutions to access MS SQL from Node and concluded using ADO.NET via Edge was the fastest by a large margin (~3x) compared to the next alternative. Ping @danpolivy for details. On Friday, April 18, 2014 11:24:56 AM UTC-7, Bruno Jouhier wrote: > > Just looked at the official driver project ( > https://github.com/Azure/node-sqlserver) and was very disappointed to see > that it has not been updated for more than 1 year. > > Tedious (https://github.com/pekim/tedious) seems to be the only really > active project. Is this the right? > Anyone willing to share his/her experience with mssql drivers? > > Bruno > -- -- Job Board: http://jobs.nodejs.org/ Posting guidelines: https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines You received this message because you are subscribed to the Google Groups "nodejs" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nodejs?hl=en?hl=en --- You received this message because you are subscribed to the Google Groups "nodejs" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
