Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Full-Featured SQL
(fullsql.html)
... ACID transactions using BEGIN, COMMIT, and ROLLBACK
Nested transactions using SAVEPOINT, RELEASE, and
ROLLBACK TO
Subqueries, including correlated subqueries
Up to 64-way joins
LEFT, RIGHT, and FULL OUTER JOINs
DISTINCT, ORDER BY, GROUP BY, HAVING, LIMIT, and OFFSET
UNION ...
|
|
sqldiff.exe: Database Difference Utility
(sqldiff.html)
3. Limitations
... See session limitations for details.
The sqldiff.exe utility does not (currently) display differences in
TRIGGERs or VIEWs.
The sqldiff utility is not designed to support schema migrations
and is forgiving with respect to differing column definitions.
Normally, only the ...
|
|
C API: Retrieving Statement SQL
(c3ref/expanded_sql.html)
sqlite3_sql(), sqlite3_expanded_sql(), sqlite3_normalized_sql()
... The SQLITE_TRACE_SIZE_LIMIT compile-time option limits the size of
bound parameter expansions. The SQLITE_OMIT_TRACE compile-time
option causes sqlite3_expanded_sql() to always return NULL.
The strings returned by sqlite3_sql(P) and sqlite3_normalized_sql(P)
are managed by SQLite and are automatically freed ...
|
|
C API: Prepare Flags
(c3ref/c_prepare_dont_log.html)
SQLITE_PREPARE_PERSISTENT, SQLITE_PREPARE_NORMALIZE, SQLITE_PREPARE_NO_VTAB, SQLITE_PREPARE_DONT_LOG
... The current implementation acts
on this hint by avoiding the use of lookaside memory so as not to
deplete the limited store of lookaside memory. Future versions of
SQLite may act on this hint differently.
SQLITE_PREPARE_NORMALIZE
The SQLITE_PREPARE_NORMALIZE flag is ...
|
|
C API: Deserialize a database
(c3ref/deserialize.html)
sqlite3_deserialize()
... sqlite3_deserialize(D,S,P,N,M,F) to force the
database file into rollback mode and work around this limitation.
If sqlite3_deserialize(D,S,P,N,M,F) fails for any reason and if the
SQLITE_DESERIALIZE_FREEONCLOSE bit is set in ...
|
|
C API: Standard File Control Opcodes
(c3ref/c_fcntl_begin_atomic_write.html)
SQLITE_FCNTL_LOCKSTATE, SQLITE_FCNTL_GET_LOCKPROXYFILE, SQLITE_FCNTL_SET_LOCKPROXYFILE, SQLITE_FCNTL_LAST_ERRNO, SQLITE_FCNTL_SIZE_HINT, SQLITE_FCNTL_CHUNK_SIZE ...
... If the integer pointed to is negative, then it is filled in with the
current limit. Otherwise the limit is set to the larger of the value
of the integer pointed to and the current database size. The integer
pointed ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... SELECT name FROM
(SELECT * FROM sqlite_schema UNION ALL
SELECT * FROM sqlite_temp_schema)
WHERE type='table'
ORDER BY name
(8) Are there any known size limits to SQLite databases?
See limits.html for a full discussion of
the limits of SQLite.
(9 ...
|
|
The COMPLETION() Table-Valued Function
(completion.html)
3. Limitations
The completion table is designed for interactive use. It will return
answers at a speed appropriate for human typing. No effort is made to
be unusually efficient, so long as the response time is nearly instantaneous
in a user interface ...
|
|
C API: Database Connection Client Data
(c3ref/get_clientdata.html)
sqlite3_get_clientdata(), sqlite3_set_clientdata()
... There is no limit (other than available memory) on the number of different
client data pointers (with different names) that can be attached to a
single database connection. However, the implementation is optimized
for the case of having only one ...
|
|
Features Of SQLite
(features.html)
... Supports terabyte-sized databases and gigabyte-sized strings
and blobs. (See limits.html.)
Small code footprint:
less than 750KiB fully configured or much less
with optional features omitted.
Simple, easy to use API.
Fast: In some cases, SQLite is
faster ...
|
Page generated by FTS5 in about 129.43 ms.