Software update: SQLite 3.36.0

SQLite is a database system developed in C that can be used as a database 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. The developer has released version 3.36.0 with the following list of changes:

Version 3.36.0

• Improvement to the EXPLAIN QUERY PLAN output to make it easier to understand.
• Byte-order marks at the start of a token are skipped as if they were whitespace.
• An error is raised on any attempt to access the rowid of a VIEW or subquery. Formerly, the rowid of a VIEW would be indeterminate and often would be NULL. The -DSQLITE_ALLOW_ROWID_IN_VIEW compile-time option is available to restore the legacy behavior for applications that need it.
• The sqlite3_deserialize() and sqlite3_serialize() interfaces are now enabled by default. The -DSQLITE_ENABLE_DESERIALIZE compile-time option is no longer required. Instead, there is is a new -DSQLITE_OMIT_DESERIALIZE compile-time option to omit those interfaces.
• The “memdb” VFS now allows the same in-memory database to be shared among multiple database connections in the same process as long as the database name begins with “/”.
• Back out the EXISTS-to-IN optimization (item 8b in the SQLite 3.35.0 change log) as it was found to slow down queries more often than speed them up.
• Improve the constant-propagation optimization so that it works on non-join queries.