SQLite 3.36 has been released, a lightweight DBMS presented as a dynamic library. The SQLite code is in the public domain, meaning it can be used freely and for any purpose. Financial support for the SQLite developers is provided by a specially established consortium, which includes companies such as Adobe, Oracle, Mozilla, Bentley, and Bloomberg.
Key Changes:
- The output of the 'EXPLAIN QUERY PLAN' command has been made easier to understand.
- An error is generated when attempting to access the rowid in a VIEW or subquery. To restore access to rowid for views, the compile option '-DSQLITE_ALLOW_ROWID_IN_VIEW' has been provided.
- The interfaces sqlite3_deserialize() and sqlite3_serialize() are enabled by default. The compile option '-DSQLITE_OMIT_DESERIALIZE' is available to disable it.
- In the 'memdb' VFS, sharing of in-memory databases is allowed across different connections to a single process if the database name starts with '/'.
- The 'EXISTS-to-IN' optimization introduced in the previous release has been reverted, as it slowed down certain queries.
- The constant-checking join optimization has been adapted to work with non-join queries.
- The REGEXP extension has been included in the CLI.
Source: opennet.ru
