Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The UINT Collating Sequence
(uintcseq.html)
1. Overview
... Comparison
is not limited to integers that can be expressed as a
64-bit machine integer.
|
|
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: 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 ...
|
|
Floating Point Numbers
(floatingpoint.html)
1. How SQLite Stores Numbers
... This is not an SQLite limitation.
It is a mathematical limitation inherent in the design of floating-point numbers.
—¹
Exception: The R-Tree extension stores information as 32-bit floating
point or integer values.
|
|
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 81.87 ms.