SQLite 3.19.1 Released

SQLite 3.19.1 has been published, SQLite is an open source, cross-platform, free small C library, the implementation of a separate, embeddable, transactional, server-free and 0 configuration of SQL database engine.

Update content:

• When you use an index on an expression, you try to use an expression value that is already in the index instead of loading the original column and re-evaluating the expression.

• Optimizes the flattening optimization so that it flatten the view to the right of the left JOIN.

• Use replace () instead of char () to escape line breaks and carriage returns in strings embedded in the command-line Shell's. Dump output.

• Avoid Sqlite3_blob unnecessary invalid handling when making changes to unrelated tables.

• Optimizes PRAGMA Integrity_check to identify two or more rows of tables with the same rowid.

• Optimizes the FTS5 query syntax so that column filters can be applied to any expression.

• ......

Click here to view full updates

：

Http://www.sqlite.org/download.html

SQLite 3.19.1 Released