From 253e67c8b3a72b3a4757fdbc5845297628db0a4a Mon Sep 17 00:00:00 2001 From: Jacob McDonnell Date: Sat, 25 Apr 2026 19:55:15 -0400 Subject: docs: Added All NetBSD Manuals --- static/netbsd/man3/sqlite3_limit.3 | 61 ++++++++++++++++++++++++++++++++++++++ 1 file changed, 61 insertions(+) create mode 100644 static/netbsd/man3/sqlite3_limit.3 (limited to 'static/netbsd/man3/sqlite3_limit.3') diff --git a/static/netbsd/man3/sqlite3_limit.3 b/static/netbsd/man3/sqlite3_limit.3 new file mode 100644 index 00000000..5e4774f6 --- /dev/null +++ b/static/netbsd/man3/sqlite3_limit.3 @@ -0,0 +1,61 @@ +.Dd January 24, 2024 +.Dt SQLITE3_LIMIT 3 +.Os +.Sh NAME +.Nm sqlite3_limit +.Nd run-time limits +.Sh SYNOPSIS +.In sqlite3.h +.Ft int +.Fo sqlite3_limit +.Fa "sqlite3*" +.Fa "int id" +.Fa "int newVal" +.Fc +.Sh 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. +.Pp +If the new limit is a negative number, the limit is unchanged. +For each limit category SQLITE_LIMIT_\fINAME\fP there is a hard upper bound +set at compile-time by a C preprocessor macro called SQLITE_MAX_NAME. +(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. +.Pp +Regardless of whether or not the limit was changed, the +.Fn 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. +.Pp +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 +.Fn 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. +.Pp +New run-time limit categories may be added in future releases. +.Sh IMPLEMENTATION NOTES +These declarations were extracted from the +interface documentation at line 4026. +.Bd -literal +SQLITE_API int sqlite3_limit(sqlite3*, int id, int newVal); +.Ed +.Sh SEE ALSO +.Xr sqlite3 3 , +.Xr sqlite3_set_authorizer 3 -- cgit v1.2.3