electron shell native binaries

for those who do not wish to compile this driver for electron, then this release will help. Included are 32 bit / 64 bit versions for electron.

a script is provided

for manual compiling, ensure VS 2015 is installed.

 npm install msnodesqlv8
 cd msnodesqlv8
 npm install electron-prebuilt
 tool\build-electron.bat

should produce binaries that work with your electron.

stability release - improvements in memory management.

This is a production quality candidate release. Using continuous test runs, issues have been found with the garbage collector from node and the data structures held in the C++ driver. A fairly major overhaul of the code was required to isolate and fix these problems.

All users are advised to upgrade to this version as under load the previous driver is prone to either fail or produce undefined behavior.

Prepared Statements

The library now supports prepared statements where memory is reserved, bound to columns representing the query and the statement left open where it can be repeatedly invoked with new parameters. This release required a fair amount of work in the c++ driver as previously the one statement was always used and disposed for a query. Please see unit test case file prepared.js for a few examples. Note, prepared statements must be released when no longer required. The driver and hence database will keep resources allocated until it is freed.

For repeated invocations of the same SQL, this feature should provide a performance improvement as the query is bound to columns once thus reducing overhead for subsequent calls.

null / empty string binding.

Fix for binding null string

this release should now bind null and empty string correctly. There have been unit tests added to ensure this functionality does not break again.

Better management of sql_variant

SQL_VARIANT conversion to correct JS type

with sql_variant column types, the driver now reads the header to obtain the correct underlying type. The conversion will then take place as if the column was that type. Simple types such as numeric, boolean, string, int and dates will work and have had tests added.