The release of SQLite 3.36, a lightweight DBMS designed as a plug-in library, has been published. The SQLite code is distributed in the public domain, i.e. can be used without restrictions and free of charge for any purpose. Financial support for SQLite developers is provided by a specially created consortium, which includes companies such as Adobe, Oracle, Mozilla, Bentley and Bloomberg.
Major changes:
- The output of the "EXPLAIN QUERY PLAN" command has been made easier to read.
- An error has been generated when trying to access a row identifier (rowid) in a view (VIEW) or subquery. To return the ability to access the rowid for views, the assembly option "-DSQLITE_ALLOW_ROWID_IN_VIEW" is provided
- The sqlite3_deserialize() and sqlite3_serialize() interfaces are enabled by default. To disable, the build option "-DSQLITE_OMIT_DESERIALIZE" is provided
- VFS "memdb" allows sharing of an in-memory database in different connections to the same process if the database name starts with "/".
- Reverted an "EXISTS-to-IN" optimization introduced in the last release that slowed down some queries.
- The constant check join optimization has been adapted to work with non-join queries.
- The REGEXP extension is included in the CLI.
Source: opennet.ru