sqlite3_limit()

This interface allows the size of various constructs to be limited on a connection by connection basis. The first parameter is the database connection whose limit is to be set or queried. The second parameter is one of the limit ... 

sqlite3_soft_heap_limit()

This is a deprecated version of the sqlite3_soft_heap_limit64() interface. This routine is provided for historical compatibility only. All new applications should use the sqlite3_soft_heap_limit64() interface rather than this one. See also lists of Objects, Constants, and Functions.

sqlite3_soft_heap_limit64(), sqlite3_hard_heap_limit64()

These interfaces impose limits on the amount of heap memory that will be by all database connections within a single process. The sqlite3_soft_heap_limit64() interface sets and/or queries the soft limit on the amount of heap memory that may be ... 

SQLITE_LIMIT_LENGTH, SQLITE_LIMIT_SQL_LENGTH, SQLITE_LIMIT_COLUMN, SQLITE_LIMIT_EXPR_DEPTH, SQLITE_LIMIT_COMPOUND_SELECT, SQLITE_LIMIT_VDBE_OP ... 

These constants define various performance limits that can be lowered at run-time using sqlite3_limit(). The synopsis of the meanings of the various limits is shown below. Additional information is available at Limits in SQLite. SQLITE_LIMIT_LENGTH The maximum size of ... 

Limits In SQLite "Limits" in the context of this article means sizes or quantities that can not be exceeded. We are concerned with things like the maximum number of bytes in a BLOB or the maximum number of columns in ... 

 ... If the result of the evaluating the LIMIT clause cannot be losslessly converted to an integer value, it is an error. A negative LIMIT value is interpreted as "no limit". If the DELETE statement also has an OFFSET clause, then ... 

1.1. Untrusted SQL Inputs  ... options, or at run-time using the sqlite3_limit() interface. Most applications can reduce limits dramatically without impacting functionality. The table below provides some suggestions, though exact values will vary depending on the application: Limit SettingDefault ValueHigh-security Value LIMIT_LENGTH1,000 ... 

 ... A negative value is interpreted as "no limit". If the LIMIT expression evaluates to non-negative value N and the UPDATE statement has an ORDER BY clause, then all rows that would be updated in the absence of the LIMIT ... 

 ... table-stmt create-trigger-stmt create-view-stmt create-virtual-table-stmt cte-table-name delete-stmt delete-stmt-limited detach-stmt drop-index-stmt drop-table-stmt drop-trigger-stmt drop-view-stmt expr factored-select-stmt filter-clause ... 

 ... The details of the effects of the analysis limit described in the previous paragraph are subject to change in future versions of SQLite. But the core idea will remain the same. An analysis limit of N will strive to limit ...