Now Reading
SQLite Launch 3.44.0 On 2023-11-01

SQLite Launch 3.44.0 On 2023-11-01

2023-11-01 11:28:42



SQLite Launch 3.44.0 On 2023-11-01




Small. Quick. Dependable.
Select any three.

SQLite Launch 3.44.0 On 2023-11-01

  1. Aggregate functions can now embody an ORDER BY clause after their final
    parameter. The arguments to the operate are processed within the order
    specified. This may be vital for capabilities like
    string_agg() and json_group_array().
  2. Add help for the concat() and concat_ws() scalar SQL capabilities,
    appropriate with PostgreSQL, SQLServer, and MySQL.
  3. Add help for the string_agg() combination SQL operate, appropriate
    with PostgreSQL and SQLServer.
  4. New conversion letters on the strftime() SQL function: %e %F %I %okay %l %p %P %R %T %u
  5. Add new C-language APIs: sqlite3_get_clientdata() and sqlite3_set_clientdata().
  6. Many errors related to CREATE TABLE at the moment are raised when the CREATE TABLE assertion
    itself is run, moderately than being deferred till the primary time the desk is definitely
    used.
  7. The PRAGMA integrity_check command now verifies the consistency of the
    content material in varied built-in virtual tables utilizing the brand new xIntegrity method.
    This works for the FTS3, FTS4, FTS5, RTREE, and GEOPOLY extensions.
  8. The SQLITE_DBCONFIG_DEFENSIVE setting now prevents PRAGMA writable_schema
    from being turned on. Beforehand writable_schema may very well be turned on, however would
    not truly enable the schema to be writable. Now it merely can’t be turned on.
  9. Tag the built-in FTS3, FTS4, FTS5, RTREE, and GEOPOLY digital tables as
    SQLITE_VTAB_INNOCUOUS in order that they can be utilized within triggers in
    high-security deployments.
  10. The PRAGMA case_sensitive_like assertion is deprecated, as its use when the
    schema comprises LIKE operators can result in stories of database corruption
    by PRAGMA integrity_check.
  11. SQLITE_USE_SEH (Structured Exception Dealing with) is now enabled by default every time
    SQLite is constructed utilizing the Microsoft C compiler. It may be disabled utilizing
    -DSQLITE_USE_SEH=0
  12. Question planner optimizations:
    1. In partial index scans, if the WHERE clause implies a continuing worth for a desk
      column, substitute occurrences of that desk column with the fixed. This
      will increase the chance of the partial index being a masking index.
    2. Disable the view-scan optimization (added in version 3.42.0 – merchandise 1c)
      because it was inflicting a number of efficiency regressions. As a substitute, scale back
      the estimated row rely for DISTINCT subqueries by an element of 8.
  13. SQLite now performs run-time detection of whether or not or not the underlying {hardware}
    helps “lengthy double” with precision higher than “double” and makes use of acceptable
    floating-point routines relying on what it found.
  14. The CLI for Home windows now defaults to utilizing UTF-8 for each enter
    and output on platforms that help it. The –no-utf8 choice is on the market
    to disable UTF8 help.

    Hashes:

    See Also

  15. SQLITE_SOURCE_ID: 2023-11-01 11:23:50 17129ba1ff7f0daf37100ee82d507aef7827cf38de1866e2633096ae6ad8130
  16. SHA3-256 for sqlite3.c: d9e6530096136067644b1cb2057b3b0fa51070df99ec61971f73c9ba6aa9a36e

A complete list of SQLite releases
in a single web page and a chronology are each additionally accessible.
An in depth historical past of each
check-in is on the market at

SQLite version control site
.

Source Link

What's Your Reaction?
Excited
0
Happy
0
In Love
0
Not Sure
0
Silly
0
View Comments (0)

Leave a Reply

Your email address will not be published.

2022 Blinking Robots.
WordPress by Doejo

Scroll To Top