SQL Azure + Node.js

Question

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

Answer 1

You can try using REST API. See: SQL Azure Management REST API 

Thanks

Seetha

Answer 2

Hi,

Check out Enzo SQL Shard, which helps you in load balancing your queries across multiple databases parallely

http://enzosqlshard.codeplex.com/

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

http://blogs.msdn.com/b/cbiyikoglu/archive/2010/10/30/building-scalable-database-solution-in-sql-azure-introducing-federation-in-sql-azure.aspx

http://social.technet.microsoft.com/wiki/contents/articles/how-to-shard-with-sql-azure.aspx

 

---

Arunraj Chandrasekaran, MCTS, Author: SQLXpertise.com
If you found this post useful, Please "Mark as Answer" or "Vote as Helpful"

Answer 3

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.

https://github.com/joyent/node/wiki/modules#wiki-db-mssql

---

Nathan Totten Technical Evangelist Microsoft Corporation

Answer 4

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.

Cheers

Martin

Answer 5

Ditto Martin's remark.

I'm debating moving my Node app to azure and I'd really like to see an official Azure SQL driver before I did that.

Keith

Answer 6

Love your site name. Given that you almost have to host your site on nodejitsu.com. Shoot me a private email (martin at wawrusch dot com) regarding Azure SQL and node.js, I'll make an intro to the relevant person at the Azure SQL team for you. 

Answer 7

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

Cheers,

Jonathan

---

This posting is provided 'AS IS' with no warranties, and confers no rights.