tedious

• Add option to bind to specific local address. (Bryan Ross)
• Add support for set xact_abort per-connection. (Bryan Ross)

• #182 Added support for readonly intent and automatic connection re-routing. (Bryan Ross)

• #224 Fix Rerouting on TLS Encrypted Connections. (Christopher Anderson)

• #192 Remove default SSL cipher suite. (Greg Brail)

• Changed the API quite a bit, and documented it.
• Removed dependency on buffer-tools package. This was the only package with C++, so it should be easier to use tedious on Windows now.
• Added main property to package.json.
• Added ReadableTrackingBuffer and WritableTrackingBuffer, making a lot of Buffer building and parsing code a lot simpler.
• Added support for more data types in result sets (Ciaran Jessup): bigint, binary, varbinary, varbinary(max), varchar(max), nvarchar(max), real, float.
• Simplified error handling for unrecoverable errors.
• Use a statemachine for connection state (making it much easier to implement the states documented in the TDS specification).
• Make packet size configurable.

The initial release.

• Tedious is just about useable for simple statements.
• Session establishment and authentication work.
• Sending SQL statements (in a SQL_BATCH packet) works for some simple statements.
• Many simple data types are supported.

• #231 Add Connection#saveTransaction to create transaction savepoints. Change Connection#rollbackTransaction to allow manually specifying a transaction or savepoint name. Introduce new Connection#transaction helper to simplify transaction handling, especially when nesting transactions. (Rohit Arjunagi, Arthur Schreiber)

• Extended error information (Lee Houghton)
• #202 Integrated type checks (Patrik Simek)
• #207 Fix issues with Login7 Payload (Alex Robson)
• #243 Fix crypto deprecation warning with Node v0.11.14+ (Rob Shaw)
• #237 Fix date, time and datetime2 when useUTC is false (Patrik Simek)
• Minor fixes

• #230 New columns are now nullable by default. This can be disabled using config.options.enableAnsiNullDefault = false. (Lee Houghton)

• #253 Fix daylight saving issue for non utc dates. (Stefan Lüchinger)

• #275 Do not pass additional arguments to transaction continuation. (Arthur Schreiber)

The major change in this release is a revamped, generator based stream parsing code.

This new stream parsing code significantly reduces the memory used by tedious and increases performance. These improvements are especially noticable when fetching results with large columns (like varbinary(max) or nvarchar(max)). A simple benchmark for transferring 50MB of varbinary data shows that tedious now uses only 60MB (instead of more than 320MB) of memory and parsing is 10000% faster. For smaller data sizes, the improvements are not as profound but still noticeable.

All tedious dependencies were also bumped to their latest versions to ensure we include all their latest fixes.

Detailed Changelog

• #288 Upgrade dependencies to their latest versions
• #285 Generator based stream parser

This release updates the npmjs.com API Key that's used for the Travis release automation.

No other change from 1.11.3.

This release contains a bugfix that corrects the validation of date parameters.

It also contains a few non-user facing changes that streamline the release process and improve our CI setup.

Detailed Changelog

• #254 Release automation using travis: Pushing a new tag to the github repository will automatically try to release a new version of tedious on npm.
• #283 Run more CI builds on travis, on the fast container infrastructure.
• #252 Make AppVeyor builds a bit more stable.
• #276 Do not let invalid dates pass the data validation check.

• #168 Added support for transactions in TDS 7.1 (SQL Server 2000). (Patrik Simek, Bret Copeland)
• Fixed a bug when prepared statement has no parameters. (Patrik Simek)