Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Defense Against The Dark Arts
(security.html)
1.1. Untrusted SQL Inputs
... For example, an application
that does not need to change the database schema might add an
sqlite3_set_authorizer() callback that causes any CREATE or DROP
statement to fail.
The SQL language is very powerful, and so it is always possible for ...
|
|
Transaction
(lang_transaction.html)
... A read transaction is started
by a SELECT statement, and a write transaction is started by
statements like CREATE, DELETE, DROP, INSERT, or UPDATE (collectively
"write statements"). If a write statement occurs while
a read transaction is active, then the ...
|
|
The DBSTAT Virtual Table
(dbstat.html)
4. Example uses of the dbstat virtual table
... BY path;
SELECT sum(s1.pageno+1==s2.pageno)*1.0/count(*)
FROM s AS s1, s AS s2
WHERE s1.rowid+1=s2.rowid;
DROP TABLE s;
This page last modified on 2025-04-16 13:13:29 UTC
|
|
Partial Indexes
(partialindex.html)
4. Supported Versions
... A database that is unreadable
by legacy versions of SQLite can be made readable simply by running
DROP INDEX on the partial indexes.
This page last modified on 2022-04-18 02:55:50 UTC
|
|
How To Compile SQLite
(howtocompile.html)
2. Amalgamation Versus Individual Source Files
... Everything is contained
within a single code file, so it is easy to drop into the source tree
of a larger C or C++ program. All the code generation and transformation
steps have already been carried out so there are ...
|
|
The RBU Extension
(rbu.html)
2.1. RBU Update Limitations
... CREATE and DROP operations are not
supported.
INSERT statements may not use default values.
UPDATE and DELETE statements must identify the target rows
by rowid or by non-NULL PRIMARY KEY values.
UPDATE statements may not modify PRIMARY KEY or ...
|
|
ANALYZE
(lang_analyze.html)
... The DROP TABLE command works on statistics tables
as of SQLite version 3.7.9. (2011-11-01)
The ALTER TABLE command does not work on statistics tables.
Appropriate care should be used when changing the content of the statistics ...
|
|
Query Planning
(queryplanner.html)
2.3. Sorting By Covering Index
If a covering index can be used for a query, then the multiple rowid lookups
can be avoided and the cost of the query drops dramatically.
Figure 19: Sorting With A Covering Index
With a covering index, SQLite can simply ...
|
|
Database File Format
(fileformat.html)
2.6.3. The sqlite_sequence table
... Once created, the sqlite_sequence table exists in the
sqlite_schema table forever; it cannot be dropped.
The schema for the sqlite_sequence table is:
CREATE TABLE sqlite_sequence(name,seq);
There is a single row in the sqlite_sequence table for each ordinary
table ...
|
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... For example, a DROP TABLE statement cannot be run while another thread
is reading from that table on the same database connection because
dropping the table would delete the table out from under the concurrent
reader.
The SQLITE_LOCKED result code ...
|
Page generated by FTS5 in about 77.86 ms.