published release sqlite 3.41 , lightweight DBMS , designed 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 SQLite developers is carried out by a specially created consortium, which includes companies such as Adobe, Oracle, Mozilla, Bentley and Bloomberg.
The main
- Optimizes are made to the scheduler requests that have touched aggregated requests with the Group by expression, the use of indexes, the use of counter instead of materialization Subscribers and representations, functions json_tree () and json_each ().
- added expansion with the functions of Base64 and Base85, which are now also available in the command line (CLI).
- The command “. Scansstats est” to evaluate the effectiveness of the request planner.
- In CLI, a change in the input invitation is ensured that the input position is inside the string literal, commentary, identifier or determination of the trigger.
- When specifying the command line “-Safe” an expanded list of disconnected dangerous SQL functions.
- By default, I disconnected mode , allowing string literals by double quotation.
- In the team pragma integry_check determining the coincidence of text lines in the table when using different orders of the venues in the index.
- In the Parser, ignoring excess round brackets around the sub -check, set on the right side of the operator in, which corresponds to postgreSQL behavior (previously SQLite processed similar sub -clamps as an expression that falls under the limit of “Limit 1”).
/Media reports cited above.