release , a lightweight DBMS designed as a plug-in library. The SQLite code is released into the public domain, meaning it can be used without restrictions and free of charge for any purpose. Financial support for SQLite developers comes from a consortium that includes companies such as Adobe, Oracle, Mozilla, Bentley, and Bloomberg.
Key :
- Implemented expression to update the contents of a table based on a selection from another table. The syntax used in the expression is consistent with PostgreSQL.
- The maximum size of the database has been increased to 281 TB.
- In has made it possible to selectively check only a specific table and its associated indexes (previously, the entire database was always checked).
- with an implementation of sorting sequences that accounts for integers in the text to sort that text in numerical order. with arbitrary precision decimal arithmetic functions.
- In the extension improvements have been made for supporting binary64 numbers.
- In the command line interface (CLI) new output formatting modes 'box', 'json', 'markdown', and 'table'. In the 'column' output mode, automatic column expansion is provided based on the content of the longest string. In the 'quote' output mode, the value of the separator set by the command '.separator' is taken into account.
- The CLI has built-in decimal and ieee754 extensions.
- Improvements have been made to the query planner. Performance has been enhanced for the queries 'SELECT min(x) FROM t WHERE y IN (?,?,?)' when an index on t(x,y) is present. The capability of using the full-index-scan query plan has been implemented for queries with the 'INDEXED BY' expression.
- In strict tracking protection mode (Write-Ahead Logging) in case of a write operation failure leading to data consistency issues in the shm file, subsequent transactions can now restore the integrity of the shm file in the presence of active read transactions, instead of throwing a SQLITE_PROTOCOL error.
Source: opennet.ru
