Features Of SQLite
(features.html)
Features Of SQLite
Transactions
are atomic, consistent, isolated, and durable (ACID)
even after system crashes and power failures.
Zero-configuration
- no setup or administration needed.
Full-featured SQL implementation
with advanced capabilities like partial indexes,
indexes on expressions, JSON,
common ...
|
SQLite FTS5 Extension
(fts5.html)
3.7. FTS5 Boolean Operators
... MATCH 'one two three' -- 'one AND two AND three'
... MATCH 'three "one two"' -- 'three AND "one two"'
... MATCH 'NEAR(one two) three' -- 'NEAR(one two) AND three'
... MATCH 'one OR two three' -- 'one OR two AND three'
... MATCH 'one NOT ...
|
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 ...
|
How To Compile SQLite
(howtocompile.html)
2. Compiling The Command-Line Interface
... To build the CLI, simply put these three files in the same directory
and compile them together. Using MSVC:
cl shell.c sqlite3.c -Fesqlite3.exe
On Unix systems (or on Windows using cygwin or mingw+msys)
the command typically ...
|
Version Numbers in SQLite
(versionnumbers.html)
1.2. The Historical Numbering System (Before 2015-10-14)
... The minor version number Y was historically incremented for new
features and/or new interfaces that did not significantly change
the structure of the code. The addition of common table expressions,
partial indexes, and indexes on expressions are all examples ...
|
C API: Memory Allocation Routines
(c3ref/mem_methods.html)
struct sqlite3_mem_methods
... A pointer to an instance of this object is the argument to
sqlite3_config() when the configuration option is
SQLITE_CONFIG_MALLOC or SQLITE_CONFIG_GETMALLOC.
By creating an instance of this object
and passing it to sqlite3_config(SQLITE_CONFIG_MALLOC)
during configuration, an application can specify ...
|
Using SQLite In Multi-Threaded Applications
(threadsafe.html)
4. Run-time selection of threading mode
... The
SQLITE_OPEN_NOMUTEX flag causes the database connection to be in the
multi-thread mode and the SQLITE_OPEN_FULLMUTEX flag causes the connection
to be in serialized mode. If neither flag is specified or if
sqlite3_open() or sqlite3_open16() are used instead of ...
|
C API: Prepared Statement Scan Status
(c3ref/stmt_scanstatus.html)
sqlite3_stmt_scanstatus(), sqlite3_stmt_scanstatus_v2()
These interfaces return information about the predicted and measured
performance for pStmt. Advanced applications can use this
interface to compare the predicted and the measured performance and
issue warnings and/or rerun ANALYZE if discrepancies are found.
Since this interface ...
|
Datatypes In SQLite version 2
(datatypes.html)
... But some notion of type comes into play
when sorting and comparing data. For these purposes, a column or
an expression can be one of two types: numeric and text.
The sort or comparison may give different results depending on ...
|
The SQLite Bytecode Engine
(opcode.html)
2.2. Instruction Format
A bytecoded program in SQLite consists of one or more instructions.
Each instruction has an opcode and
five operands named P1, P2 P3, P4, and P5. The P1, P2, and P3
operands are 32-bit signed integers. These operands often ...
|
Page generated by FTS5 in about 310.92 ms.