C API: OS Interface Open File Handle
(c3ref/file.html)
struct sqlite3_file
An sqlite3_file object represents an open file in the
OS interface layer. Individual OS interface
implementations will
want to subclass this object by appending additional fields
for their own use. The pMethods entry is a pointer to an
sqlite3_io_methods object ...
|
C API: A Handle To An Open BLOB
(c3ref/blob.html)
struct sqlite3_blob
An instance of this object represents an open BLOB on which
incremental BLOB I/O can be performed.
Objects of this type are created by sqlite3_blob_open()
and destroyed by sqlite3_blob_close().
The sqlite3_blob_read() and sqlite3_blob_write() interfaces
can be used to read ...
|
C API: Return The Size Of An Open BLOB
(c3ref/blob_bytes.html)
sqlite3_blob_bytes()
Returns the size in bytes of the BLOB accessible via the
successfully opened BLOB handle in its only argument. The
incremental blob I/O routines can only read or overwriting existing
blob content; they cannot change the size of a ...
|
C API: Flags For File Open Operations
(c3ref/c_open_autoproxy.html)
sqlite3_open_v2(), SQLITE_OPEN_READONLY, SQLITE_OPEN_READWRITE, SQLITE_OPEN_CREATE, SQLITE_OPEN_DELETEONCLOSE, SQLITE_OPEN_EXCLUSIVE ...
... Note in particular that passing the SQLITE_OPEN_EXCLUSIVE flag into
sqlite3_open_v2() does *not* cause the underlying database file
to be opened using O_EXCL. Passing SQLITE_OPEN_EXCLUSIVE into
sqlite3_open_v2() has historically be a no-op and might become an
error in future versions ...
|
C API: Open A BLOB For Incremental I/O
(c3ref/blob_open.html)
sqlite3_blob_open()
This interfaces opens a handle to the BLOB located
in row iRow, column zColumn, table zTable in database zDb;
in other words, the same BLOB that would be selected by:
SELECT zColumn FROM zDb.zTable WHERE rowid = iRow;
Parameter zDb ...
|
C API: Opening A New Database Connection
(c3ref/open.html)
sqlite3_open(), sqlite3_open16()
These routines open an SQLite database file as specified by the
filename argument. The filename argument is interpreted as UTF-8 for
sqlite3_open() and sqlite3_open_v2() and as UTF-16 in the native byte
order for sqlite3_open16(). A database connection handle ...
|
In-Memory Databases
(inmemorydb.html)
... In other words, instead of passing the name of
a real disk file into one of the sqlite3_open(), sqlite3_open16(), or
sqlite3_open_v2() functions, pass in the string ":memory:". For
example:
rc = sqlite3_open(":memory:", &db);
When this is done, no disk ...
|
C API: Record A Database Snapshot
(c3ref/snapshot_get.html)
sqlite3_snapshot_get()
... If there is not already a read-transaction open on schema S when
this function is called, one is opened automatically.
If a read-transaction is opened by this function, then it is guaranteed
that the returned snapshot object may ...
|
Swarmvtab Virtual Table
(swarmvtab.html)
3.3. The "openclose" Callback
The "openclose" parameter allows the user to specify the name of a
application-defined SQL function that will be invoked just before
swarmvtab opens a database, and again just after it closes one. The first
argument passed to the open ...
|
C API: Close A BLOB Handle
(c3ref/blob_close.html)
sqlite3_blob_close()
This function closes an open BLOB handle. The BLOB handle is closed
unconditionally. Even if this routine returns an error code, the
handle is still closed.
If the blob handle being closed was opened for read-write access, and if ...
|
Page generated by FTS5 in about 139.43 ms.