Dropped indexes feature now functions correctly, (#278)
0.5.14 - May 6, 2014
Remove the charset encoding if it's utf8 for mysql, as it's the default but also currently causes some issues in recent versions of node-mysql
0.5.13 - April 2, 2014
Fix regression in array bindings for postgresql (#228)
0.5.12 - Mar 31, 2014
Add more operators for where clauses, including && (#226)
0.5.11 - Mar 25, 2014
.where(col, 'is', null) or .where(col, 'is not', null) are not supported (#221).
Case insensitive where operators now allowed (#212).
Fix bug in increment/decrement truncating to an integer (#210).
Disconnected connections are now properly handled & removed from the pool (#206).
Internal tweaks to binding concatenations for performance (#207)
0.5.10 - Mar 19, 2014
Add the .exec method to the internal promise shim
0.5.9 - Mar 18, 2014
Remove error'ed connections from the connection pool (#206), added support for node-postgres-pure (pg.js) (#200)
0.5.8 - Feb 27, 2014
Fix for chaining on forUpdate / forShare, adding map & reduce from bluebird
0.5.7 - Feb 18, 2014
Fix for a null limit / offset breaking query chain (#182)
0.5.6 - Feb 5, 2014
Bump bluebird dependency to ~1.0.0, fixing regression in Bluebird 1.0.2 (#176)
0.5.5 - Jan 28, 2014
Fix for the exit code on the migrations cli (#151).
The init method in knex.migrate now uses this.config if one isn't passed in (#156)
0.5.4 - Jan 7, 2014
Fix for using raw statements in defaultTo schema builder methods (#146)
0.5.3 - Jan 2, 2014
Fix for incorrectly formed sql when aggregates are used with columns (#144)
0.5.2 - Dec 18, 2013
Adding passthrough "catch", "finally" to bluebird implementations, use bluebird's "nodeify" internally for exec
0.5.1 - Dec 12, 2013
The returning in PostgreSQL may now accept * or an array of columns to return. If either of these are passed, the response will be an array of objects rather than an array of values. Updates may also now use a returning value. (#132)
Added bigint and bigserial type to PostgreSQL. (#111)
Several fixes for migrations, including migration file path fixes, passing a Promise constructor to the migration up and down methods, allowing the "knex" module to be used globally, file ordering on migrations, and other small improvements. (#112-115, #125, #135)
Fix bug where current query chain type is not copied on clone. (#90)
Charset and collate are now added as methods on the schema builder. (#89)
Added into as an alias of from, for builder syntax of: insert(value).into(tableName)
Internal pool fixes. (#90)
0.4.9 - Oct 7, 2013
Fix for documentation of hasColumn, ensure that hasColumn works with MySQL (#87).
More cleanup of error messages, showing the original error message concatenated with the sql and bindings
0.4.8 - Oct 2, 2013
Connections are no longer pushed back into the pool if they never existed to begin with (#85)
0.4.7 - Sep 27, 2013
The column is now a documented method on the builder api, and takes either an individual column or an array of columns to select
0.4.6 - Sep 25, 2013
Standardizing handling of errors for easier debugging, as noted in (#39)
0.4.5 - Sep 24, 2013
Fix for hasTable always returning true in MySQL (#82), fix where sql queries were duplicated with multiple calls on toSql with the schema builder
0.4.4 - Sep 22, 2013
Fix for debug method not properly debugging individual queries
0.4.3 - Sep 18, 2013
Fix for underscore not being defined in various grammar files
0.4.2 - Sep 17, 2013
Fix for an error being thrown when an initialized ClientBase instance was passed into Knex.initialize. pool.destroy now optionally accepts a callback to notify when it has completed draining and destroying all connections
0.4.1 - Sep 16, 2013
Cleanup from the 0.4.0 release, fix a potential exploit in "where" clauses pointed out by Andri Möll, fix for clients not being properly released from the pool #70, fix for where("foo", "<>", null) doing an "IS NULL" statement
0.4.0 - Sep 13, 2013
Global state is no longer stored in the library, an instance is returned from Knex.initialize, so you will need to call this once and then reference this knex client elsewhere in your application.
Lowercasing of knex.raw, knex.transaction, and knex.schema.
Created columns are now nullable by default, unless notNullable is chained as an option.
Keys created with increments are now assumed to be unsigned (MySQL) by default.
The destroyAllNow is no longer called by the library on process.exit event. If you need to call it explicitly yourself, you may use knex.client.destroyPool
0.2.6 - Aug 29, 2013
Reject the transaction promise if the transaction "commit" fails, (#50)
0.2.5 - Aug 25, 2013
Fix error if a callback isn't specified for exec, (#49)
0.2.4 - Aug 22, 2013
Fix SQLite3 delete not returning affected row count, (#45)
0.2.3 - Aug 22, 2013
Fix insert with default values in PostgreSQL and SQLite3, (#44)
0.2.2 - Aug 20, 2013
Allowing Raw queries to be passed as the primary table names
0.2.1 - Aug 13, 2013
Fix for an array passed to insert being mutated
0.2.0 - Aug 7, 2013
hasTable now returns a boolean rather than a failed promise.
Changed syntax for insert in postgresql, where the id is not assumed on inserts (#18). The second parameter of insert is now required to return an array of insert id's for the last insert.
The timestamp method on the schema builder now uses a dateTime rather than a timestamp
0.1.8 - July 7, 2013
Somehow missing the != operator. Using _.find rather than _.where in getCommandsByName(#22)
0.1.7 - June 12, 2013
Ensures unhandled errors in the exec callback interface are re-thrown
0.1.6 - June 9, 2013
Renaming beforeCreate to afterCreate. Better handling of errors in the connection pooling
0.1.5 - June 9, 2013
Added the ability to specify beforeCreate and beforeDestroy hooks on the initialize's options.pool to perform any necessary database setup/teardown on connections before use (#14). where and having may now accept Knex.Raw instances, for consistency (#15). Added an orHaving method to the builder. The ability to specify bindings on Raw queries has been removed
0.1.4 - May 22, 2013
defaultTo now accepts "false" for boolean columns, allows for empty strings as default values
0.1.3 - May 18, 2013
Enabling table aliases (#11). Fix for issues with transactions not functioning (#12)
0.1.2 - May 15, 2013
Bug fixes for groupBy (#7). Mysql using collation, charset config settings in createTable. Added engine on schemaBuilder specifier (#6). Other doc fixes, tests
0.1.1 - May 14, 2013
Bug fixes for sub-queries, minor changes to initializing "main" instance, adding "pg" as a valid parameter for the client name in the connection settings