Release , a lightweight DBMS packaged as a plug-in library. The SQLite code is distributed in the public domain, i.e. can be used without restrictions and free of charge for any purpose. Financial support for SQLite developers is provided by a specially created consortium, which includes companies such as Adobe, Oracle, Mozilla, Bentley and Bloomberg.
All :
- Expression implemented to update the contents of a table based on a selection from another table. The expression uses PostgreSQL-compliant syntax.
- The maximum database size has been increased to 281 TB.
- Π the ability to selectively check only a certain table and its associated indexes is provided (previously, the entire database was always checked).
- Added extension with decimal arithmetic functions with arbitrary precision.
- In extension improvements have been made to support binary64 numbers.
- To the command line interface (CLI) new output formatting modes "box", "json", "markdown" and "table". In the "column" output mode, columns are automatically expanded according to the contents of the longest line. In the "quote" output mode, the value of the separator set by the ".separator" command is taken into account.
- The decimal and ieee754 extensions are built into the CLI.
- Improvements have been made to the query planner. Improved performance of "SELECT min(x) FROM t WHERE y IN (?,?,?)" queries with index t(x,y). Implemented detection of the possibility of using the full-index-scan query plan for queries with the "INDEXED BY" clause.
- In the mode (Write-Ahead Logging) If a write operation fails causing a data inconsistency in the shm file, the following transactions can now restore the integrity of the shm file if there are active read transactions instead of throwing a SQLITE_PROTOCOL error.
Source: opennet.ru