published release sqlite 3.42 , lightweight DBMS, decorated in the form of a connected library. The SQLite code is distributed as a public domain, i.e. It can be used without restrictions and free of charge for any purpose. The financial support of the developers of SQLite is carried out by a specially created consortium, which includes companies such as Adobe, Oracle, Mozilla, Bentley and Bloomberg.
The main changes :
- For full-text FTS5 indexes, the command secure-delete , which produces the full cleaning of all the removing data. /li>
- in functions for data processing in json format, support for extensions json5 .
- Improved request planner. By default, optimization is enabled
“Count-OF-View”. The processing of unused columns in subordination is excluded. Improved implementation of optimization push-down . - The option “–unsafe-testing” is added to the command line interface, which allows the use of some hazardous commands, such as “.Testctrl”, designed to use in testing. In safe mode (“—safe”) the use of commands “.log on” and “.log off” is allowed. Added support for the separator “-“, for arguments after which the processing of the options is disconnected. Added parameters “: INF” and “: NAN” related to the values of infinity and nan.
- In the names determined on the side of the application SQL functions permitted with keywords of CROSS, Full, Inner, LEFT, Natural, OUTER and right.
- The capabilities of Pragma integry_check . Added verification of the indication of the NAN value in column with the condition of NOT NULL. Information of error messages has been improved.
- In addition session the interception of changes from tables without Rowid.
- In the function for working with time and dates the modifier “ subsec ” for using a fraction of seconds.
- The depth of recursion for arrays and JSON objects is reduced by default from 2000 to 1000.
In addition, formed the release of DBMS Duckdb 0.8.0
/Reports, release notes, official announcements.