Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Pointer Passing Interfaces
(bindptr.html)
3. The New Pointer-Passing Interfaces
... sqlite3_bind_pointer(S,I,P,T,D) →
Bind pointer P of type T to the I-th parameter of prepared statement S.
D is an optional destructor function for P.
sqlite3_result_pointer(C,P,T,D) →
Return pointer P of ...
|
|
Write-Ahead Logging
(wal.html)
3.3. Persistence of WAL mode
... One has merely to run "PRAGMA journal_mode=WAL;" on the
database file(s) using the command-line shell or other utility, then
restart the application.
The WAL journal mode will be set on all
connections to the same database file ...
|
|
The C language interface to SQLite Version 2
(c_interface.html)
... 3.8 Changing the library's response to locked files
The sqlite_busy_handler procedure can be used to register
a busy callback with an open SQLite database. The busy callback will
be invoked whenever SQLite tries to access a database that ...
|
|
SQLite Archive Files
(sqlar.html)
5. Managing SQLite Archives From Application Code
... INSERT INTO sqlar(name,mode,mtime,sz,data)
VALUES ($name,$mode,strftime('%s',$mtime),
length($content),sqlar_compress($content));
Extract an entry from the SQLite Archive using code like this:
SELECT name, mode, datetime(mtime,'unixepoch'), sqlar_uncompress(data,sz)
FROM sqlar ...
|
|
The Use Of assert() In SQLite
(assert.html)
2. Examples
... Those assert()s specify pre-conditions to the routine that are true for
consistent database files, but which might be false if the database file
is corrupt. Knowledge of these kinds of conditions is very helpful to
readers who are ...
|
|
Row Values
(rowvalue.html)
3.4. Update multiple columns of a table based on a query
... UPDATE ftsdocs SET
idxed=1,
name=NULL,
(label,url,mtime) =
(SELECT printf('Check-in [%%.16s] on %%s',blob.uuid,
datetime(event.mtime)),
printf('/timeline?y=ci&c=%%.20s',blob.uuid),
event.mtime
FROM event, blob
WHERE event ...
|
|
Built-In Scalar SQL Functions
(lang_corefunc.html)
... The %z format
is interchangeable with %s. If there are too few arguments in the argument list,
missing arguments are assumed to have a NULL value, which is translated into
0 or 0.0 for numeric formats or an empty ...
|
|
Custom Builds Of SQLite
(custombuild.html)
... However, highly tuned and specialized
applications may want or need to replace some of
SQLite's built-in system interfaces with alternative implementations
more suitable for the needs of the application. SQLite is designed
to be easily reconfigured at compile ...
|
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... But process A's view
of the database content is now obsolete because process B has
modified the database file after process A read from it. Hence
process A gets an SQLITE_BUSY_SNAPSHOT error.
(518) SQLITE_LOCKED_VTAB
The SQLITE_LOCKED_VTAB result code is ...
|
|
C API: Opening A New Database Connection
(c3ref/open.html)
sqlite3_open(), sqlite3_open16()
... Open the file "data.db" on fred's desktop on drive
C:. Note that the %20 escaping in this example is not strictly
necessary - space characters can be used literally
in URI filenames.
file:data.db?mode=ro&cache=private ...
|
Page generated by FTS5 in about 72.88 ms.