Does anyone here know about an sql azure driver for node.js? Maybe something experimental inside MS?
-- My Azure Sites: www.eblizz.com , www.freshfugu.com Blog: martinatsunset.com Twitter: martin_sunset
- Moved by Brad Calder Saturday, March 26, 2011 6:23 PM SQL question (From:Windows Azure Storage)
Check out Enzo SQL Shard, which helps you in load balancing your queries across multiple databases parallely
Also check out SQL Azure Federations, SQL Azure Federations is in Private CTP, which is expected to be released in Q4 of 2011 for Public CTP
Arunraj Chandrasekaran, MCTS, Author: SQLXpertise.com
If you found this post useful, Please "Mark as Answer" or "Vote as Helpful"
We don't have an official driver for MSSQL or SQL Azure specifically, but there are a number of community produced node modules that should work.
Nathan Totten Technical Evangelist Microsoft Corporation
- Proposed as answer by ntottenMicrosoft employee Friday, March 16, 2012 9:05 PM
Hi Nathan, I actually posted about this on the tedious mailing list a couple days back (https://groups.google.com/forum/?fromgroups#!topic/node-tedious/gMXw5EaCq98) and it seems that it does not work. Not sure about the other drivers, but one is windows only and the other one had this issue: https://github.com/cretz/node-tds/issues/14
It would be really great and in Microsoft's best interest if the company would commit some resources to make the tedious driver work well with Azure SQL. Right now Azure SQL is really competitively priced and the one part of Azure that really shines. While we use hosted mongodb for everything else we need a solid SQL database for our billing system and I really want to use SQL Azure for this.
Adding a link to this thread for those hitting it via web searches. We've got a Node.js driver for SQL Server and SQL Database located at Github: https://github.com/windowsazure/node-sqlserver
This posting is provided 'AS IS' with no warranties, and confers no rights.