SQLite Pro Support
(prosupport.html)
... SQLite developers
can run TH3 on specialized hardware and/or using specialized
compile-time options, according to customer specification,
either remotely or on customer premises. Pricing for this
services is on a case-by-case basis depending on requirements.
call ...
|
VACUUM
(lang_vacuum.html)
... However, when not in write-ahead log mode, the
page_size and/or auto_vacuum properties of an existing database may be
changed by using the page_size and/or
pragma auto_vacuum pragmas and then immediately VACUUMing
the database. When in write-ahead ...
|
C API: Error Codes And Messages
(c3ref/errcode.html)
sqlite3_errcode(), sqlite3_extended_errcode(), sqlite3_errmsg(), sqlite3_errmsg16(), sqlite3_errstr(), sqlite3_error_offset()
... The values returned by sqlite3_errcode() and/or
sqlite3_extended_errcode() might change with each API call.
Except, there are some interfaces that are guaranteed to never
change the value of the error code. The error-code preserving
interfaces include the following:
sqlite3_errcode ...
|
C API: Impose A Limit On Heap Size
(c3ref/hard_heap_limit64.html)
sqlite3_soft_heap_limit64(), sqlite3_hard_heap_limit64()
... The sqlite3_soft_heap_limit64() interface sets and/or queries the
soft limit on the amount of heap memory that may be allocated by SQLite.
SQLite strives to keep heap memory utilization below the soft heap
limit by reducing the number of pages ...
|
Appropriate Uses For SQLite
(whentouse.html)
1. Situations Where SQLite Works Well
... An SQLite database facilitates data transfer between systems even
when the endpoints have different word sizes and/or byte orders.
The data can be a complex mix of large binary blobs, text, and small
numeric or boolean values. The data ...
|
C API: One-Step Query Execution Interface
(c3ref/exec.html)
sqlite3_exec()
... If the 2nd parameter to sqlite3_exec() is a NULL pointer, a pointer
to an empty string, or a pointer that contains only whitespace and/or
SQL comments, then no SQL statements are evaluated and the database
is not changed.
Restrictions ...
|
CREATE INDEX
(lang_createindex.html)
... name of a previously
created table that is to be indexed, and a parenthesized list of table column
names and/or expressions that are used for the index key.
If the optional WHERE clause is included, then the index is ...
|
INSERT
(lang_insert.html)
... Any SELECT statement, including
compound SELECTs and SELECT statements with ORDER BY and/or LIMIT clauses,
may be used in an INSERT statement of this form.
To avoid a parsing ambiguity, the SELECT statement should always
contain a WHERE clause ...
|
Why SQLite Does Not Use Git
(whynotgit.html)
2.3. The mental model for Git is needlessly complex
... The working directory
The "index" or staging area
The local head
The local copy of the remote head
The actual remote head
Git has commands (and/or options on commands) for moving and
comparing content between all of these locations ...
|
Run-Time Loadable Extensions
(loadext.html)
5. Persistent Loadable Extensions
... To persistently load and register an extension that implements new SQL
functions, collating sequences, and/or virtual tables, such that those
added capabilities are available to all subsequent database connections,
then the initialization routine should also invoke sqlite3_auto_extension()
on a ...
|
Page generated by FTS5 in about 165.54 ms.