Using Node.js to connect to Microsoft SQL Server 2008 (MSSQL) database

11,610

Solution 1

Just today I released a new module, for windows only, allowing native and asynchronous use of MSSQL. It's called TSQLFTW, and currently supports connecting and querying the database. It returns results in JSON.

Check out the Github here: https://github.com/gfosco/tsqlftw

Hacker News submission/comments: http://news.ycombinator.com/item?id=3353389

Solution 2

I am working on a solution (https://github.com/pekim/tedious), but it's not quite usable yet.

Currently it can connect, authenticate, send SQL statements. The parsing of the response to the statement is in progress; some column metadata is processed, and the rows data itself is next.

In the next few weeks (it's a spare time project), I hope to have it in a useable, but far from complete state. The API, and the guts of it, will still be subject to significant changes though, as there's lots that I'm still unhappy about. There's quite a bit of additional error checking and state handling that need to be addressed, as well as stored procedures and parameterised statements.

I'll try to update the status in the README a bit more frequently, so that's it's easier to see how close (or far) from useable it is.

Share:
11,610

Related videos on Youtube

paperclip
Author by

paperclip

Updated on June 04, 2022

Comments