Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Memory Allocation Subsystem
(c3ref/free.html)
sqlite3_malloc(), sqlite3_malloc64(), sqlite3_realloc(), sqlite3_realloc64(), sqlite3_free(), sqlite3_msize()
... The pointer arguments to sqlite3_free() and sqlite3_realloc()
must be either NULL or else pointers obtained from a prior
invocation of sqlite3_malloc() or sqlite3_realloc() that have
not yet been released.
The application must not read or write any part of
a ...
|
|
C API: Evaluate An SQL Statement
(c3ref/step.html)
... 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 ...
|
|
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 ...
|
|
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 ...
|
|
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 ...
|
|
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 ...
|
|
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 ...
|
Page generated by FTS5 in about 630.75 ms.