Published Release SQLite 3.36 , lightweight DBMS decorated in the form of a connected library. SQLite code is distributed as a public domain (Public Domain), i.e. It can be used without restrictions and free for any purpose. Financial support for SQLite developers is carried out by a specially created consortium, which includes companies such as Adobe, Oracle, Mozilla, Bentley and Bloomberg.
Basic Changes :
- Team output “ Explain Query Plan ” is made simpler for perception.
- Error generation is provided while trying to access the row identifier (RowID) in the view or subquery. To return access to Rowid, the representation is provided for assembly set “-dsqlite_allow_rowid_in_view”
- Included by default interfaces sqlite3_deserialize () and sqlite3_serve () . To disable the assembly option “-DSQLITE_OMIT_DERIALIZE”
- in the VFS “MEMDB” is allowed to share the stored database in different connections to one process, if the name of the database begins with “/ “.
- canceled the “EXISTS-TO-IN” optimization that appeared in the past release, which slowed some requests.
- Optimization Uninstalling CONSTANT check Adapted to work with queries without merger (JOIN).
- in the CLI enabled extension Regexp .
/Media reports.