Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Evaluate An SQL Statement
(c3ref/step.html)
sqlite3_step()
... If you prepare all of your SQL statements
using sqlite3_prepare_v3() or sqlite3_prepare_v2()
or sqlite3_prepare16_v2() or sqlite3_prepare16_v3() instead
of the legacy sqlite3_prepare() and sqlite3_prepare16() interfaces,
then the more specific error codes are returned directly
by sqlite3_step(). The use of the "vX ...
|
|
ALTER TABLE
(lang_altertable.html)
... The column name is changed both
within the table definition itself and also within all indexes, triggers,
and views that reference the column. If the column name change would
result in a semantic ambiguity in a trigger or view, then ...
|
|
The generate_series Table-Valued Function
(series.html)
1. Overview
... The START parameter is required
as of version 3.37.0 (2021-11-27) and later and an error will
be raised if START is omitted or has a self-referential or otherwise
uncomputable value. Older versions used a default ...
|
|
Why SQLite Does Not Use Git
(whynotgit.html)
2.5. Git requires more administrative support
... That one binary contains all
the functionality of core Git and also GitHub and/or GitLab. It
manages a community server with wiki, bug tracking, and forums,
provides packaged downloads for consumers, login managements,
and so forth, with no extra ...
|
|
Transaction
(lang_transaction.html)
... Such transactions usually persist until the next
COMMIT or ROLLBACK command. But a transaction will also
ROLLBACK if the database is closed or if an error occurs
and the ROLLBACK conflict resolution algorithm is specified.
See the documentation on the ...
|
|
SQLite Session Module C/C++ Interface
(session.html)
... If an error occurs, set both *ppChangeset and *pnChangeset to
zero and return an SQLite error code.
A changeset consists of zero or more INSERT, UPDATE and/or DELETE changes,
each representing a change to a single row of an ...
|
|
C API: Translate filenames
(c3ref/filename_database.html)
sqlite3_filename_database(), sqlite3_filename_journal(), sqlite3_filename_wal()
These routines are available to custom VFS implementations for
translating filenames between the main database file, the journal file,
and the WAL file.
If F is the name of an sqlite database file, journal file, or WAL file
passed by ...
|
|
Write-Ahead Logging
(wal.html)
2.3. Performance Considerations
... If that effect is undesirable, then
the application can disable automatic checkpointing and run the
periodic checkpoints in a separate thread, or separate process.
(Links to commands and interfaces to accomplish this are
shown below.)
Note that with PRAGMA synchronous ...
|
|
C API: Binding Values To Prepared Statements
(c3ref/bind_blob.html)
sqlite3_bind_blob(), sqlite3_bind_blob64(), sqlite3_bind_double(), sqlite3_bind_int(), sqlite3_bind_int64(), sqlite3_bind_null ...
... The NNN value must be between 1 and the sqlite3_limit()
parameter SQLITE_LIMIT_VARIABLE_NUMBER (default value: 32766).
The third argument is the value to bind to the parameter.
If the third parameter to sqlite3_bind_text() or sqlite3_bind_text16()
or sqlite3_bind_blob() is a NULL pointer ...
|
|
C API: Count The Number Of Rows Modified
(c3ref/changes.html)
sqlite3_changes(), sqlite3_changes64()
... The two functions are identical except for the type of the return value
and that if the number of rows modified by the most recent INSERT, UPDATE
or DELETE is greater than the maximum value supported by type "int", then ...
|
Page generated by FTS5 in about 302.09 ms.