Software update: SQLite 3.30

SQLite is a database system developed in C that can be used for websites and embedded applications, among other things. According to the developers, SQLite requires no installation and administration, supports databases up to two terabytes in size and stores an entire database in one file. Furthermore, it supports almost the full SQL92 specification and it is easy via, among others Tcl/Tk to guide. Version 3.30.0 has been released and since version 3.28.0 the following changes have been made:

SQLite Release 3.30.0

• Add support for the FILTER clause on aggregate functions.
• Add support for the NULLS FIRST and NULLS LAST syntax in ORDER BY clauses.
• the index_info and index_xinfo pragmas are enhanced to provide information about the on-disk representation of WITHOUT ROWID table.
• Add the sqlite3_drop_modules() interface, allowing applications to disable automatically loaded virtual tables that they do not need.
• Improvements to the .recover dot command in the CLIA so that it recovers more content from corrupt database files.
• Enhance the RBU extension to support indexes on expressions.
• Change the schema parser so that it will error out if any of the type, name, and tbl_name columns of the sqlite_master table have been corrupted and the database connection is not in writable_schema fashion.
• the PRAGMA function_list, PRAGMA module_listand PRAGMA pragma_list commands are now enabled in all builds by default. Disable them using -DSQLITE_OMIT_INTROSPECTION_PRAGMAS.
• Add the SQLITE_DBCONFIG_ENABLE_VIEW option for sqlite3_db_config().
• Added the TCL Interface config method in order to be able to disable SQLITE_DBCONFIG_ENABLE_VIEW as well as control other sqlite3_db_config() options from TCL.
• Added the SQLITE_DIRECTONLY flag for application-defined SQL functions to prevent those functions from being used inside triggers and views.
• The legacy SQLITE_ENABLE_STAT3 compile-time option is now a no-op.

SQLite Release 3.29.0

• Added the SQLITE_DBCONFIG_DQS_DML and SQLITE_DBCONFIG_DQS_DDL actions to sqlite3_db_config() for activating and deactivating the double quoted string literal misfeature. Both default to “on” for legacy compatibility, but developers are encouraged to turn them “off”, perhaps using the -DSQLITE_DQS=0 compile time option.
• -DSQLITE_DQS=0 is now a recommended compile time option.
• Improvements to the query scheduler:
• Improved optimization of AND and OR operators when one or the other operand is a constant.
• Enhancements to the LIKE optimization for cases when the left-hand side column has numeric affinity.

• Add the “sqlite_dbdata” virtual table for extracting raw low-level content from an SQLite database, even a database that is corrupt.
• Enhancements to the CLIA:
• Add the “.recover” command which tries to recover as much content as possible from a corrupt database file.
• Add the “.filectrl” command useful for testing.
• Add the long-standing “.testctrl” command to the “.help” menu.
• Added the “.dbconfig” command