All Versions
202
Latest Version
Avg Release Cycle
25 days
Latest Release
97 days ago

Changelog History
Page 1

  • v2.3.0 Changes

    August 31, 2022

    ๐Ÿ†• New features:

    • ๐Ÿ‘ PostgreSQL: Explicit jsonb support for custom pg clients #5201
    • ๐Ÿ‘ SQLite: Support returning with sqlite3 and better-sqlite3 #5285
    • MSSQL: Implement mapBinding mssql dialect option #5292

    Typings:

    • โšก๏ธ Update types for TS 4.8 #5279
    • ๐Ÿ›  Fix typo #5267
    • ๐Ÿ›  Fix WhereJsonObject withCompositeTableType #5306
    • ๐Ÿ›  Fix AnalyticFunction type #5304
    • Infer specific column value type in aggregations #5297
  • v2.2.0 Changes

    July 19, 2022

    ๐Ÿ†• New features:

    • Inline primary key creation for postgres flavours #5233
    • โš  SQLite: Add warning for undefined connection file #5223
    • ๐Ÿ‘ MSSQL: Add JSON parameter support for connection #5200

    ๐Ÿ› Bug fixes:

    • PostgreSQL: add primaryKey option for uuid #5212

    Typings:

    • โž• Add promisable and better types #5222
    • โšก๏ธ Update raw query bind parameter type #5208
  • v2.1.0 Changes

    May 26, 2022

    ๐Ÿ†• New features:

    • ๐Ÿ‘Œ Improve bundling experience to safely import dialects while using static paths #5142
    • ๐Ÿ— Implement extendable builders #5041
    • PostgreSQL: Refresh materialized view concurrently #5166

    ๐Ÿ› Bug fixes:

    • ๐Ÿ“ฆ Use correct paths in package.json browser field #5174
    • MariaDB: Fix 'NULL' returned instead of NULL on MariaDB 10.2.6+ #5181
    • MySQL: fix hasColumn Error (hasColumn ('a_id') is true, but hasColumn('a_Id') is false) #5148
    • MSSQL: Fix .hasTable result when using .withSchema #5176
    • Oracle: correctly INSERTS Buffer #4869

    Typings:

    • โšก๏ธ Update type definitions for pg connection #5139
  • v2.0.0 Changes

    April 21, 2022

    ๐Ÿ’ฅ Breaking changes

    • ๐Ÿ“ฆ Restore sqlite3 package #5136

    โœ… Test / internal changes:

    • Migrate Husky from 4 to 7 #5137
    • Migrate Jake to 10.8.5 #5138
  • v1.0.7 Changes

    April 13, 2022

    ๐Ÿ› Bug fixes:

    • CLI: Fix cli migrate:make SQLite dependency #5106
  • v1.0.6 Changes

    March 12, 2022

    ๐Ÿ› Bug fixes:

    • PostgreSQL: Wait for search path to be set before returning connection #5107
    • CLI: No client override during migrate:make #5109
  • v1.0.5 Changes

    March 05, 2022

    ๐Ÿ†• New features:

    • Override knexfile options with CLI options #4047

    ๐Ÿ› Bug fixes:

    • โšก๏ธ Stringify json value in update #5063
    • ๐Ÿ›  Fix isModuleType() for yarn #4447
    • ๐Ÿ›  Wrapped Unions Fixes #5072
    • SQLite: Fix @vscode-sqlite3 error message #5081
    • CLI: Fix completed migration listing #5060

    Typings:

    • 0๏ธโƒฃ Make default generic parameters of Knex match the generic parameter types of knex #5021
    • โšก๏ธ Update knex types for TS 4.7 #5095
  • v1.0.4 Changes

    March 13, 2022

    ๐Ÿ†• New features:

    • โž• Add whereLike functions #5044

    ๐Ÿ› Bug fixes:

    • ๐Ÿ›  Fix orWhereJsonPath clause #5022
    • Subquery in on clause missing parenthesis #5049
    • Rework Union Wrapping #5030
    • 0๏ธโƒฃ Oracle: Fix batch inserts with DEFAULT values with OracleDB #2592 #5037

    Typings:

    • ๐Ÿ›  Fix types for "returning" methods #5031
    • createTableLike callback should be optional #5055

    ๐Ÿ“š Documentation:

  • v1.0.3 Changes

    February 11, 2022

    ๐Ÿ› Bug fixes:

    • ๐Ÿ›  Fix error message for missing migration files #4937
    • โž• Add withMaterialized and withNotMaterialized to method-constants #5009
    • PostgreSQL: Fix whereJsonPath queries #5011
    • PostgreSQL: Fix delete joins #5016
    • CockroachDB: Fix whereJsonPath queries #5011
    • MySQL: Create primary keys in same statement #5017

    Typings:

    • ๐Ÿ›  Fix type definition for getMigration in MigrationSource #4998
    • ๐Ÿ›  Fix argument type of alter method #4996

    ๐Ÿ‘Œ Improvements:

    • ๐Ÿ‘€ Use async / await syntax in seeds as default #5005

    ๐Ÿ“š Documentation:

    • โž• Add Firebird dialect to ECOSYSTEM.md #5003
  • v1.0.2 Changes

    February 02, 2022

    ๐Ÿ†• New features:

    • ๐Ÿ‘Œ Support of MATERIALIZED and NOT MATERIALIZED with WITH/CTE #4940
    • โž• Add raw support in onConflict clause #4960
    • Alter nullable constraint when alterNullable is set to true #4730
    • โž• Add alterType parameter for alter function #4967
    • ๐Ÿ‘Œ Support string json in json values #4988
    • MySQL: add with clause #4508

    ๐Ÿ› Bug fixes:

    • ๐Ÿ›  Fix error message for missing migration files #4937
    • โšก๏ธ Move deferrable to after on update/on delete #4976
    • Do not use sys.tables to find if a table exists #2328
    • PostgreSQL: Fix Order nulls #4989
    • MySQL: Fix collation when renaming column #2666
    • ๐Ÿ‘ SQLite: Same boolean handling in better-sqlite3 as in sqlite3 #4982

    Typings:

    • WhereILike - fix typo #4941