Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Keywords
(lang_keywords.html)
... SQLite adds new keywords from time to time when it takes on new features.
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 ...
|
|
C API: OS Interface File Virtual Methods Object
(c3ref/io_methods.html)
struct sqlite3_io_methods
... The flags argument to xSync may be one of SQLITE_SYNC_NORMAL or
SQLITE_SYNC_FULL. The first choice is the normal fsync().
The second choice is a Mac OS X style fullsync. The SQLITE_SYNC_DATAONLY
flag may be ORed in to indicate that only ...
|
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... The SQLITE_LOCKED result code differs from SQLITE_BUSY in that
SQLITE_LOCKED indicates a conflict on the same database connection
(or on a connection with a shared cache) whereas SQLITE_BUSY indicates
a conflict with a different database connection, probably in a different ...
|
|
Distinctive Features Of SQLite
(different.html)
... SQLite also provides statements such as
REPLACE and the
ON CONFLICT clause that allow for
added control over the resolution of constraint conflicts.
SQLite supports ATTACH and
DETACH commands that allow multiple
independent databases to be used together in the ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.7. The copy method
... dbcmd copy conflict-algorithm
table-name file-name
?column-separator?
?null-indicator?
Conflict-algorithm must be one of the SQLite conflict algorithms for
the ...
|
|
The RBU Extension
(rbu.html)
... The target database may not contain indexes on expressions.
Indexes on expressions are supported beginning with SQLite 3.30.0
(2019-10-04).
No other writes may occur on the target database while the
RBU update is being applied. A ...
|
|
STRICT Tables
(stricttables.html)
2. STRICT Tables
... ON CONFLICT clauses work the same.
Indexes work the same.
AUTOINCREMENT works the same.
An INTEGER PRIMARY KEY column is an alias for the rowid, but an
INT PRIMARY KEY column is not.
The on-disk format for the table ...
|
|
Run-Time Loadable Extensions
(loadext.html)
4. Programming Loadable Extensions
... Put the macro "SQLITE_EXTENSION_INIT1" on a line by itself
right after the "#include <sqlite3ext.h>" line.
Add an extension loading entry point routine that looks like
something the following:
#ifdef _WIN32
__declspec(dllexport)
#endif
int sqlite3_extension_init( /* <== Change ...
|
|
SQLite Consortium Agreement
(consortium_agreement-20071201.html)
... constitute
one and the same agreement.
8.7 Governing Law.
This Agreement will be interpreted and construed in
accordance with the laws of the State of North Carolina
and the United States of America, without regard to
conflict of law ...
|
|
Temporary Files Used By SQLite
(tempfiles.html)
2.5. Statement Journal Files
... are no other active statements on the same database connection then
no statement journal is created since the ordinary
rollback journal can be used instead.
The statement journal is also omitted if an alternative
conflict resolution algorithm is
used. For ...
|
Page generated by FTS5 in about 48.74 ms.