release , a lightweight DBMS designed as a plug-in library. The SQLite code is released into the public domain, meaning it can be used without restrictions and free of charge for any purpose. Financial support for SQLite developers comes from a consortium that includes companies such as Adobe, Oracle, Mozilla, Bentley, and Bloomberg.
Key :
- window functions (window functions or analytic functions that allow calculations for each row of a query using other rows): support for expressions has been added , the ability to use of window functions (one window defined in the scope of another) is provided grouping using the GROUP BY expression, and RANGE limits have been implemented and ;
- The implementation of the command "" has been enhanced, and it can now be used with databases available in read-only mode;
- New query optimizations have been added: of LIKE expressions works more efficiently with the ESCAPE keyword and in 'PRAGMA case_sensitive_like' mode. When a is present, unnecessary checks of conditions that are guaranteed to be true in the WHERE expression have been eliminated;
- The CLI interface has added the command "." for specifying (masks that can be substituted in any SQL expressions). In the ".archive" command, the option "--update" has been revised to skip unchanged files already in the archive, and the option "--insert" has been added to include files in the archive;
- An addition has been made , which allows creating, applying, and analyzing the of Fossil delta changes applied in the RBU extension;
- The reliability of working with damaged database files has been increased;
- A mirror of the project repository has been launched on (main supported using the version control system , created by the author of SQLite).
Source: opennet.ru
