All Versions
197
Latest Version
Avg Release Cycle
18 days
Latest Release
75 days ago

Changelog History
Page 1

  • 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
  • v1.0.1 Changes

    January 16, 2022

    ๐Ÿ› Bug fixes:

    • ๐Ÿ›  Fix package.json metadata
  • v1.0.0 Changes

    January 16, 2022

    ๐Ÿ’ฅ Breaking changes

    • โฌ‡๏ธ Dropped support for Node 10;
    • ๐Ÿ‘ Replaced unsupported sqlite3 driver with @vscode/sqlite3;
    • ๐Ÿ”„ Changed data structure from RETURNING operation to be consistent with SELECT;
    • ๐Ÿ”„ Changed Migrator to return list of migrations as objects consistently.

    ๐Ÿ†• New features:

    • ๐Ÿ‘Œ Support fromRaw #4781
    • ๐Ÿ‘Œ Support zero precision in timestamp/datetime #4784
    • ๐Ÿ‘Œ Support whereLike and whereILike #4779
    • โž• Add JSDoc (TS flavor) to stub files #4809
    • ๐Ÿ‘ Allow skip binding in limit and offset #4811
    • ๐Ÿ‘Œ Support creating a new table in the database based on another table #4821
    • Accept Raw on onIn joins #4830
    • ๐Ÿ‘€ Implement support for custom seed sources #4842
    • โž• Add binary uuid option #4836
    • โšก๏ธ ForUpdate array parameter #4882
    • โž• Add camel case to timestamps method #4803
    • ๐Ÿ‘ Advanced JSON support #4859
    • โž• Add type to TypeScript knexfile #4909
    • ๐Ÿ‘ Checks Constraints Support #4874
    • ๐Ÿ‘Œ Support creating multiple PKs with increments #4903
    • Enable wrapIdentifier for SQLite .hasTable #4915
    • ๐Ÿ‘ MSSQL: Add support for unique constraint #4887
    • ๐Ÿ‘ SQLite: New dialect, using better-sqlite3 driver #4871
    • SQLite: Switch to @vscode/sqlite3 #4866
    • ๐Ÿ‘ SQLite: Support createViewOrReplace #4856
    • ๐Ÿ‘ SQLite: Support RETURNING statements for better-sqlite3 driver #4934
    • ๐Ÿ‘ PostgreSQL: Support JOIN and USING syntax for Delete Statement #4800

    ๐Ÿ› Bug fixes:

    • ๐Ÿ›  Fix overzealous warning on use of whereNot with "in" or "between" #4780
    • ๐Ÿ›  Fix Union all + first syntax error #4799
    • ๐Ÿ‘‰ Make view columns optional in create view like #4829
    • ๐Ÿ”’ Insert lock row fix during migration #4865
    • ๐Ÿ›  Fix for createViewOrReplace #4856
    • SQLite: Fix foreign key constraints when altering a table #4189
    • MySQL: Validate connection fix #4794
    • โš  MySQL: Set comment size warning limit to 1024 #4867

    Typings:

    • ๐Ÿ‘ Allow string indexType in index creation #4791
    • โž• Add missing ints typings #4832
    • Returning method types #4881
    • ๐Ÿ‘Œ Improve columnInfo type #4868
  • v0.95.15 Changes

    December 22, 2021

    ๐Ÿ› Bug fixes:

    • Oracle:
    • ๐Ÿ”’ MariaDB: lock row fix during migration in MariaDB and Oracle #4865
  • v0.95.14 Changes

    November 09, 2021

    ๐Ÿ› Bug fixes:

    • MySQL: mysql2 dialect validate connection fix #4794
  • v0.95.13 Changes

    November 02, 2021

    ๐Ÿ› Bug fixes:

    • ๐Ÿ‘ PostgreSQL: Support zero precision in timestamp/datetime #4784

    Typings:

    • ๐Ÿ‘ Allow string indexType in index creation #4791