The release of SQLite 3.39 has been announced, a lightweight DBMS presented as a dynamic library. The SQLite code is released into the public domain, meaning it can be used freely and at no cost for any purpose. Financial support for the SQLite developers is provided by a consortium that includes companies such as Adobe, Oracle, Mozilla, Bentley, and Bloomberg.
Key Changes:
- Support has been added for right and full outer join operations — 'RIGHT OUTER JOIN' and 'FULL OUTER JOIN'.
- New comparison operators have been introduced — 'IS NOT DISTINCT FROM' and 'IS DISTINCT FROM', which are identical to the previously available 'IS' and 'IS NOT' operators, added to enhance compatibility with SQL standards and PostgreSQL.
- On Unix systems, all symbolic links in database names are resolved to determine the canonical name of the database before opening the file.
- The use of the HAVING clause has been permitted for any aggregate queries, including those that do not contain a 'GROUP BY' clause.
- Numerous micro-optimizations have been made, cumulatively allowing a 2.3% reduction in CPU load in tests.
Source: opennet.ru
