SQLite 3.17.0 Release has been announced is now available for download for free. This version comes with several improvements and bug fixes and therefore makes a great candidate for upgrading.
SQLite is a cross platform and open source database library written in C. The library is designed to be self sufficient. This means is does not require a A server is a computer application program that responds to requests for information from a client in a client/server relationship system. A typical example is a web server or pushing a web page to a web browser or a web server receiving email and transferring it to an email client. A server can also refer to the actual hardware designed... More, no configuration and is self contained. It is a transactional database engine that supports the SQL (Structured Query Language) for manipulating and managing data within the storage layers.
This embedded SQL database engine is now currently at version 3.17.0.
Highlights of the SQLite 3.17.0 Release
SQLite now claims 25% increase in performance over the previous versions. This is achieved by loop unrolling, using the sqlite3_blob key/value access object instead of SQL for pulling content out of R-Tree nodes as well as using compiler built-ins like __builtin_bswap32() or _byteswap_ulong() for byteswapping when available.
The default lookaside size has been increased from 512,125 to 1200,100 providing better performance while only adding 56KB of extra memory per connection. Also added is the SQLITE_ENABLE_NULL_TRIM compile-time option, resulting in significantly smaller database files for Application software or app is a program or group of programs designed to run on computing devices which perform a group of functions, tasks, or activities for the end-user. These programs usually consist of system software and application software. System software interacts with computers at a basic level performing low-level. Application software resides above system software directly interacting with the... More.
The default SQLITE_DEFAULT_PCACHE_INITSZ has been decreased from 100 to 20, for improved performance. The SQLITE_UINT64_TYPE compile-time option has also been added.
SQLite now throws an error if the ON clause of a LEFT JOIN references tables to the right of the ON clause the way it is done in PostgreSQL. It also ensures that the sqlite3_blob_reopen() In computing, an interface is a shared means by which two or more separate components of a computer system exchange information. The interface could be between the human and a computing device, two computers, computer hardware, software or peripheral devices. Examples include touch screens which allow information to be exchanged between a human and the devices, A software graphical interface,... More can correctly handle short rows.