Uniform Resource Identifiers
(uri.html)
3.3. Recognized Query Parameters
... nolock=1
The nolock query parameter is a boolean that disables all calls
to the xLock, xUnlock, and xCheckReservedLock methods of the VFS when true.
The nolock query parameter might be used, for example, when trying to
access a file ...
|
SQLite Shared-Cache Mode
(sharedcache.html)
2.2.1. Read-Uncommitted Isolation Mode
... Also, read-uncommitted mode has no effect on the sqlite_schema
locks required by the rules enumerated below (see section
"Schema (sqlite_schema) Level Locking").
/* Set the value of the read-uncommitted flag:
**
** True -> Set the connection to read-uncommitted mode.
** False ...
|
Floating Point Numbers
(floatingpoint.html)
1.2.2. Is it close enough?
... So if the 47.49 price is exact
when you enter it, then the effects of inflation will cause the true value to
exactly equal the value actually stored
(47.4900000000000019895196601282805204391479492187) in less than
one ten-millionth of a second ...
|
The SQLite R*Tree Module
(rtree.html)
4. Using R*Trees Effectively
... The R*Tree boundary is just an approximation of the true object
boundary. So what typically happens is that the R*Tree index is used to
narrow a search down to a list of candidate objects and then more detailed ...
|
SQLite Changes From Version 3.4.2 To 3.5.0
(34to35.html)
... The second argument is true to make the new VFS the default VFS so that
it will be used by the legacy sqlite3_open() and sqlite3_open16() APIs.
If the new VFS is not the default, then you will probably have to ...
|
SQLite Session Module C/C++ Interface
(session.html)
... If pbIndirect is not NULL, then *pbIndirect is set to true (1) if the change
is an indirect change, or false (0) otherwise. See the documentation for
sqlite3session_indirect() for a description of direct and indirect
changes.
If no error occurs ...
|
The SQLite Zipfile Module
(zipfile.html)
3.2.1. Adding Entries to a Zip Archive
... it must be
true that (mode & 0040000)=0040000).
Otherwise, the value inserted into this field is the file contents
for a regular file, or the target of a symbolic link.
method
This field must be set one of integer values ...
|
Clustered Indexes and the WITHOUT ROWID Optimization
(withoutrowid.html)
3. Benefits Of WITHOUT ROWID Tables
... The special "INTEGER PRIMARY KEY" column type in ordinary SQLite tables
causes the column to be an alias for the rowid, and so an INTEGER PRIMARY
KEY is a true PRIMARY KEY. But any other kind of PRIMARY KEYs, including ...
|
Dynamic Memory Allocation In SQLite
(malloc.html)
3.4. Memory status
... sqlite3_config(SQLITE_CONFIG_MEMSTATUS, onoff);
The "onoff" parameter is true to enable the tracking of memory
statistics and false to disable statistics tracking.
Assuming statistics are enabled, the following routine can be used
to access them:
sqlite3_status(verb, ¤t, &highwater ...
|
Write-Ahead Logging
(wal.html)
9. Sometimes Queries Return SQLITE_BUSY In WAL Mode
... This is mostly true.
But there are some obscure cases where a query against a WAL-mode
database can return SQLITE_BUSY, so applications should be prepared
for that happenstance.
Cases where a query against a WAL-mode database can return ...
|
Page generated by FTS5 in about 71.62 ms.