I have no experience with large volumes of data. I copied the link for you to mssql<https://github.com/patriksimek/node-mssql>, what I had forgotten.
This library is based on tedious, which can handle events for each row. Maybe you could use tedious, I used this because it is much simpler and adapted to my needs. Ale. [email protected] 2014-04-18 19:24 GMT-03:00 Bruno Jouhier <[email protected]>: > Found some bench figures here: > https://github.com/patriksimek/node-mssql/issues/15. Looks like C++ > driver is the fastest. > > Bruno > > > On Saturday, April 19, 2014 12:13:46 AM UTC+2, Bruno Jouhier wrote: >> >> 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] >>> >>> >>> 2014-04-18 18:44 GMT-03:00 Bruno Jouhier <[email protected]>: >>> >>>> 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] >>>> 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.
