Published Release sqlite 3.37 , lightweight DBMS decorated in the form of a connected library. SQLite code extends as public domain (Public domain), i.e. It can be used without restrictions and free for any purpose. Financial support for SQLite developers is carried out by a specially created Consortium, which includes companies such as Adobe, Oracle, Mozilla, Bentley and Bloomberg.
Basic Changes :
- Added support for creating tables with a sign “ strict ” requiring mandatory type indication when declaring columns and applying strict test compliance check added to the data columns. When exposing this flag, SQLite will display an error if it is impossible to give the specified data to the type of column. For example, if the column is created as “integer”, then the transmission of the string value ‘123’ will lead to the addition of the number 123, but an attempt to specify ‘xyz’ is completed.
- in operation “ Alter Table Add Column ” Added checking the conditions for the existence of strings when adding columns with expression checks “Check” or with the terms “Not NULL”.
- Implemented expression “ Pragma Table_List ” to display information about tables and views.
- In the command line interface, the command “ .connection “, which allows you to simultaneously support several connections to the database.
- Added parameter “ –safe “, disabling CLI commands and SQL expressions that allow you to perform operations With database files different from the database specified on the command line.
- The CLI performed optimizing the performance of reading SQL expressions broken into several lines.
- Added functions sqlite3_autovacuum_pages (), sqlite3_changes64 () and sqlite3_total_changes64 ().
- In the query scheduler, ignore the “Order by Clauses” expressions in the subqueries and views, if the removal of these expressions does not change the semantic request.
- changed extension Table-Valued , the first parameter (“start”) in which is translated into the discharge required. To return the old behavior, a rebeling is possible with the option “-Dzero_argument_generate_series”.
- reduced memory consumption for storing the DB schema.
/Media reports.