Small. Fast. Reliable.
Choose any three.
Choose any three.
|
CREATE VIEW
(lang_createview.html)
... You cannot DELETE, INSERT, or UPDATE a view. Views are read-only
in SQLite. However, in many cases you can use an
INSTEAD OF trigger on the view to accomplish
the same thing. Views are removed
with the DROP VIEW ...
|
|
Architecture of SQLite
(arch.html)
... where*.c handles code generation for WHERE clauses on
SELECT, UPDATE and DELETE statements. The files attach.c,
delete.c, insert.c, select.c,
trigger.c
update.c, and vacuum.c handle the code generation
for SQL statements with the ...
|
|
35% Faster Than The Filesystem
(fasterthanfs.html)
2. How These Measurements Are Made
... Measure write performance by adding the --update option. This causes
the blobs are overwritten in place with another random blob of
exactly the same size.
./kvtest run test1.db --count 100k --update
./kvtest run test1.dir --count 100k --update
./kvtest ...
|
|
C API: Determine If An SQL Statement Writes The Database
(c3ref/stmt_readonly.html)
sqlite3_stmt_readonly()
... For example, an UPDATE statement might have a WHERE clause that
makes it a no-op, but the sqlite3_stmt_readonly() result would still
be false. Similarly, a CREATE TABLE IF NOT EXISTS statement is a
read-only no-op if the ...
|
|
ALTER TABLE
(lang_altertable.html)
... Run an UPDATE statement to change the definition of table X
in the sqlite_schema table:
UPDATE sqlite_schema SET sql=... WHERE type='table' AND name='X';
Caution: Making a change to the sqlite_schema table like this will
render the database corrupt ...
|
|
CREATE TABLE
(lang_createtable.html)
... If an INSERT or UPDATE
statement attempts to modify the table content so that two or more rows
have identical primary key values, that is a constraint violation.
According to the SQL standard, PRIMARY KEY should always imply NOT NULL ...
|
|
The SQLite R*Tree Module
(rtree.html)
3.5. Reading And Writing At The Same Time
... UPDATE demo_index SET maxY=maxY+0.5 WHERE id=?1;
Then the UPDATE might fail with an SQLITE_LOCKED error. The reason is that
the initial query has not run to completion. It is remembering its place
in the middle of ...
|
|
ANALYZE
(lang_analyze.html)
... Statistics gathered by ANALYZE are not updated as
the content of the database changes. If the content of the database
changes significantly, or if the database schema changes, then one should
consider rerunning the ANALYZE command in order to update ...
|
|
ATTACH DATABASE
(lang_attach.html)
... But if the host computer crashes in the middle
of a COMMIT where two or more database files are updated,
some of those files might get the changes where others
might not.
There is a limit, set using sqlite3_limit() and ...
|
|
Features Of SQLite
(features.html)
... You'll avoid having to write and troubleshoot a parser, your data
will be more easily accessible and cross-platform, and your updates
will be transactional. (more...)
Website Database.
Because it requires no configuration and stores information in ordinary
disk ...
|
Page generated by FTS5 in about 141.01 ms.