SQLite 3.41 has been released, a lightweight DBMS provided as a shared library. The SQLite code is released into the public domain, meaning it can be used freely for any purpose without restrictions. Financial support for SQLite developers is provided by a specially formed consortium including companies such as Adobe, Oracle, Mozilla, Bentley, and Bloomberg.
Key Changes:
- Optimizations have been made to the query planner affecting aggregated queries with GROUP BY expressions, index usage, using coroutines instead of materializing subqueries and views, as well as the json_tree() and json_each() functions.
- An extension with base64 and base85 functions has been added, which are now also available in the command-line interface (CLI).
- The CLI has added the command '.scanstats est' for assessing the performance of the query planner.
- The CLI allows for the input prompt to change to indicate that the input position is within a string literal, comment, identifier, or trigger definition.
- When using the command-line option '--safe', the list of dangerous SQL functions that are disabled has been expanded.
- By default, the mode allowing string literals to be enclosed in double quotes is disabled.
- In the PRAGMA integrity_check command, text string matching in the table has been defined when using different byte orderings in the index.
- The parser has been implemented to ignore unnecessary parentheses around subqueries specified on the right side of the IN operator, matching PostgreSQL behavior (previously, SQLite treated such subqueries as expressions subject to the 'LIMIT 1' constraint).
Source: opennet.ru
