SQLite Frequently Asked Questions
(faq.html)
... If what they
say is true, sharing an SQLite database between two or more Windows
machines might cause unexpected problems.
We are aware of no other embedded SQL database engine that
supports as much concurrency as SQLite. SQLite allows multiple ...
|
Window Functions
(windowfunctions.html)
2.3. The FILTER Clause
... show
If a FILTER clause is provided, then only rows for which the expr is
true are included in the window frame. The aggregate window still returns a
value for every row, but those for which the FILTER expression evaluates ...
|
DELETE
(lang_delete.html)
... If a WHERE clause is supplied, then only those rows for which the
WHERE clause boolean expression is true are deleted.
Rows for which the expression is false or NULL are retained.
2. Restrictions on DELETE Statements Within CREATE TRIGGER ...
|
Isolation In SQLite
(isolation.html)
... This is true regardless of whether the two database connections are in
the same thread, in different threads of the same process, or in
different processes. This
is the usual and expected behavior for SQL database systems.
The previous paragraph ...
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... A NULL and true or two NULLs give
a NULL output.
AutoCommit
Set the database auto-commit flag to P1 (1 or 0). If P2 is true, roll
back any currently active btree transactions. If there are any active
VMs ...
|
The Checksum VFS Shim
(cksumvfs.html)
6. Controlling Checksum Verification
... PRAGMA checksum_verification; -- query status
PRAGMA checksum_verification=OFF; -- disable verification
PRAGMA checksum_verification=ON; -- re-enable verification
The "checksum_verification" pragma will return "1" (true) or "0"
(false) if checksum verification is enabled or disabled, respectively.
"Verification" in this context means the feature ...
|
VACUUM
(lang_vacuum.html)
... URL filenames are enabled if any of the following are true:
The SQLite library was compiled with -DSQLITE_USE_URI=1.
The sqlite3_config(SQLITE_CONFIG_URI,1) interfaces was
invoked at start-time.
The database connection that is running the VACUUM INTO
statement was ...
|
SQLite Autoincrement
(autoinc.html)
1. Summary
... This is true regardless of whether or not the AUTOINCREMENT keyword is used.
If the AUTOINCREMENT keyword appears after INTEGER PRIMARY KEY, that
changes the automatic ROWID assignment algorithm to prevent
the reuse of ROWIDs over the lifetime of the ...
|
Compile-time Options
(compile.html)
3. Platform Configuration
... HAVE_GMTIME_R
If the HAVE_GMTIME_R option is true and if SQLITE_OMIT_DATETIME_FUNCS is true,
then the CURRENT_TIME, CURRENT_DATE, and CURRENT_TIMESTAMP keywords will use
the threadsafe "gmtime_r()" interface rather than "gmtime()". In the usual case
where SQLITE_OMIT_DATETIME_FUNCS is not defined or is false ...
|
Why Is SQLite Coded In C
(whyc.html)
1.2. Compatibility
... This is not true of other implementation languages.
So, for example, Android applications written in Java are able to
invoke SQLite (through an adaptor). Maybe it would have been more
convenient for Android if SQLite had been coded in Java ...
|
Page generated by FTS5 in about 72.70 ms.