SQLite 3.44 has been released. SQLite is a lightweight DBMS in the form of a connected library. The SQLite code is distributed as public domain, allowing it to be used without restrictions and free of charge for any purpose. The financial support for SQLite developers is provided through a consortium consisting of companies such as Bentley, Bloomberg, Expensification, and Navigation Data Standard.
The main changes in this release are as follows:
- In aggregate functions, the expression “Order by” is now allowed to process the arguments of the function in a given order, which can be useful for functions like string_agg() and json_group_array().
- Added support for the scalar SQL functions concat() and concat_ws(), which are compatible with PostgreSQL, MS SQL Server, and MySQL.
- Support for the aggregate function string_agg(), compatible with PostgreSQL and MS SQL Server, has been added.
- Support for specifiers “%E”, “%f”, “%I”, “%k”, “%l”, “%p”, “%p”, “%r”, “%t”, and “%u” has been added to the SQL function strFtime().
- The display of many errors associated with the expression “Create Table” is now shown after executing the expression, rather than after the first use of the table.
- The pragma integrity_check command now ensures the consistency of the contents of various built-in virtual tables used in extensions such as FTS3, FTS4, FTS5, Rtree, and Geopoly
/Reports, release notes, official announcements.