SQL Server and Node.js Revisited
A little more than a year ago, I wrote about accessing SQL Server from Node.js using Edge.js. Technology can change a lot in a year, and I'm happy to report the Node.js modules for SQL Server have greatly improved. Not only that, but some of the brilliant developers I work with at LeanKit have created seriate, designed to make working with SQL Server from Node.js as painless and friction-free as possible.
I've written an introduction to seriate over on our new and shiny LeanKit Developer Blog. It really is a wonderful approach to managing data in SQL Server, and I hope you check it out.
By the way, seriate is just "the tip of the iceberg" among the amazing catalog of open source projects available at LeanKit Labs. Expect to see more articles on these projects in the future!
Comments
3 archived comment(s) from this site's previous comment system. These are read-only — join the discussion above.
Took a quick look at seriate, looks cool. I could not see support for Integrated Security (SSPI) though. Am I correct ?
Seriate supports trusted/NTLM authentication, which you can read about on the seriate repository at https://github.com/LeanKit-....
By SSPI, I'm assuming you mean it authenticates with the user context under which the node application is currently running? Seriate depends on the mssql module for the underlying SQL work. As far as I can tell, mssql does not support SSPI.
Thanks for the quick reply! Yes, that's what I meant. I can do SSPI authentication easily with pyodbc in python but fails to find something as easy for node.js.