All Versions
197
Latest Version
Avg Release Cycle
18 days
Latest Release
75 days ago
Changelog History
Page 1
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 ofknex
#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:
- ๐ Website URL changed to https://knex.github.io/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 withSELECT
; - ๐ 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