Recent SQLite News
(news.html)
... See the associated forum threads for details.
Other trifling fixes are also included in the patch.
2024-01-30 - Version 3.45.1
Version 3.45.1 is a patch against SQLite version 3.45.0.
The main focus of ...
|
The SQLite Query Optimizer Overview
(optoverview.html)
12. Subquery Co-routines
... A co-routine is like a subroutine in that it runs in the same thread
as the caller and eventually returns control back to the caller. The
difference is that a co-routine also has the ability to return
before ...
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
7.4. The "merge=X,Y" command
... To avoid spiky INSERT performance, an application can run the
"merge=X,Y" command periodically, possibly in an idle thread or
idle process, to ensure that the FTS table never accumulates
too many b-tree segments at the same level ...
|
SQLite Session Module C/C++ Interface
(session.html)
... If it is invoked
while any other thread is inside any other sessions method then the
results are undefined. Furthermore, if it is invoked after any sessions
related objects have been created, the results are also undefined.
The first argument ...
|
The Virtual Database Engine of SQLite
(vdbe.html)
... This is done to
make sure the database schema hasn't been changed by another thread, in
which case it has to be reread.
The second Transaction
instruction begins a transaction and starts a rollback journal for
database 1, the ...
|
Page generated by FTS5 in about 76.04 ms.