ProHoster > Blog > internet news > Release of DBMS SQLite 3.30

Release of DBMS SQLite 3.30

Published Release SQLite 3.30.0, 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 changes:

  • Added the ability to use the expression "FILTERSΒ» with aggregate functions, which makes it possible to limit the scope of data processed by the aggregate function only to records that meet a given condition;
  • The "ORDER BY" block provides support for the flags "NULLS FIRST" and "NULLS LASTΒ» to determine the location of elements with a null value when sorting;
  • Added command to the command line interface.recoverΒ» to restore the contents of damaged files from the database;
  • In extension UBI added support indexing expressions;
  • PRAGMA index_info and PRAGMA index_xinfo are extended to provide information about the storage layout of tables created in WITHOUT ROWID mode;
  • Added API sqlite3_drop_modules(), which allows you to disable the automatic loading of virtual tables from the application;
  • The DB schema parser has been changed to display an error if the type, name and tbl_name columns in the sqlite_master table are corrupted when connecting in a non-writable_schema mode;
  • The PRAGMA function_list, PRAGMA module_list and PRAGMA pragma_list commands are enabled by default. To change the default build behavior, "-DSQLITE_OMIT_INTROSPECTION_PRAGMAS" must be explicitly specified;
  • For application-defined SQL functions, the SQLITE_DIRECTONLY flag has been proposed to disable the use of these functions inside triggers and views.

Source: opennet.ru

Add a comment