Updated: 2022/Sep/29

Please read Privacy Policy. It's for your privacy.

SQLITE3_LIMIT(3)           Library Functions Manual           SQLITE3_LIMIT(3)

NAME
     sqlite3_limit - run-time limits

SYNOPSIS
     #include <sqlite3.h>

     int
     sqlite3_limit(sqlite3*, int id, int newVal);

DESCRIPTION
     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 categories that define a class of constructs to be size
     limited.  The third parameter is the new limit for that construct.

     If the new limit is a negative number, the limit is unchanged.  For each
     limit category SQLITE_LIMIT_NAME there is a hard upper bound set at
     compile-time by a C preprocessor macro called SQLITE_MAX_<i>NAME</i>.
     (The "_LIMIT_" in the name is changed to "_MAX_".) Attempts to increase a
     limit above its hard upper bound are silently truncated to the hard upper
     bound.

     Regardless of whether or not the limit was changed, the sqlite3_limit()
     interface returns the prior value of the limit.  Hence, to find the
     current value of a limit without changing it, simply invoke this
     interface with the third parameter set to -1.

     Run-time limits are intended for use in applications that manage both
     their own internal database and also databases that are controlled by
     untrusted external sources.  An example application might be a web
     browser that has its own databases for storing history and separate
     databases controlled by JavaScript applications downloaded off the
     Internet.  The internal databases can be given the large, default limits.
     Databases managed by external sources can be given much smaller limits
     designed to prevent a denial of service attack.  Developers might also
     want to use the sqlite3_set_authorizer() interface to further control
     untrusted SQL.  The size of the database created by an untrusted script
     can be contained using the max_page_count PRAGMA.

     New run-time limit categories may be added in future releases.

IMPLEMENTATION NOTES
     These declarations were extracted from the interface documentation at
     line 4023.

     SQLITE_API int sqlite3_limit(sqlite3*, int id, int newVal);

SEE ALSO
     sqlite3(3), sqlite3_set_authorizer(3)

NetBSD 10.99                    August 24, 2023                   NetBSD 10.99