Change Log
v0.1.4 2013-04-14
- Add placeholder event handlers to suppress crash in final. (Nicholas Penree) (Issue #80)
- Better default values for options in default sql statement. (Kevin Pullin) (Issue #83)
- Expose collected rows in request callback and done* events. (Issue #73)
- Add connection.reset function, to reset connection to initial state. (Issue #85)
- Make encrypted connections work with node v0.10. (Issue #86)
- Honour optional appName property in config.options. (Issue #91)
- Add support for using Real in parameterized statements.
- Correct value for Request's completion callback's rowCount argument for statements other than select.
v0.1.3 2013-02-17
- Support Text as a parameter type. (Zach Aller) (Issue #75)
- New example, showing insert statement using parameters of different types. (Will Munn) (Issue #72)
- Support for duplicate column names in result sets. (Nadeem) (Issue #70)
v0.1.2 2013-01-02
- Column not accessible by column name when the name is numeric. (Issue #66)
- Support for XML data type in result sets. (Issue #67)
v0.1.0 2012-11-25
- Support GUID, BigInt and Float as a parameter types. (Zach Aller)
- Support for windows936 encoding. (lastonesky)
- Same format for GUIDs in results and parameters. (Cort Fritz)
v0.0.7 2012-07-21
- Support for transactions.
- Experimental support for secure connections.
- Some support for TDS 7.1, for connecting to SQL Server 2000. (Phil Dodderidge)
v0.0.6 2012-05-27
- Remove post-install script hook. It won't run (as is) on Windows, and doesn't really add anything useful.
v0.0.5 2012-05-27
- Instead of publishing CoffeeScript files and compiling them at runtime, the CoffeeScript is compiled before publishing. Only Javascript files are pubslished and installed.
- Support for preparing and executing SQL.
-
When the value of
tinyint,smallintorintparameters are 0, do not send their value as null. (Issue #25) -
Support for
DATABASE_MIRRORING_PARTNERenvironment change notification. (Issue #22) -
Support for using
bit,smalldatetimeanddatetimetypes in parameterised statements. -
Support for using
varchar(max)andnvarchar(max)in parameterised statements. (Issue #32) - Use iconv-lite instead of iconv. This means that tedious is back to pure Javascript, including its dependencies.
v0.0.4 2012-04-15
-
On successful connection, set textsize (by default, to 2147483647).
This allows long values to be
returned for
varchar(max),nvarchar(max),varbinary(max),text,ntext, andimagedatatypes. -
Honour the defined locale for
char,varcharandtextdatatypes. iconv is used to perform the conversion, and is included as an optional dependency. If it is not available, then ascii is used as fallback when converting the buffers to strings. - Added support for executing parameterised statements. (Issue #14)
- Added support for calling procedures with parameters. (Issue #16)
- Support connecting by instance name (instead of port). (Issue #20)
- Expose the total number of rows returned, in Request's completion callback.
v0.0.3 2012-02-12
- Added support for Order tokens, meaning that select statements with an order clause can now be used.
-
Added support for more data types in result sets:
uniqueidentifier,text,ntext,image,smallmoney,money, - Fixed bug that prevented new Requests from being initiated from a Request's completion callback.
v0.0.2 2012-01-08
- 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
ReadableTrackingBufferandWritableTrackingBuffer, 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.
v0.0.1 2011-12-04
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.