SQLite 3.30.0 has been released. SQLite is a compact embedded database management system. The source code of the library has been released into the public domain.
What's new in version 3.30.0:
- the ability to use the "FILTER" expression with aggregate functions has been added, allowing the function to restrict the data it processes to only those records that meet specified conditions;
- the "ORDER BY" clause now supports the "NULLS FIRST" and "NULLS LAST" flags to determine the placement of NULL values during sorting;
- a new command ".recover" has been introduced for recovering content from corrupted database files;
- PRAGMA index_info and PRAGMA index_xinfo have been expanded to provide information about the storage layout of tables created in "WITHOUT ROWID" mode;
- an API sqlite3_drop_modules() has been added to permit the disabling of automatic loading of virtual tables;
- commands PRAGMA function_list, PRAGMA module_list, and PRAGMA pragma_list are now enabled by default;
- the SQLITE_DIRECTONLY flag has been introduced to prohibit the use of SQL functions within triggers and views;
- the deprecated option SQLITE_ENABLE_STAT3 is no longer available.
Source: linux.org.ru
