SQLite 3.16.0 Release has been announced for general availability. This new version comes with new features and bug fixes over the previous releases.
SQLite is a SQL database engine that is self contained. It does not run as a server and is extremely lightweight. It is normally used as a highly reliable embedded file that conforms to the SQL standards. It works by reading and writing directly onto the file system.
What are the Highlights of the SQLite 3.16.0 Release
For a start SQLite 3.16.0 Release has been optimized to use 9% less The CPU (central processing unit), also called a central processor, main processor, or more commonly processor, is the brains of the computer where most calculations take place. These calculations involve carrying out the instructions of a computer program by performing the basic arithmetic, logic, controlling, and input/output (I/O) operations specified by those instructions. Simple CPU setups can consist of microprocessors... More resources. There are now enhanced ate and time functions mainly to do with unix epoch dates. Experimental support for PRAGMA functions is now included in the engine.
The “.mode quote“, “.lint fkey-indexes” and the “.imposter dot-command” commands have been added to the command-line shell. The “WHERE x NOT NULL” has been enhanced as is the same with the LIKE and GLOB matching algorithms.
The long standing In computing technology, a bug is an unintentional coding error in a computer application program, hardware device or operating system. Bugs can typically cause annoying computer glitches, or cause more serious problems including life-threatening situations. In 2018 and 2019 a bug in the sensor on the Boeing 737 Max caused Lion Air Flight 610 and Ethiopian Airlines Flight 302 to... More on the LEFT JOIN which returned incorrect results in the query planner has now been fixed. You can get a full list of changes in the release log found here. You can also get the latest download files from this official page here.