knex - npm Package Versions

0.20.3 - 27 November, 2019

New features:

• MSSQL, MySQL: Add connection string qs to connection params #3547

Bug fixes:

• Oracle: Fix issue retrieving BLOB from database #3545
• PostgreSQL: Timeout for postgresql use cancel instead of terminate #3518
• Make sure CLI works for namespaced knex packages #2539

Typings:

• Lift up dialect specific methods in the CreateTableBuilder #3532
• Add client property to QueryBuilder type #3541
• Support 'only' option #3551

0.20.2 - 14 November, 2019

New features:

• Add support for distinct on for postgres #3513

Bug fixes:

• Make sqlite3 hasColumn case insensitive #3435

Typings:

• Fix PoolConfig typing #3505
• Expand SeedsConfig types #3531
• Make the default type parameters of QueryBuilder less strict #3520
• Fix regression in older version of node when Promise#finally was not available #3507

0.20.1 - 29 October, 2019

New features:

• Declare drivers as optional peerDependencies #3081
• Dynamic connection configuration resolution #3497

Bug fixes:

• Wrap subQuery with parenthesis when it appears as table name #3496
• Fix Oracle error codes #3498

Typings:

• Add interface for PG Connection object #3372
• Gracefully handle global promise pollution #3502

0.20.0 - 25 October, 2019

New features:

• orderBy accepts QueryBuilder #3491
• Add validation in .offset() #2908
• disable_migrations_list_validation feature #3448

Bug fixes:

• Fix oracledb driver v4 support #3480
• Fix some issues around seed and migration generation #3479
• Fix bugs in replacement logic used when dropping columns in SQLite #3476

Typings:

• Add types to the Migrator interface #3459
• Fix typings of index and dropIndex TableBuilder methods #3486
• Fixes types for Seeder#run #3438

Test / internal changes:

• Execute CI on Node.js 13
• Bluebird: remove usage of return, reflect, fromCallback methods #3483
• Bluebird: remove Bluebird.bind #3477
• Bluebird: use util.promisify instead of Bluebird.promisify #3470
• Bluebird: remove Bluebird.each #3471
• Bluebird: remove Bluebird.map and Bluebird.mapSeries #3474
• Bluebird: replace Bluebird.map with Promise.all #3469
• Update badges #3482

0.19.5 - 06 October, 2019

New features:

• CLI: Migrations up/down commands - filename parameter #3416
• Oracle: Support stored procedures #3449

Bug fixes:

• MSSQL: Escape column ids correctly in all cases (reported by Snyk Security Research Team) #3382
• SQLite: Fix handling of multiline SQL in SQLite3 schema #3411
• Fix concurrent child transactions failing #2213 #3440

Typings:

• Add missing Migrator.list typing #3460
• Fix Typescript type inference for to better support wildcard (*) calls #3444
• Make options argument optional in timeout #3442

Test / internal changes:

• Enable linting in CI #3450

0.19.4 - 09 September, 2019

New features:

• Add undefined columns to undefined binding(s) error #3425

Typings:

• Add specific to SeederConfig type #3429
• Fix some issues with QueryBuilder types #3427

0.19.3 - 25 August, 2019

Bug fixes:

• Fix migrations for native enums to use table schema #3307

New features:

• Add ability to manually define schema for native enums #3307
• Add SSL/TLS support for Postgres connection string #3410
• CLI: new command that lists all migrations with status #3390

Typings:

• Include schemaName in EnumOptions #3415
• Allow ColumnBuilder.defaultTo() to be null #3407

Changes:

• migrate: Refactor _lockMigrations to avoid forUpdate - makes migrations compatible with CockroachDB #3395

0.19.2 - 17 August, 2019

Changes:

• Make transaction rejection consistent across dialects #3399
• More consistent handling of nested transactions #3393

New features:

• Fallback to JSON when using JSONB in MySQL #3394

0.19.1 - 23 July, 2019

New features:

• Allow to extend knex query builder #3334
• Add .isCompleted() to transaction #3368
• Minor enhancements around aliasing of aggregates #3354

Typings:

• Update configuration typings to allow for oracle db connectionstring #3361
• Update Knex.raw type to be any by default because the actual type is dialect specific #3349

0.19.0 - 11 July, 2019

Changes:

• Pooling: tarn.js connection pool was updated to version 2.0.0. This fixes issue with destroying connections and introduces support for connection pool event handlers. Please see tarn.js documentation for more details #3345
• Pooling: Passing unsupported pooling configuration options now throws an error
• Pooling: beforeDestroy configuration option was removed