Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Online Backup API.
(c3ref/backup_finish.html)
sqlite3_backup_init(), sqlite3_backup_step(), sqlite3_backup_finish(), sqlite3_backup_remaining(), sqlite3_backup_pagecount()
... If the source
database is modified by the using the same database connection as is used
by the backup operation, then the backup database is automatically
updated at the same time.
sqlite3_backup_finish()
When sqlite3_backup_step() has returned SQLITE_DONE, or when the ...
|
|
Long Term Support
(lts.html)
... make the content you store in SQLite today as
easily accessible to your grandchildren as it is to you.
Update on 2018-05-31:
Our goal of supporting SQLite long-term have apparently come to the
notice of the preservationist ...
|
|
INSERT
(lang_insert.html)
... See the separate UPSERT documentation for the additional trailing
syntax that can cause an INSERT to behave as an UPDATE if the INSERT would
otherwise violate a uniqueness constraint. The upsert clause is not
allowed on an "INSERT ... DEFAULT VALUES".
|
|
SQLite Keywords
(lang_keywords.html)
... RETURNING
RIGHT
ROLLBACK
ROW
ROWS
SAVEPOINT
SELECT
SET
TABLE
TEMP
TEMPORARY
THEN
TIES
TO
TRANSACTION
TRIGGER
UNBOUNDED
UNION
UNIQUE
UPDATE
USING
VACUUM
VALUES
VIEW
VIRTUAL
WHEN
WHERE
WINDOW
WITH
WITHOUT
This page last modified on 2022-11-26 14:56 ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
6.2.2. External Content FTS4 Tables
... The same applies when a row is updated, as
internally an UPDATE is the same as a DELETE followed by an INSERT.
This means that in order to keep an FTS in sync with an external content
table, any UPDATE ...
|
|
Why SQLite Does Not Use Git
(whynotgit.html)
3.3. Fossil Access
... To change your checkout to a different version of Fossil use
the "update" command:
fossil update VERSION
Use "trunk" for VERSION to get the latest trunk version of SQLite.
Or use a prefix of a cryptographic hash name, or the ...
|
|
sqldiff.exe: Database Difference Utility
(sqldiff.html)
2. How It Works
... Any differences in the
content of paired rows are output as UPDATEs. Rows in the source
database that could not be paired are output as DELETEs. Rows in
the destination database that could not be paired are output as
INSERTs ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... The SQLITE_SCHEMA table cannot be modified using UPDATE, INSERT,
or DELETE (except under
extraordinary conditions).
The SQLITE_SCHEMA table is automatically updated by commands like
CREATE TABLE, CREATE INDEX, DROP TABLE, and DROP INDEX.
Temporary tables do not appear in the ...
|
|
Atomic Commit In SQLite
(atomiccommit.html)
5.4. Updating The Database Files
Once all rollback journal files have been flushed to disk, it
is safe to begin updating database files. We have to obtain an
exclusive lock on all database files before writing the changes.
After all the changes are written, it ...
|
|
C API: Virtual Table Indexing Information
(c3ref/index_info.html)
struct sqlite3_index_info, struct sqlite3_index_constraint, struct sqlite3_index_orderby ...
... Additionally, if xBestIndex sets the SQLITE_INDEX_SCAN_UNIQUE flag, then
SQLite also assumes that if a call to the xUpdate() method is made as
part of the same statement to delete or update a virtual table row and the
implementation returns SQLITE_CONSTRAINT ...
|
Page generated by FTS5 in about 134.20 ms.