Hi Glenn, I share your feelings.
I'm a bit surprised that a pure JS implementation of TDS does not win on performance. The Edge/ADO.Net combo must be doing some really cool tricks. Tomasz says that mono support is just around the corner. Will help me because I'm developing on Mac. Bruno On Saturday, April 19, 2014 9:46:45 PM UTC+2, Glenn Block wrote: > > (sigh) > > That's my only response when you mention the MS SQL driver. I was very > optimistic when the project launched, but due to internal priorities it > seems to have hit a stand still. > > Fortunately there are other options. As Tomek said, using Edge to talk to > SQL is rock solid and yields the best possible performance (IMO). > > I am not sure it works yet on the mono side (thought it may), but I > imagine if it doesn't that's a shorter term issue. > > > On Sat, Apr 19, 2014 at 2:57 AM, Bruno Jouhier <[email protected]<javascript:> > > wrote: > >> Thanks a lot Tomasz. This is very helpful. I'll contact Dan to have more >> info and I'll give it a try. >> >> Thanks @siculars too, it won't help me as much because I'm really looking >> for a driver but that's good to know. >> >> Bruno >> >> >> On Saturday, April 19, 2014 5:58:13 AM UTC+2, Tomasz Janczuk wrote: >>> >>> 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]<javascript:> >> To unsubscribe from this group, send email to >> [email protected] <javascript:> >> 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] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- -- 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.
