The release of SQLite 3.39, 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:
- Added support for right and full outer join operations on tables - “RIGHT OUTER JOIN” and “FULL OUTER JOIN”.
- New comparison operators have been proposed - "IS NOT DISTINCT FROM" and "IS DISTINCT FROM", which are identical to the previously available "IS" and "IS NOT" operators, and added to improve compatibility with SQL standards and PostgreSQL.
- On Unix systems, all symbolic links in database names are expanded to determine the canonical database name before opening the file.
- It is allowed to use the HAVING expression for any aggregation queries, including those that do not contain the “GROUP BY” expression.
- Numerous micro-optimizations were introduced, which in total reduced the CPU load in tests by 2.3%.
Source: opennet.ru
