Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Invalid UTF Policy
(invalidutf.html)
... Or, suppose you are doing everything using UTF-8 (the most common case).
Invalid UTF-8 will normally pass through the database without any change
in its byte sequence. However, if you try to transform the invalid
UTF-8 with ...
|
|
Compile-time Options
(compile.html)
9. Options To Omit Features
... Executing a VACUUM statement causes
a parse error.
SQLITE_OMIT_VIEW
Defining this option omits support for VIEW objects. Neither the
CREATE VIEW nor the DROP VIEW
commands are available in this case, and
attempting to execute either will result in a ...
|
|
SQLite Changes From Version 3.5.9 To 3.6.0
(35to36.html)
... The column names for the result sets of SELECT statements have
been tweaked in some cases to work more like other SQL database
engines.
Changes to compile-time options:
The SQLITE_MUTEX_APPDEF compile-time parameter is no longer
recognized. As a ...
|
|
C API: Online Backup API.
(c3ref/backup_finish.html)
sqlite3_backup_init(), sqlite3_backup_step(), sqlite3_backup_finish(), sqlite3_backup_remaining(), sqlite3_backup_pagecount()
... In this case the call to
sqlite3_backup_step() can be retried later. If the source
database connection
is being used to write to the source database when sqlite3_backup_step()
is called, then SQLITE_LOCKED is returned immediately. Again, in this
case the call ...
|
|
File Locking And Concurrency In SQLite Version 3
(lockingv3.html)
... After a BEGIN command, a SHARED lock will be acquired when the first
SELECT statement is executed. A RESERVED lock will be acquired when
the first INSERT, UPDATE, or DELETE statement is executed. No EXCLUSIVE
lock is acquired until either ...
|
|
Memory-Mapped I/O
(mmap.html)
... In fact,
it is possible to construct test cases where performance is reduced
by the use of memory-mapped I/O.
Windows is unable to truncate a memory-mapped file. Hence, on Windows,
if an operation such as VACUUM or ...
|
|
Database File Format
(fileformat.html)
2.2. Record Sort Order
... Alternative collating functions for table columns can be specified in the
CREATE TABLE statement using the COLLATE clause on the column definition.
When a column is indexed, the same collating function specified in the
CREATE TABLE statement is used for ...
|
|
SQLite As An Application File Format
(appfileformat.html)
... In either case, if performance problems do arise in an SQLite application
those problems can often be resolved by adding one or two CREATE INDEX
statements to the schema or perhaps running ANALYZE one time
and without having to touch ...
|
|
Application-Defined SQL Functions
(appfunc.html)
... Except, sqlite3_aggregate_context() might return NULL in the case of
an out-of-memory error, so aggregate functions should be prepared to
deal with that case.
After all rows are processed the countFinalize() routine is called
exactly once. This routine computes ...
|
|
The Session Extension
(sessionintro.html)
3.1. Capturing a Changeset
... Changes are made to the database by executing SQL statements. The
session object records these changes.
A changeset blob is extracted from the session object using a call
to sqlite3session_changeset() (or, if using patchsets, a call to
the sqlite3session_patchset() function ...
|
Page generated by FTS5 in about 153.45 ms.