Small. Fast. Reliable.
Choose any three.
Choose any three.
|
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 ...
|
|
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)
3. 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. For those platforms it is best to use the configure script
and makefile that is ...
|
|
SQLite FTS5 Extension
(fts5.html)
3.5. FTS5 NEAR Queries
... CREATE VIRTUAL TABLE f USING fts5(x);
INSERT INTO f(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 ...
|
|
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 ...
|
|
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 ...
|
Page generated by FTS5 in about 75.00 ms.