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 ability to use the expression "" with aggregate functions has been added, allowing you to limit the scope of the data processed by the aggregate function to only those records that meet a specified condition;
- Support for the flags "" and "" has been ensured in the "ORDER BY" clause to determine the positioning of elements with NULL values during sorting;
- A command "" has been added to the command-line interface for recovering the contents of corrupted database files;
- In the extension support added ;
- PRAGMA index_info and PRAGMA index_xinfo have been expanded to provide information about the layout of tables created in "WITHOUT ROWID" mode;
- Added API , allowing the application to prohibit the automatic loading of virtual tables;
- The database schema parser has been modified to output an error when the type, name, and columns of tbl_name in the sqlite_master table are corrupted while connected not in writable_schema mode;
- By default, the commands PRAGMA function_list, PRAGMA module_list, and PRAGMA pragma_list are activated. To change the default behavior during build, you must explicitly specify "-DSQLITE_OMIT_INTROSPECTION_PRAGMAS";
- For user-defined SQL functions, the flag SQLITE_DIRECTONLY has been proposed, which prohibits the use of these functions within triggers and views.
Source: opennet.ru
