Isolation In SQLite
(isolation.html)
... Isolation Between Database Connections
If the same database is being read and written using two different
database connections (two different sqlite3 objects returned by
separate calls to sqlite3_open()) and the two database connections
do not have a shared cache, then ...
|
The RBU Extension
(rbu.html)
3.2. RBU Vacuum C/C++ Programming
... sqlite3_mprintf("%s-vacuum", zTarget);
if( zState==0 ) return SQLITE_NOMEM;
pRbu = sqlite3rbu_vacuum(zTarget, zState);
sqlite3_free(zState);
if( pRbu ){
sqlite3 *dbTarget = sqlite3rbu_db(pRbu, 0);
sqlite3 *dbState = sqlite3rbu_db(pRbu, 1);
/* Any custom collation sequences used by the target database must
** be registered with ...
|
The SQLite Zipfile Module
(zipfile.html)
2. Obtaining and Compiling Zipfile
... int sqlite3_zipfile_init(sqlite3 *db, void*, void*);
The first argument passed should be the database handle to register the
extension with. The second and third arguments should both be passed 0.
Zipfile is included in most builds of the command-line ...
|
Compile-time Options
(compile.html)
9. Options To Omit Features
... make clean; make sqlite3.c
The resulting "sqlite3.c" amalgamation code file (and its associated
header file "sqlite3.h") can then be moved to a non-unix platform
for final compilation using a native compiler.
The SQLITE_OMIT_* options are unsupported ...
|
The SQLite R*Tree Module
(rtree.html)
6. Custom R-Tree Queries
... int sqlite3_rtree_query_callback(
sqlite3 *db,
const char *zQueryFunc,
int (*xQueryFunc)(sqlite3_rtree_query_info*),
void *pContext,
void (*xDestructor)(void*)
);
int sqlite3_rtree_geometry_callback(
sqlite3 *db,
const char *zGeom,
int (*xGeom)(sqlite3_rtree_geometry *, int nCoord, double *aCoord, int *pRes),
void *pContext
);
The sqlite3_rtree_query_callback() became available with SQLite
version ...
|
C API: Configuration Options
(c3ref/c_config_covering_index_scan.html)
SQLITE_CONFIG_SINGLETHREAD, SQLITE_CONFIG_MULTITHREAD, SQLITE_CONFIG_SERIALIZED, SQLITE_CONFIG_MALLOC, SQLITE_CONFIG_GETMALLOC, SQLITE_CONFIG_SCRATCH ...
... The first argument should
be a pointer to a function of type void(*)(void*,sqlite3*,const char*, int).
The second should be of type (void*). The callback is invoked by the library
in three separate circumstances, identified by the value ...
|
SQLite As An Application File Format
(appfileformat.html)
... One has merely to link against the SQLite library, or include the
single "sqlite3.c" source file with the rest of the
application C code, and SQLite will take care of all of the application
file I/O. This can ...
|
Vulnerabilities
(cves.html)
3. Status Of Recent SQLite CVEs
... The code that contains the bug
does not appear in standard SQLite builds, though it
is included in the sqlite3.exe command-line tool.
Applications must link against the extra source code files that
implement the extension and take other ...
|
SQLite Frequently Asked Questions
(faq.html)
... Under Unix, you should not carry an open SQLite database across
a fork() system call into the child process.
(7) How do I list all tables/indices contained in an SQLite database
If you are running the sqlite3 command-line ...
|
SQL Language Expressions
(lang_expr.html)
... See the detailed discussion on collating sequences
in the Datatype In SQLite3 document for additional information.
The unary operator + is a no-op. It can be applied
to strings, numbers, blobs or NULL and it always returns a result
with ...
|
Page generated by FTS5 in about 93.84 ms.