Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Evaluate An SQL Statement
(c3ref/step.html)
... This is not considered a compatibility
break because any application that ever receives an SQLITE_MISUSE error
is broken by definition. The SQLITE_OMIT_AUTORESET compile-time option
can be used to restore the legacy behavior.
Goofy Interface Alert: In the legacy interface ...
|
|
SQLite Keywords
(lang_keywords.html)
... So to prevent your code from being broken by future enhancements, you should
normally quote any identifier that is an English language word, even if
you do not have to.
The list below shows all possible keywords used by any ...
|
|
Quality Management
(qmplan.html)
5.3. Repositories
The SQLite source is broken up into multiple repositories, each described
in a separate section below.
|
|
Atomic Commit In SQLite
(atomiccommit.html)
9.1. Broken Locking Implementations
... We have received reports of implementations of both
Windows network filesystems and NFS in which locking was
subtly broken. We can not verify these reports, but as
locking is difficult to get right on a network filesystem
we have no ...
|
|
Query Planning
(queryplanner.html)
1.6. Multi-Column Indices
... That case does not happen
in our sample data, but there is one case (fruit='Orange') where there
is a tie on the first column which must be broken by the second column.
Given the new multi-column Idx3 index ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... This is because fcntl() file locking is broken on many NFS implementations.
You should avoid putting SQLite database files on NFS if multiple
processes might try to access the file at the same time. On Windows,
Microsoft's documentation says ...
|
|
Write-Ahead Logging
(wal.html)
1. Overview
... WAL uses many fewer fsync() operations and is thus less vulnerable to
problems on systems where the fsync() system call is broken.
But there are also disadvantages:
All processes using a database must be on the same host computer;
WAL ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
2. WHERE Clause Analysis
... After all constraints have been shifted into the WHERE clause,
The WHERE clause is broken up into conjuncts (hereafter called
"terms"). In other words, the WHERE clause is broken up into pieces
separated from the others by an AND operator ...
|
|
How To Corrupt An SQLite Database File
(howtocorrupt.html)
2.1. Filesystems with broken or missing lock implementations
SQLite depends on the underlying filesystem to do locking as the
documentation says it will. But some filesystems contain bugs in their
locking logic such that the locks do not always behave as advertised.
This is especially true of network ...
|
|
SELECT
(lang_select.html)
... Rows are first sorted based on the results of
evaluating the left-most expression in the ORDER BY list, then ties are broken
by evaluating the second left-most expression and so on. The order in which
two rows for ...
|
Page generated by FTS5 in about 27.31 ms.