What’s new in SQLite 3.13.0
With SQLite 3.13.0 comes with several 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 fixes some of which include fixes to multi-row one-pass
DELETE optimization. This issue was specific to self-referential subqueries in the WHERE clause. Again with
DELETE, the possibility of a segfault related to a
rowid table with an
INTEGER PRIMARY KEY and the
WHERE clause contains “
OR“. There is also a fix on a locking race condition in Windows when more than one process attempts to recover the same hot journal at the same time.
Improvements in SQLite 3.13.0 include improved Unicode filename handling in the Windows command-line shell. There is a new
sqlite3_db_config SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION 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 which allows the
sqlite3_load_extension() C-API to be enabled when
load_extension() is disabled.
The temporary directory search algorithm on Unix platforms now allows directories with write and execute permissions to serve as temporary directories. Also, delay of IO on TEMP files to be delayed for as long as possible even avoiding it completely.
There is a whole host of changes that can be found on the changelog page so I would advise you head on over there and check them out. If you just want to download the latest copy of SQLite 3.13.0 you can simply go to the official download page and get yourself the appropriate copy.
The guys at Guru99 have set up some detailed tips on how to download and install SQLite.