Now Reading
SQLite Launch 3.43.0 On 2023-08-24

SQLite Launch 3.43.0 On 2023-08-24

2023-08-24 16:51:28



SQLite Launch 3.43.0 On 2023-08-24




Small. Quick. Dependable.
Select any three.

SQLite Launch 3.43.0 On 2023-08-24

  1. Add assist for Contentless-Delete FTS5 Indexes. It is a selection
    of FTS5 full-text search index that omits storing the content material that’s being listed
    whereas additionally permitting information to be deleted.
  2. Enhancements to the date and time functions:
    1. Added new time shift modifiers of the shape ±YYYY-MM-DD HH:MM:SS.SSS.
    2. Added the timediff() SQL function.
  3. Added the octet_length(X) SQL operate.
  4. Added the sqlite3_stmt_explain() API.
  5. Question planner enhancements:
    1. Generalize the LEFT JOIN energy discount optimization in order that it really works
      for RIGHT and FULL JOINs as nicely. Rename it to
      OUTER JOIN strength reduction.
    2. Improve the concept prover within the OUTER JOIN strength reduction optimization
      in order that it returns fewer false-negatives.
  6. Enhancements to the decimal extension:
    1. New operate decimal_pow2(N) returns the N-th energy of two for integer N
      between -20000 and +20000.
    2. New operate decimal_exp(X) works like decimal(X) besides that it returns
      the end in exponential notation – with a “e+NN” on the finish.
    3. If X is a floating-point worth, then the decimal(X) operate now does a full
      growth of that worth into its precise decimal equal.
  7. Efficiency enhancements to JSON processing ends in a 2x efficiency
    enchancment for some sorts of processing on massive JSON strings.
  8. New makefile goal “verify-source” checks to make sure that there are not any
    unintentional adjustments within the supply tree. (Works for
    canonical source code solely –
    not for precompiled amalgamation tarballs.)
  9. Added the SQLITE_USE_SEH compile-time possibility that allows Structured
    Exception Dealing with on Home windows whereas working with the memory-mapped
    shm file that’s a part of WAL mode processing. This feature is enabled
    by default when constructing on Home windows utilizing Makefile.msc.
  10. The VFS for unix now assumes that the nanosleep() system name is
    accessible except compiled with -DHAVE_NANOSLEEP=0.

    Hashes:

    See Also

  11. SQLITE_SOURCE_ID: 2023-08-24 12:36:59 0f80b798b3f4b81a7bb4233c58294edd0f1156f36b6ecf5ab8e83631d468778c
  12. SHA3-256 for sqlite3.c: a6fc5379891d77b69a7d324cd24a437307af66cfdc3fef5dfceec3c82c8d4078

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