All Versions
187
Latest Version
Avg Release Cycle
16 days
Latest Release
40 days ago

Changelog History
Page 1

  • v0.95.12 Changes

    October 28, 2021

    ๐Ÿ†• New features:

    • ๐Ÿ†• New dialect: CockroachDB #4742
    • ๐Ÿ†• New dialect: pg-native #4327
    • ๐Ÿ‘ CockroachDB: add support for upsert #4767
    • โšก๏ธ PostgreSQL: Support SELECT .. FOR NO KEY UPDATE / KEY SHARE row level locking clauses #4755
    • ๐Ÿ‘ PostgreSQL: Add support for 'CASCADE' in PostgreSQL 'DROP SCHEMA' queries #4713
    • ๐Ÿ‘ MySQL: Add storage engine index Type support to index() and unique() schema #4756
    • ๐Ÿ‘ MSSQL: Support table.primary, table.unique variant with options object #4710
    • ๐Ÿ‘ SQLite: Add setNullable support to SQLite #4684
    • โž• Add geometry column building #4776
    • โž• Add support for creating table copies #1373
    • ๐Ÿ‘ Implement support for views and materialized views #1626
    • ๐Ÿ‘ Implement partial index support #4768
    • ๐Ÿ‘Œ Support for 'is null' in 'order by' #3667

    ๐Ÿ› Bug fixes:

    • ๐Ÿ›  Fix support for Oracle connections passed via knex.connection() #4757
    • ๐Ÿ”’ Avoid inserting multiple locks if a migration lock already exists #4694

    Typings:

    • Some TableBuilder methods return wrong types #4764
    • โšก๏ธ Update JoinRaw bindings type to accept arrays #4752
    • ๐Ÿ›  fix onDelete/onUpdate for ColumnBuilder #4656
  • v0.95.11 Changes

    September 03, 2021

    ๐Ÿ†• New features:

    • โž• Add support for nullability modification via schema builder (table.setNullable() and table.dropNullable()) #4657
    • ๐Ÿ‘ MySQL: Add support for mysql/mariadb-client JSON parameters in connectionURIs #4629
    • ๐Ÿ‘ MSSQL: Support comments as MS_Description properties #4632

    ๐Ÿ› Bug fixes:

    • ๐Ÿ›  Fix Analytic orderBy and partitionBy to follow the SQL documentation #4602
    • CLI: fix migrate:up for migrations disabling transactions #4550
    • SQLite: Fix adding a column with a foreign key constraint in SQLite #4649
    • ๐Ÿ‘ MSSQL: columnInfo() support case-sensitive database collations #4633
    • MSSQL: Generate valid SQL for withRecursive() #4514
    • Oracle: withRecursive: omit invalid RECURSIVE keyword, include column list #4514

    ๐Ÿ‘Œ Improvements:

    • โž• Add .mjs migration and seed stubs #4631
    • ๐Ÿšš SQLite: Clean up DDL handling and move all operations to the parser-based approach #4648
  • v0.95.10 Changes

    August 20, 2021

    ๐Ÿ‘Œ Improvements:

    • ๐Ÿ‘‰ Use sys info function instead of connection db name #4623

    Typings:

    • Deferrable and withkeyName should not be in ColumnBuilder #4600
  • v0.95.9 Changes

    July 31, 2021

    ๐Ÿ†• New features:

    • ๐Ÿ‘ Oracle: support specifying schema for dropTable and dropSequence #4596
    • ๐Ÿ‘ Oracle: support specifying schema for autoincrement #4594

    Typings:

    • โž• Add TypeScript support for deferrable, new Primary/Unique syntax #4589
  • v0.95.8 Changes

    July 25, 2021

    ๐Ÿ†• New features:

    • โž• Add deferrable support for constraint #4584
    • Implement delete with join #4568
    • โž• Add DPI error codes for Oracle #4536

    ๐Ÿ› Bug fixes:

    • ๐Ÿ›  Fixing PostgreSQL datetime and timestamp column created with wrong format #4578

    Typings:

    • ๐Ÿ‘Œ Improve analytic types #4576
    • MSSQL: Add trustServerCertificate option #4500
  • v0.95.7 Changes

    July 10, 2021

    ๐Ÿ†• New features:

    • โž• Add ability to omit columns on an onConflict().ignore() #4557
    • ๐ŸŒฒ CLI: Log error message #4534

    Typings:

    • Export Knex.TransactionConfig #4498
    • Include options object in count(Distinct) typings #4491
    • โž• Add types for analytic functions #4544
  • v0.95.6 Changes

    May 17, 2021

    Typings:

    • Export TransactionProvider type #4489
  • v0.95.5 Changes

    May 11, 2021

    ๐Ÿ†• New features:

    • ๐Ÿ‘ SQLite: Add support for file open flags #4446
    • โž• Add .cjs extension to Seeder.js to support Node ESM #4381 #4382

    ๐Ÿ› Bug fixes:

    • โœ‚ Remove peerDependencies to avoid auto-install on npm 7 #4480

    Typings:

    • ๐Ÿ›  Fix typing for increments and bigIncrements #4406
    • โž• Add typings for on JoinClause for onVal #4436
    • โž• Adding Type Definition for isTransaction #4418
    • Export client class from knex namespace #4479
  • v0.95.4 Changes

    March 26, 2021

    Typings:

    • ๐Ÿ›  Fix mistyping of stream #4400
  • v0.95.3 Changes

    March 25, 2021

    ๐Ÿ†• New features:

    • PostgreSQL: Add "same" as operator #4372
    • MSSQL: Improve an estimate of the max comment length #4362
    • Throw an error if negative offset is provided #4361

    ๐Ÿ› Bug fixes:

    • ๐Ÿ›  Fix timeout method #4324
    • SQLite: prevent dropForeign from being silently ignored #4376

    Typings:

    • ๐Ÿ‘ Allow config.client to be non-client instance #4367
    • โž• Add dropForeign arg type for single column #4363
    • โšก๏ธ Update typings for TypePreservingAggregation and stream #4377