SQLite Launch 3.43.0 On 2023-08-24
by Phil Tadros
August 24, 2023
2023-08-24 16:51:28
SQLite Launch 3.43.0 On 2023-08-24
SQLite Launch 3.43.0 On 2023-08-24
- 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. - Enhancements to the date and time functions:
- Added new time shift modifiers of the shape ±YYYY-MM-DD HH:MM:SS.SSS.
- Added the timediff() SQL function.
- Added the octet_length(X) SQL operate.
- Added the sqlite3_stmt_explain() API.
- Question planner enhancements:
- 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. - Improve the concept prover within the OUTER JOIN strength reduction optimization
in order that it returns fewer false-negatives.
- Generalize the LEFT JOIN energy discount optimization in order that it really works
- Enhancements to the decimal extension:
- New operate decimal_pow2(N) returns the N-th energy of two for integer N
between -20000 and +20000. - 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. - 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.
- New operate decimal_pow2(N) returns the N-th energy of two for integer N
- Efficiency enhancements to JSON processing ends in a 2x efficiency
enchancment for some sorts of processing on massive JSON strings. - 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.) - 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. - The VFS for unix now assumes that the nanosleep() system name is
accessible except compiled with -DHAVE_NANOSLEEP=0.Hashes:
See Also - SQLITE_SOURCE_ID: 2023-08-24 12:36:59 0f80b798b3f4b81a7bb4233c58294edd0f1156f36b6ecf5ab8e83631d468778c
- 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.
What's Your Reaction?
Excited
0
Happy
0
In Love
0
Not Sure
0
Silly
0