Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Online Backup API.
(c3ref/backup_finish.html)
sqlite3_backup_init(), sqlite3_backup_step(), sqlite3_backup_finish(), sqlite3_backup_remaining(), sqlite3_backup_pagecount()
... Using the SQLite Online Backup API
SQLite holds a write transaction open on the destination database file
for the duration of the backup operation.
The source database is read-locked only while it is being read;
it is not locked ...
|
|
STRICT Tables
(stricttables.html)
... For this latter group, SQLite supports a strict typing
mode, as of version 3.37.0 (2021-11-27), that is enabled
separately for each table.
2. STRICT Tables
In a CREATE TABLE statement, if the "STRICT" table-option keyword ...
|
|
ANALYZE
(lang_analyze.html)
... Or, if the application keeps a single database connection open
for a long time, then it should run "PRAGMA optimize=0x10002" when the
connection is first opened and run "PRAGMA optimize;" periodically thereafter,
perhaps once per day or even once ...
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... This instruction works like OpenRead except that it opens the cursor
in read/write mode.
See also: OpenRead, ReopenIdx
Or
Take the logical OR of the values in register P1 and P2 and
store the answer in register P3.
If ...
|
|
C API: Database Connection Configuration Options
(c3ref/c_dbconfig_defensive.html)
SQLITE_DBCONFIG_MAINDBNAME, SQLITE_DBCONFIG_LOOKASIDE, SQLITE_DBCONFIG_ENABLE_FKEY, SQLITE_DBCONFIG_ENABLE_TRIGGER, SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER, SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION ...
... WAL mode is closed or detached from a
database handle, SQLite checks if if there are other connections to the
same database, and if there are no other database connection (if the
connection being closed is the last open connection ...
|
|
35% Faster Than The Filesystem
(fasterthanfs.html)
... The performance difference arises (we believe) because when
working from an SQLite database, the open() and close() system calls
are invoked only once, whereas
open() and close() are invoked once for each blob
when using blobs stored in individual files ...
|
|
SQLite Unlock-Notify API
(unlock_notify.html)
... The current writer concludes its transaction, OR
The number of open read-transactions on the shared-cache drops to zero.
Failed attempts to open new read-transactions return SQLITE_LOCKED to the
caller. If the caller then calls sqlite3_unlock_notify() to register ...
|
|
The C language interface to SQLite Version 2
(c_interface.html)
... typedef struct sqlite sqlite;
#define SQLITE_OK 0 /* Successful result */
sqlite *sqlite_open(const char *dbname, int mode, char **errmsg);
void sqlite_close(sqlite *db);
int sqlite_exec(
sqlite *db,
char *sql,
int (*xCallback)(void*,int,char**,char**),
void *pArg,
char **errmsg
);
The above ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
... With other arguments, the sqlite3 command opens the database
named in the second non-option argument, or named "" if there is no such.
If the open succeeds, a new Tcl command named by the first argument is created
and "" is ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... See the threading mode documentation for
additional information.
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 ...
|
Page generated by FTS5 in about 85.27 ms.