Knex v0.95.11 Release Notes

Release Date: 2021-09-03 // about 2 months ago
  • ๐Ÿ†• 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

Previous changes from v0.95.10

  • ๐Ÿ‘Œ Improvements:

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

    Typings:

    • Deferrable and withkeyName should not be in ColumnBuilder #4600