Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The Session Extension
(sessionintro.html)
3.1. Capturing a Changeset
... A single session object monitors changes made to a single database
(i.e. "main", "temp" or an attached database) via a single
sqlite3* database handle.
The session object is configured with a set of tables to monitor
changes on.
By ...
|
|
C API: Opening A New Database Connection
(c3ref/open.html)
sqlite3_open(), sqlite3_open16()
... The only exception is that
if SQLite is unable to allocate memory to hold the sqlite3 object,
a NULL will be written into *ppDb instead of a pointer to the sqlite3
object. If the database is opened (and/or created ...
|
|
SQLite Unlock-Notify API
(unlock_notify.html)
... In
** this case the caller should not retry the operation and should roll
** back the current transaction (if any).
*/
static int wait_for_unlock_notify(sqlite3 *db){
int rc;
UnlockNotification un;
/* Initialize the UnlockNotification structure. */
un.fired = 0;
pthread_mutex_init(&un.mutex, 0);
pthread_cond_init ...
|
|
The Checksum VFS Shim
(cksumvfs.html)
3. Loading
... and shutdown the dummy database
connection. All subsequent database connections that are opened
will include this extension. For example:
sqlite3 *db;
sqlite3_open(":memory:", &db);
sqlite3_load_extension(db, "./cksumvfs");
sqlite3_close(db);
If this extension is compiled with -DSQLITE_CKSUMVFS_STATIC and
statically linked against ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
1.2. Implementation
... int sqlite3_create_module(
sqlite3 *db, /* SQLite connection to register module with */
const char *zName, /* Name of the module */
const sqlite3_module *, /* Methods for the module */
void * /* Client data for xCreate/xConnect */
);
int sqlite3_create_module_v2(
sqlite3 *db, /* SQLite connection to register module with */
const ...
|
|
The Percentile Extension
(percentile.html)
2. Obtaining and Compiling The Percentile Extension
... int sqlite3_percentile_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.
Percentile is included in most builds of the command-line ...
|
|
Result and Error Codes
(rescode.html)
3. Definitions
... Symbolic names for all result codes are created using
"#define" macros in the sqlite3.h header file.
There are separate sections in the sqlite3.h header file for
the result code definitions and the extended result code definitions.
Primary result ...
|
|
Architecture of SQLite
(arch.html)
... To avoid name collisions, all external
symbols in the SQLite library begin with the prefix sqlite3.
Those symbols that are intended for external use (in other words,
those symbols which form the API for SQLite) add an underscore, and
thus ...
|
|
Swarmvtab Virtual Table
(swarmvtab.html)
2. Compiling and Using Swarmvtab
... int sqlite3_unionvtab_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.
The source file and entry point are named for "unionvtab ...
|
|
SQLite Session Module C/C++ Interface
(session.html)
... Add a Schema to a Changegroupint sqlite3changegroup_schema(sqlite3_changegroup*, sqlite3*, const char *zDb);
This method may be used to optionally enforce the rule that the changesets
added to the changegroup handle must match the schema of database zDb
("main", "temp", or ...
|
Page generated by FTS5 in about 92.39 ms.