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 :
- Added SQLITE_DBCONFIG_DQS_DML and SQLITE_DBCONFIG_DQS_DDL options to sqlite3_db_config() to control whether single and double quote processing is enabled. Initially, SQlite supported any kind of quotes for strings and identifiers, but the SQL standard explicitly requires the use of single quotes for string literals and double quotes for identifiers (such as column names). By default, the behavior of SQLite continues to be supported, and the "-DSQLITE_DQS=0" build option is proposed to enable compliance with the standard;
- Optimizations have been added to the query planner to speed up the operation of the AND and OR operators when one of the operands is a constant, as well as the LIKE operator when the column specified on the left is numeric;
- Added a new virtual table "sqlite_dbdata" to extract content at the level of the original column data, even if the database is corrupted;
- In CLI interface the β.recoverβ command, which tries to recover data from a damaged database as much as possible. Also added is a ".filectrl" command for running tests and a ".dbconfig" command for viewing or changing sqlite3_db_config() options.
Source: opennet.ru