Windows Azure SQL Database Marketplace
One of the things that sort of snuck out in the spring update for Windows Azure is the Microsoft Driver for Node.js for SQL Server. A long name for a driver with a singular purpose: connecting your node applications to SQL Server technologies such as the Windows Azure SQL Database.
Currently the driver is available as a preview release, and the code is available on GitHub.
The driver is very easy to use, expecting only a standard ODBC connection string (easily obtained through the Windows Azure Preview Portal,) and allows you to issue Transact-SQL statements through the query method. Where things get a little different is that you can return a 'statement' from a query that allows you to receive events as data entities are returned through the query.
For the basics of working with Windows Azure SQL Database using the driver, see How to Access Windows Azure SQL Database from Node.js. This provides basic information on:
Using the new preview portal to provision a database
The Node.js Web Application using the Windows Azure SQL Database article provides a more complex example of using the driver in a node application. This tutorial walks through:
As I mentioned earlier, this driver is available on GitHub and that includes accepting issues, feedback and contributions from you. Feel free to drop by and let us know what you want to see in this driver, or submit code to add a feature yourself.
-By Larry Franks, Principal Programming Writer, Windows Azure