After a month of development, the compact embedded DBMS version 3.48.0 was released SQLite, written in C and distributed in the public domain.
List of changes:
- Reworked the configure script used to build SQLite from source to fix bugs, improve performance, and improve maintainability.
- This does not affect the configure script in the sqlite3-autoconf-NNNNNNN.tar.gz archive, for which the build system has not changed.
- The key change is that GNU Autoconf is now used instead of Autosetup.
- One benefit of the new config is that TCL is no longer required to be installed to build most SQLite build targets. TCL is still required to run tests or to build helper programs (such as sqlite3_analyzer) that use TCL, but most normal build targets do not require TCL. So, starting with this release, the only build dependencies are a C compiler and make or nmake.
- Improved EXPLAIN QUERY PLAN command for indexes.
- The SQL function iif() now supports two parameters. Also added is the if() function as an alternative to iif().
- The .dbtotxt command has been added to the sqlite3 console utility.
- Added SQLITE_IOCAP_SUBPAGE_READ property to xDeviceCharacteristics method of sqlite3_io_methods object.
- Added SQLITE_PREPARE_DONT_LOG option to sqlite3_prepare_v3() to prevent warnings from being sent to the error log if the SQL text is malformed. This allows sqlite3_prepare_v3() to be used to test compile SQL text to check its correctness without cluttering the error log with spurious messages.
- Increased the minimum allowed value of the SQLITE_LIMIT_LENGTH parameter from 1 to 30.
- Added opcode SQLITE_FCNTL_NULL_IO, which sets the low-level file descriptor or file handle for a sqlite3_file object so that it will no longer read from or write to the database file.
- The FTS5 xInstToken() helper API has been extended to handle prefix queries using the insttoken configuration option and the fts5_insttoken() SQL function.
- The maximum number of arguments for SQL functions has been increased from 127 to 1000.
- Removed residual traces of SQLITE_USER_AUTHENTICATION.
- Bugs fixed.
Source: linux.org.ru
