Edge is a passthrough to .NET code. It turns out .NET has a really powerful and robust SQL driver. When you use edge you can leverage it.
On Sun, Apr 20, 2014 at 5:06 AM, Bruno Jouhier <[email protected]> wrote: > 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]> 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/e >>>> dge#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. >>> >> >> -- > -- > 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. > -- -- 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.
