Knex v0.95.12 Release Notes

Release Date: 2021-10-28 // over 2 years ago
  • ๐Ÿ†• 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