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 :
- The options SQLITE_DBCONFIG_DQS_DML and SQLITE_DBCONFIG_DQS_DDL have been added to sqlite3_db_config() to manage the handling of single and double quotes. SQLite originally supported any quotation marks for strings and identifiers, but the SQL standard explicitly requires the use of single quotes for string literals and double quotes for identifiers (e.g., column names). By default, SQLite's behavior continues, and the compilation option '-DSQLITE_DQS=0' is proposed to enable compliance with the standard;
- The query planner has been optimized to enhance the performance of AND and OR operators when one of the operands is a constant, as well as the LIKE operator when the specified left column is numeric;
- A new virtual table 'sqlite_dbdata' has been added for retrieving content at the raw data level of columns, even if the database is corrupted;
- In the CLI interface , the '.recover' command attempts to recover data from a corrupted database as much as possible. Additionally, the '.filectrl' command has been added for conducting tests and the '.dbconfig' command for viewing or modifying options in sqlite3_db_config().
Source: opennet.ru
