Debian Codegraph @

www/c3ref/limit.html

raw
1 <!DOCTYPE html>
2 <html><head>
3 <meta name="viewport" content="width=device-width, initial-scale=1.0">
4 <meta http-equiv="content-type" content="text/html; charset=UTF-8">
5 <link href="../sqlite.css" rel="stylesheet">
6 <title>Run-time Limits</title>
7 <!-- path=../ -->
8 </head>
9 <body>
10 <div class=nosearch>
11 <a href="../index.html">
12 <img class="logo" src="../images/sqlite370_banner.svg" alt="SQLite" border="0">
13 </a>
14 <div><!-- IE hack to prevent disappearing logo --></div>
15 <div class="tagline desktoponly">
16 Small. Fast. Reliable.<br>Choose any three.
17 </div>
18 <div class="menu mainmenu">
19 <ul>
20 <li><a href="../index.html">Home</a>
21 <li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
22 <li class='wideonly'><a href='../about.html'>About</a>
23 <li class='desktoponly'><a href="../docs.html">Documentation</a>
24 <li class='desktoponly'><a href="../download.html">Download</a>
25 <li class='wideonly'><a href='../copyright.html'>License</a>
26 <li class='desktoponly'><a href="../support.html">Support</a>
27 <li class='desktoponly'><a href="../prosupport.html">Purchase</a>
28 <li class='search' id='search_menubutton'>
29 <a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
30 </ul>
31 </div>
32 <div class="menu submenu" id="submenu">
33 <ul>
34 <li><a href='../about.html'>About</a>
35 <li><a href='../docs.html'>Documentation</a>
36 <li><a href='../download.html'>Download</a>
37 <li><a href='../support.html'>Support</a>
38 <li><a href='../prosupport.html'>Purchase</a>
39 </ul>
40 </div>
41 <div class="searchmenu" id="searchmenu">
42 <form method="GET" action="../search">
43 <select name="s" id="searchtype">
44 <option value="d">Search Documentation</option>
45 <option value="c">Search Changelog</option>
46 </select>
47 <input type="text" name="q" id="searchbox" value="">
48 <input type="submit" value="Go">
49 </form>
50 </div>
51 </div>
52 <script>
53 function toggle_div(nm) {
54 var w = document.getElementById(nm);
55 if( w.style.display=="block" ){
56 w.style.display = "none";
57 }else{
58 w.style.display = "block";
59 }
60 }
61 function toggle_search() {
62 var w = document.getElementById("searchmenu");
63 if( w.style.display=="block" ){
64 w.style.display = "none";
65 } else {
66 w.style.display = "block";
67 setTimeout(function(){
68 document.getElementById("searchbox").focus()
69 }, 30);
70 }
71 }
72 function div_off(nm){document.getElementById(nm).style.display="none";}
73 window.onbeforeunload = function(e){div_off("submenu");}
74 /* Disable the Search feature if we are not operating from CGI, since */
75 /* Search is accomplished using CGI and will not work without it. */
76 if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
77 document.getElementById("search_menubutton").style.display = "none";
78 }
79 /* Used by the Hide/Show button beside syntax diagrams, to toggle the */
80 function hideorshow(btn,obj){
81 var x = document.getElementById(obj);
82 var b = document.getElementById(btn);
83 if( x.style.display!='none' ){
84 x.style.display = 'none';
85 b.innerHTML='show';
86 }else{
87 x.style.display = '';
88 b.innerHTML='hide';
89 }
90 return false;
91 }
92 var antiRobot = 0;
93 function antiRobotGo(){
94 if( antiRobot!=3 ) return;
95 antiRobot = 7;
96 var j = document.getElementById("mtimelink");
97 if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
98 }
99 function antiRobotDefense(){
100 document.body.onmousedown=function(){
101 antiRobot |= 2;
102 antiRobotGo();
103 document.body.onmousedown=null;
104 }
105 document.body.onmousemove=function(){
106 antiRobot |= 2;
107 antiRobotGo();
108 document.body.onmousemove=null;
109 }
110 setTimeout(function(){
111 antiRobot |= 1;
112 antiRobotGo();
113 }, 100)
114 antiRobotGo();
115 }
116 antiRobotDefense();
117 </script>
118 <!-- keywords: sqlite3_limit -->
119 <div class=nosearch>
120 <a href="../c3ref/intro.html"><h2>SQLite C Interface</h2></a>
121 <h2>Run-time Limits</h2>
122 </div>
123 <blockquote><pre>
124 int sqlite3_limit(sqlite3*, int id, int newVal);
125 </pre></blockquote>
126 <p>
127 This interface allows the size of various constructs to be limited
128 on a connection by connection basis. The first parameter is the
129 <a href="../c3ref/sqlite3.html">database connection</a> whose limit is to be set or queried. The
130 second parameter is one of the <a href="../c3ref/c_limit_attached.html">limit categories</a> that define a
131 class of constructs to be size limited. The third parameter is the
132 new limit for that construct.</p>
133
134 <p>If the new limit is a negative number, the limit is unchanged.
135 For each limit category SQLITE_LIMIT_<i>NAME</i> there is a
136 <a href="../limits.html">hard upper bound</a>
137 set at compile-time by a C preprocessor macro called
138 <a href="../limits.html">SQLITE_MAX_<i>NAME</i></a>.
139 (The "_LIMIT_" in the name is changed to "_MAX_".)
140 Attempts to increase a limit above its hard upper bound are
141 silently truncated to the hard upper bound.</p>
142
143 <p>Regardless of whether or not the limit was changed, the
144 <a href="../c3ref/limit.html">sqlite3_limit()</a> interface returns the prior value of the limit.
145 Hence, to find the current value of a limit without changing it,
146 simply invoke this interface with the third parameter set to -1.</p>
147
148 <p>Run-time limits are intended for use in applications that manage
149 both their own internal database and also databases that are controlled
150 by untrusted external sources. An example application might be a
151 web browser that has its own databases for storing history and
152 separate databases controlled by JavaScript applications downloaded
153 off the Internet. The internal databases can be given the
154 large, default limits. Databases managed by external sources can
155 be given much smaller limits designed to prevent a denial of service
156 attack. Developers might also want to use the <a href="../c3ref/set_authorizer.html">sqlite3_set_authorizer()</a>
157 interface to further control untrusted SQL. The size of the database
158 created by an untrusted script can be contained using the
159 <a href="../pragma.html#pragma_max_page_count">max_page_count</a> <a href="../pragma.html#syntax">PRAGMA</a>.</p>
160
161 <p>New run-time limit categories may be added in future releases.
162 </p><p>See also lists of
163 <a href="../c3ref/objlist.html">Objects</a>,
164 <a href="../c3ref/constlist.html">Constants</a>, and
165 <a href="../c3ref/funclist.html">Functions</a>.</p>
166