Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Uniform Resource Identifiers
(uri.html)
3.1. The URI Path
... On windows, if the absolute path begins with
"/X:/" where X is any single ASCII alphabetic
character ("a" through "z" or "A" through "Z") then the "X:"
is understood to be the drive letter of the volume containing the file ...
|
|
C API: Unlock Notification
(c3ref/unlock_notify.html)
sqlite3_unlock_notify()
... For example, if connection X is waiting for
connection Y's transaction to be concluded, and similarly connection
Y is waiting on connection X's transaction, then neither connection
will proceed and the system may remain deadlocked indefinitely.
To avoid ...
|
|
UPSERT
(lang_upsert.html)
... INSERT INTO t1 SELECT * FROM t2
ON CONFLICT(x) DO UPDATE SET y=excluded.y;
Ambiguity resolved using a WHERE clause:
INSERT INTO t1 SELECT * FROM t2 WHERE true
ON CONFLICT(x) DO UPDATE SET y=excluded.y;
3. Limitations ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
7.4. The "merge=X,Y" command
The "merge=X,Y" command (where X and Y are integers) causes SQLite
to do a limited amount of work toward merging the various inverted
index b-trees of an FTS3/4 table together into one large b-tree.
The ...
|
|
How SQLite Is Tested
(testing.html)
7.2. Coverage testing of defensive code
... In release builds, these macros are pass-throughs:
#define ALWAYS(X) (X)
#define NEVER(X) (X)
During most testing, however, these macros will throw an assertion
fault if their argument does not have the expected truth value. This
alerts the ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.20. The xSavepoint, xRelease, and xRollbackTo Methods
... When xSavepoint(X,N) is invoked, that is a signal to the virtual table X
that it should save its current state as savepoint N.
A subsequent call
to xRollbackTo(X,R) means that the state of the virtual table ...
|
|
Run-Time Loadable Extensions
(loadext.html)
2. Loading An Extension
... load_extension(X,Y). It works just like the sqlite3_load_extension()
C interface.
Both methods for loading an extension allow you to specify
the name of an entry point for the extension.
You can leave this argument blank - passing in
a NULL ...
|
|
Dynamic Memory Allocation In SQLite
(malloc.html)
2.1. Use of reallocarray()
... Instead, SQLite
does allocations of the form "X+C" or "N*X+C" or "M*N*X+C" or
"N*X+M*Y+C", and so forth. The reallocarray() interface is not helpful
in avoiding integer overflow in those cases ...
|
|
Application-Defined SQL Functions
(appfunc.html)
3. Security Implications
... Suppose, for example, an application defines
a new "system(X)" SQL function that runs its argument X as a command and
returns the integer result code. Perhaps the implementation is like this:
static void systemFunc(
sqlite3_context *context,
int argc,
sqlite3_value ...
|
|
C API: OS Interface File Virtual Methods Object
(c3ref/io_methods.html)
struct sqlite3_io_methods
... The second choice is a Mac OS X style fullsync. The SQLITE_SYNC_DATAONLY
flag may be ORed in to indicate that only the data of the file
and not its inode needs to be synced.
The integer values to xLock() and ...
|
Page generated by FTS5 in about 128.25 ms.