SQLite As An Application File Format
(appfileformat.html)
... But an SQLite database is not limited to a simple key/value structure
like a pile-of-files database. An SQLite database can have dozens
or hundreds or thousands of different tables, with dozens or
hundreds or thousands of fields ...
|
Many Small Queries Are Efficient In SQLite
(np1queryprob.html)
4. The Need For Over 200 SQL Statements Per Webpage
... 1 FROM tagxref WHERE tagid=5 AND tagtype>0 AND rid=blob.rid)
ORDER BY event.mtime DESC LIMIT 50;
-- SELECT value FROM config WHERE name='timeline-utc';
SELECT count(*) FROM timeline WHERE etype!='div';
SELECT min(timestamp) FROM ...
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... OffsetLimit
This opcode performs a commonly used computation associated with
LIMIT and OFFSET processing. r[P1] holds the limit counter. r[P3]
holds the offset counter. The opcode computes the combined value
of the LIMIT and ...
|
Command Line Shell For SQLite
(cli.html)
3. Special commands to sqlite3 (dot-commands)
... FILE TABLE Import data from FILE into TABLE
.indexes ?TABLE? Show names of indexes
.limit ?LIMIT? ?VAL? Display or change the value of an SQLITE_LIMIT
.lint OPTIONS Report potential schema issues.
.load FILE ?ENTRY? Load an extension library
.log FILE ...
|
Query Planning
(queryplanner.html)
3.3. Partial Sorting Using An Index (a.k.a. Block Sorting)
... If a LIMIT clause is present, it might be possible to avoid scanning
the entire table.
Because of these advantages, SQLite always tries to do a partial sort using an
index even if a complete sort by index is not ...
|
Write-Ahead Logging
(wal.html)
2.3. Performance Considerations
... By default, the checkpoint will be
run automatically by the same thread that does the COMMIT that pushes
the WAL over its size limit. This has the effect of causing most
COMMIT operations to be very fast but an occasional ...
|
Database File Format
(fileformat.html)
1.2. Pages
... Usually SQLite will
hit the maximum file size limit of the underlying filesystem or disk
hardware long before it hits its own internal size limit.
In common use, SQLite databases tend to range in size from a few kilobytes
to ...
|
Datatypes In SQLite
(datatype3.html)
3.1.1. Affinity Name Examples
... Note that numeric arguments
in parentheses that following the type name (ex: "VARCHAR(255)") are
ignored by SQLite - SQLite does not impose any length restrictions
(other than the large global SQLITE_MAX_LENGTH limit) on the length of
strings, BLOBs or numeric ...
|
How To Corrupt An SQLite Database File
(howtocorrupt.html)
8.5. Corruption following alternating writes from 3.6 and 3.7
SQLite version 3.7.0 introduced a number of new enhancements to
the SQLite database file format (such as but not limited to WAL).
The 3.7.0 release was a shake-out release for these new features.
We expected ...
|
SQLite Session Module C/C++ Interface
(session.html)
... Return An Upper-limit For The Size Of The Changesetsqlite3_int64 sqlite3session_changeset_size(sqlite3_session *pSession);
By default, this function always returns 0. For it to return
a useful result, the sqlite3_session object must have been configured
to enable this API using sqlite3session_object_config ...
|
Page generated by FTS5 in about 80.52 ms.