Node.js Gets SQL Server Driver, Better Windows Tooling
Node.js is already supported in Windows Azure and now Microsoft is looking to improve tooling around the same – WebMatrix 2 sports several new features which aim to simplify Node development on Windows machines including
- Streamlined installation
- New starter templates
- Support for Jade and EJS templating engines
- A new CoffeeScript Editor
You can see these features in more detail in this article by Justin Beckwith. WebMatrix 2 also has other new features for web development in general, such as better support for LESS, Emulators for Windows and iOS devices, and a new extensions gallery.
WebMatrix v2 employs the same WPF based core editor surface that first appeared in Visual Studio 2010. This allows us to share features between VS, VWD and WebMatrix.
As such, it is at least technically feasible that some of these features could eventually make it to Visual Studio as well.
The new SQL Server Driver for Node.js allows you to write inline queries and fetch data from SQL Server or SQL Azure. Apart from fetching all the rows in one result set by passing a call-back function, you can also subscribe to individual events when the metadata and then each row or column is fetched. You can see the syntax in these tests.