Debian Codegraph @

www/quickstart.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>SQLite In 5 Minutes Or Less</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
119
120
121 <p>Here is what you do to start experimenting with SQLite without having
122 to do a lot of tedious reading and configuration:</p>
123
124 <h2>Download The Code</h2>
125
126 <ul>
127 <li><p>Get a copy of the prebuilt binaries for your machine, or get a copy
128 of the sources and compile them yourself. Visit
129 the <a href="download.html">download</a> page for more information.</p></li>
130 </ul>
131
132 <h2>Create A New Database Using The <a href="cli.html">Command Line Interface</a></h2>
133
134 <p>The <a href="cli.html">Command Line Interface</a> or "<a href="cli.html">CLI</a>" is a simple command-line program
135 that accepts SQL input text and passes it through to the SQLite database
136 engine core to be executed. The name of the CLI program is "sqlite3"
137 (or "sqlite3.exe" on Windows). Use the CLI for manual interactions with
138 a database.
139
140 <ul>
141 <li><p>At a shell or DOS prompt, enter: "<b>sqlite3 test.db</b>". This will
142 create a new database named "test.db". (You can use a different name if
143 you like.)</p></li>
144 <li><p>Enter SQL commands at the prompt to create and populate the
145 new database.</p></li>
146 <li><p>See the <a href="cli.html">detailed CLI documentation</a> for details</li>
147 </ul>
148
149 <p>A WASM build of the CLI that runs in your web-browser is available
150 at <a href="https://sqlite.org/fiddle">https://sqlite.org/fiddle</a>.
151
152 <h2>Write Programs That Use SQLite</h2>
153
154 <ul>
155 <li><p>Below is a simple
156 <a href="http://www.tcl-lang.org">TCL program</a> that demonstrates how to use
157 the TCL interface to SQLite. The program executes the SQL statements
158 given as the second argument on the database defined by the first
159 argument. The commands to watch for are the <b>sqlite3</b> command
160 on line 7 which opens an SQLite database and creates
161 a new object named "<b>db</b>" to access that database, the
162 use of the <a href="tclsqlite.html#eval">eval method</a> on the <b>db</b> object on line 8 to run
163 SQL commands against the database, and the closing of the database connection
164 on the last line of the script.</p>
165
166 <blockquote><pre>
167 01 #!/usr/bin/tclsh
168 02 if {$argc!=2} {
169 03 puts stderr "Usage: %s DATABASE SQL-STATEMENT"
170 04 exit 1
171 05 }
172 06 package require sqlite3
173 07 <b>sqlite3</b> db &#91;lindex $argv 0]
174 08 <b>db</b> eval &#91;lindex $argv 1] x {
175 09 foreach v $x(*) {
176 10 puts "$v = $x($v)"
177 11 }
178 12 puts ""
179 13 }
180 14 <b>db</b> close
181 </pre></blockquote>
182 </li>
183
184 <li><p>Below is a simple C program that demonstrates how to use
185 the <a href="c3ref/intro.html">C/C++ interface</a> to SQLite. The name of a database is given by
186 the first argument and the second argument is one or more SQL statements
187 to execute against the database. The function calls to pay attention
188 to here are the call to <a href="c3ref/open.html">sqlite3_open()</a> on line 22 which opens
189 the database, <a href="c3ref/exec.html">sqlite3_exec()</a> on line 28 that executes SQL
190 commands against the database, and <a href="c3ref/close.html">sqlite3_close()</a> on line 33
191 that closes the database connection.</p>
192
193 <p>See also the <a href="cintro.html">Introduction To The SQLite C/C++ Interface</a> for
194 an introductory overview and roadmap to the dozens of SQLite interface
195 functions.</p>
196
197 <blockquote><pre>
198 01 #include &lt;stdio.h&gt;
199 02 #include &lt;sqlite3.h&gt;
200 03
201 04 static int callback(void *NotUsed, int argc, char **argv, char **azColName){
202 05 int i;
203 06 for(i=0; i&lt;argc; i++){
204 07 printf("%s = %s\n", azColName&#91;i], argv&#91;i] ? argv&#91;i] : "NULL");
205 08 }
206 09 printf("\n");
207 10 return 0;
208 11 }
209 12
210 13 int main(int argc, char **argv){
211 14 <b>sqlite3</b> *db;
212 15 char *zErrMsg = 0;
213 16 int rc;
214 17
215 18 if( argc!=3 ){
216 19 fprintf(stderr, "Usage: %s DATABASE SQL-STATEMENT\n", argv&#91;0]);
217 20 return(1);
218 21 }
219 22 rc = <b>sqlite3_open</b>(argv&#91;1], &db);
220 23 if( rc ){
221 24 fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
222 25 <b>sqlite3_close</b>(db);
223 26 return(1);
224 27 }
225 28 rc = <b>sqlite3_exec</b>(db, argv&#91;2], callback, 0, &zErrMsg);
226 29 if( rc!=SQLITE_OK ){
227 30 fprintf(stderr, "SQL error: %s\n", zErrMsg);
228 31 <b>sqlite3_free</b>(zErrMsg);
229 32 }
230 33 <b>sqlite3_close</b>(db);
231 34 return 0;
232 35 }
233 </pre></blockquote>
234 <p>See the <a href="howtocompile.html">How To Compile SQLite</a> document for instructions and hints on
235 how to compile the program shown above.
236 </li>
237 </ul>
238 <p align="center"><small><i>This page was last updated on 2024-07-25 15:06:57Z </small></i></p>
239