(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/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.
>

-- 
-- 
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.

Reply via email to