Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Command Line Shell For SQLite
(cli.html)
7.3. File I/O Functions
... The readfile(X) SQL function reads the entire content of the file named
X and returns that content as a BLOB. This can be used to load content into
a table. For example:
sqlite> CREATE TABLE images(name TEXT ...
|
|
C/C++ Interface For SQLite Version 3 (old)
(capi3.html)
... The API for version 3.0 is similar to the version 2.X API,
but with some important changes. Most noticeably, the "sqlite_"
prefix that occurs on the beginning of all API functions and data
structures are changed to "sqlite3_ ...
|
|
C API: Standard File Control Opcodes
(c3ref/c_fcntl_begin_atomic_write.html)
SQLITE_FCNTL_LOCKSTATE, SQLITE_FCNTL_GET_LOCKPROXYFILE, SQLITE_FCNTL_SET_LOCKPROXYFILE, SQLITE_FCNTL_LAST_ERRNO, SQLITE_FCNTL_SIZE_HINT, SQLITE_FCNTL_CHUNK_SIZE ...
... The argument X in
sqlite3_file_control(db,SQLITE_FCNTL_VFS_POINTER,X) must be
of type "sqlite3_vfs **". This opcodes will set *X
to a pointer to the top-level VFS.
When there are multiple VFS shims in the stack, this opcode finds the
upper ...
|
|
How To Compile SQLite
(howtocompile.html)
4. Compiling The TCL Interface
... gcc -o libtclsqlite3.so -shared tclsqlite3.c -lpthread -ldl -ltcl
Building shared libraries for Mac OS X and Windows is not nearly so simple,
unfortunately.
To generate a standalone tclsh that is statically linked with SQLite,
use this compiler invocation ...
|
|
SQLite FTS5 Extension
(fts5.html)
3.5. FTS5 NEAR Queries
... CREATE VIRTUAL TABLE ft USING fts5(x);
INSERT INTO ft(rowid, x) VALUES(1, 'A B C D x x x E F x');
... MATCH 'NEAR(e d, 4)'; -- Matches!
... MATCH 'NEAR(e d, 3)'; -- Matches!
... MATCH 'NEAR(e d ...
|
|
The SQLite Zipfile Module
(zipfile.html)
3.2.1. Adding Entries to a Zip Archive
... mode
If NULL is inserted into the mode column, then the mode of the
new archive entry is automatically set to either 33188 (-rw-r--r--)
or 16877 (drwxr-xr-x), depending on whether or not the values
specified for ...
|
|
SQLite Unlock-Notify API
(unlock_notify.html)
... For example, if a call to
sqlite3_step() is an attempt to read from table X, and some other connection
Y is holding a write-lock on table X, then sqlite3_step() will return
SQLITE_LOCKED. If sqlite3_unlock_notify() is then called, the unlock ...
|
|
SELECT
(lang_select.html)
... For each pair of named
columns, the expression "lhs.X = rhs.X" is evaluated for each row of
the cartesian product as a boolean expression. Only rows for which
all such expressions evaluates to true are included from the
result ...
|
|
An Asynchronous I/O Module For SQLite
(asyncvfs.html)
... 3.0 PORTING
Currently the asynchronous IO extension is compatible with win32 systems
and systems that support the pthreads interface, including Mac OS X, Linux,
and other varieties of Unix.
To port the asynchronous IO extension to another platform, the ...
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
8. Double-quoted String Literals Are Accepted
... But, in an effort to be compatible
with MySQL 3.x (which was one of the most widely used RDBMSes
when SQLite was first being designed) SQLite will also interpret
a double-quotes string as
string literal if it does ...
|
Page generated by FTS5 in about 154.47 ms.