C API: Write Data Into A BLOB Incrementally
(c3ref/blob_write.html)
sqlite3_blob_write()
This function is used to write data into an open BLOB handle from a
caller-supplied buffer. N bytes of data are copied from the buffer Z
into the open BLOB, starting at offset iOffset.
On success, sqlite3_blob_write() returns SQLITE_OK ...
|
C API: Database Snapshot
(c3ref/snapshot.html)
struct sqlite3_snapshot
... In WAL mode, multiple database connections that are open on the
same database file can each be reading a different historical version
of the database file. When a database connection begins a read
transaction, that connection sees an unchanging copy ...
|
C API: Read Data From A BLOB Incrementally
(c3ref/blob_read.html)
sqlite3_blob_read()
This function is used to read data from an open BLOB handle into a
caller-supplied buffer. N bytes of data are copied into buffer Z
from the open BLOB, starting at offset iOffset.
If offset iOffset is less than ...
|
C API: Move a BLOB Handle to a New Row
(c3ref/blob_reopen.html)
sqlite3_blob_reopen()
... The database, table and column on which the blob handle is open
remain the same. Moving an existing BLOB handle to a new row is
faster than closing the existing handle and opening a new one.
The new row must ...
|
C API: Automatically Load Statically Linked Extensions
(c3ref/auto_extension.html)
sqlite3_auto_extension(), struct sqlite3_api_routines
... If any
xEntryPoint() returns an error, the sqlite3_open(), sqlite3_open16(),
or sqlite3_open_v2() call that provoked the xEntryPoint() will fail.
Calling sqlite3_auto_extension(X) with an entry point X that is already
on the list of automatic extensions is a harmless no-op ...
|
C API: OS Interface Object
(c3ref/vfs.html)
sqlite3_syscall_ptr(), struct sqlite3_vfs
... Or if sqlite3_open()
or sqlite3_open16() is used, then flags includes at least
SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE.
If xOpen() opens a file read-only then it sets *pOutFlags to
include SQLITE_OPEN_READONLY. Other bits in *pOutFlags may be set.
SQLite will also add one ...
|
High Reliability
(hirely.html)
... SQLite is open-source but it is not open-contribution.
All the code in SQLite is written by a small team of experts.
The project does not accept "pull requests" or patches from
anonymous passers-by on the internet.
The ...
|
How To Corrupt An SQLite Database File
(howtocorrupt.html)
2.6. Carrying an open database connection across a fork()
Do not open an SQLite database connection, then fork(), then try
to use that database connection in the child process. All kinds of
locking problems will result and you can easily end up with a corrupt
database. SQLite is not ...
|
C API: Initialize The SQLite Library
(c3ref/initialize.html)
sqlite3_initialize(), sqlite3_shutdown(), sqlite3_os_init(), sqlite3_os_end()
... For example, sqlite3_open()
calls sqlite3_initialize() so the SQLite library will be automatically
initialized when sqlite3_open() is called if it has not be initialized
already. However, if SQLite is compiled with the SQLITE_OMIT_AUTOINIT
compile-time option, then the automatic calls to ...
|
The SQLite OS Interface or "VFS"
(vfs.html)
4. VFS Implementations
... The sqlite3_file object represents an open file.
The xOpen method of sqlite3_vfs constructs an sqlite3_file
object when the file is opened. The sqlite3_file keeps track
of the state of the file while it is opened.
The sqlite3_io_methods object holds the ...
|
Page generated by FTS5 in about 135.68 ms.