Release , a lightweight DBMS packaged as a plug-in library. 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.
All :
- window functions (window-functions or analytical functions that allow for each line of the query to perform calculations using other lines): added support for the expression , it became possible to use window functions (one window is defined in the area of ββanother), provided grouping using the GROUP expression, and implemented RANGE constraints ΠΈ ;
- Improved implementation of the command "β, which can now be used with read-only databases;
- Added new query optimizations: operation of LIKE expressions together with the ESCAPE keyword and with the "PRAGMA case_sensitive_like" mode enabled. In the presence of unnecessary checks of obviously true conditions specified in the WHERE clause are excluded;
- The command "Β» for a job (masks to be substituted into any SQL expressions). In the ".archive" command, the "--update" option has been redesigned, which now skips unchanged files already in the archive, and the "--insert" option has been added to include files in the archive;
- addon added , which allows you to create, apply and parse Fossil delta changes used in the RBU extension;
- Increased reliability of work with damaged database files;
- Project repository mirror launched on (basic maintained using source control , created by the author of SQLite).
Source: opennet.ru