Thanks Alejandro.
What if your query returns zillions of rows (and you really want them all
because you are doing some kind of data pump)?
You cannot use the callback API and I did not see how you could control the
flow of "row" events with the event API. Do you have any experience with
this?
Did you bench the drivers? I'm curious about the performance of a C++
driver vs. a pure JS TDS driver like tedious.
Bruno
On Saturday, April 19, 2014 12:04:19 AM UTC+2, Alejandro Paciotti Iacchelli
wrote:
>
> I am developing an app that has to read data from SQLSERVER.
> After much reading and testing, I decided to use mssql.
>
> "mssql": "*" in my package.json
> npm install
>
> and as an example:
>
> *var sql = require ('mssql'); *
> *var database = {user = 'youruser', password = 'yourpass', server =
> 'localhost', database= 'yourdatabasename' port = 1433};*
>
> *var connection = new sql.Connection (database, function (err) {*
>
> *var request = new sql.Request (connection); *
>
> *request.query ('SELECT * FROM your_view', function (err, rsDatosClientes)
> {*
>
>
> *rsDatosClientes; *
>
> *res.json (rsDatosClientes); *
> *}); *
> *});*
>
>
> It work for me.
>
> Good Luck!
>
>
>
>
>
> [email protected] <javascript:>
>
>
> 2014-04-18 18:44 GMT-03:00 Bruno Jouhier <[email protected] <javascript:>>
> :
>
>> Thanks Ben,
>>
>> I took a look at it before asking and I was wondering how people can use
>> it to stream the rows returned by very large queries. The callback API is
>> unhelpful for this and I did not see any pause/resume API to control the
>> flow of row events. Tedious does not seem to hande this either (but I only
>> took a quick look).
>>
>> The mysql driver gave me the right API. For oracle, I had to extend the
>> driver with a reader API because the existing API was too simplistic. I was
>> hoping to get this out of the box from mssql drivers but it looks like I'll
>> have to implement it.
>>
>> Bruno
>>
>> On Friday, April 18, 2014 10:19:30 PM UTC+2, Ben Noordhuis wrote:
>>
>>> On Fri, Apr 18, 2014 at 8:24 PM, Bruno Jouhier <[email protected]>
>>> 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
>>>
>>> As a datum point: all the people I know that use iisnode, also use
>>> msnodesql a.k.a. node-sqlserver. That's a sample size of ~10 so make
>>> of it what you will.
>>>
>>> And yeah, the last commit was nine months ago. I'm not sure if that
>>> means it's unmaintained or that everything just works but the open
>>> issue count suggests it's the former.
>>>
>> --
>> --
>> 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.
