1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
|
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Chapter 1. Berkeley DB SQL: The Absolute Basics</title>
<link rel="stylesheet" href="gettingStarted.css" type="text/css" />
<meta name="generator" content="DocBook XSL Stylesheets V1.73.2" />
<link rel="start" href="index.html" title="Getting Started with the Oracle Berkeley DB SQL APIs" />
<link rel="up" href="index.html" title="Getting Started with the Oracle Berkeley DB SQL APIs" />
<link rel="prev" href="moreinfo.html" title="For More Information" />
<link rel="next" href="buildinstall.html" title="Getting and Installing BDB SQL" />
</head>
<body>
<div class="navheader">
<table width="100%" summary="Navigation header">
<tr>
<th colspan="3" align="center">Chapter 1. Berkeley DB SQL: The Absolute Basics</th>
</tr>
<tr>
<td width="20%" align="left"><a accesskey="p" href="moreinfo.html">Prev</a> </td>
<th width="60%" align="center"> </th>
<td width="20%" align="right"> <a accesskey="n" href="buildinstall.html">Next</a></td>
</tr>
</table>
<hr />
</div>
<div class="chapter" lang="en" xml:lang="en">
<div class="titlepage">
<div>
<div>
<h2 class="title"><a id="dbsqlbasics"></a>Chapter 1. Berkeley DB SQL: The Absolute Basics</h2>
</div>
</div>
</div>
<div class="toc">
<p>
<b>Table of Contents</b>
</p>
<dl>
<dt>
<span class="sect1">
<a href="dbsqlbasics.html#identicalusage">BDB SQL Is Nearly Identical to SQLite</a>
</span>
</dt>
<dt>
<span class="sect1">
<a href="buildinstall.html">Getting and Installing BDB SQL</a>
</span>
</dt>
<dd>
<dl>
<dt>
<span class="sect2">
<a href="buildinstall.html#onwin">On Windows Systems</a>
</span>
</dt>
<dt>
<span class="sect2">
<a href="buildinstall.html#onunix">On Unix</a>
</span>
</dt>
</dl>
</dd>
<dt>
<span class="sect1">
<a href="journaldirectory.html">The Journal Directory</a>
</span>
</dt>
<dt>
<span class="sect1">
<a href="unsupportedpragmas.html">Unsupported PRAGMAs</a>
</span>
</dt>
<dt>
<span class="sect1">
<a href="changedpragmas.html">Changed PRAGMAs</a>
</span>
</dt>
<dd>
<dl>
<dt>
<span class="sect2">
<a href="changedpragmas.html#journal_size_limit">PRAGMA journal_size_limit</a>
</span>
</dt>
<dt>
<span class="sect2">
<a href="changedpragmas.html#max_page_count">PRAGMA max_page_count</a>
</span>
</dt>
</dl>
</dd>
<dt>
<span class="sect1">
<a href="addedpragmas.html">Added PRAGMAs</a>
</span>
</dt>
<dd>
<dl>
<dt>
<span class="sect2">
<a href="addedpragmas.html#pragma_txn_bulk">PRAGMA TXN_BULK</a>
</span>
</dt>
</dl>
</dd>
<dt>
<span class="sect1">
<a href="miscdiff.html">Miscellaneous Differences</a>
</span>
</dt>
<dt>
<span class="sect1">
<a href="bdb-concepts.html">Berkeley DB Concepts</a>
</span>
</dt>
<dt>
<span class="sect1">
<a href="sql_encryption.html">Encryption</a>
</span>
</dt>
</dl>
</div>
<p>
Welcome to the Berkeley DB SQL interface. If you are a SQLite user who is
using the BDB SQL interface for reasons other than performance
enhancements, this chapter tells you the minimum things you
need to know about the interface. You should simply read this
chapter and then skip the rest of this book.
</p>
<p>
If, however, you are using the BDB SQL interface for performance reasons,
then you need to read this chapter, plus most of the rest of
the chapters in this book (although you can probably skip most
of <a class="xref" href="admin.html" title="Chapter 4. Administrating Berkeley DB SQL Databases">Administrating Berkeley DB SQL Databases</a>, unless you
want to administer your database "the Berkeley DB way").
</p>
<p>
Also, if you are an existing Berkeley DB user who is interested in
the BDB SQL interface, read this chapter plus the rest of this book.
</p>
<div class="sect1" lang="en" xml:lang="en">
<div class="titlepage">
<div>
<div>
<h2 class="title" style="clear: both"><a id="identicalusage"></a>BDB SQL Is Nearly Identical to SQLite</h2>
</div>
</div>
</div>
<p>
Your interaction with the BDB SQL interface is almost identical to
SQLite. You use the same APIs, the same command shell
environment, the same SQL statements, and the same PRAGMAs
to work with the database created by the BDB SQL interface as you
would if you were using SQLite.
</p>
<p>
To learn how to use SQLite, see the official
<a class="ulink" href="http://www.sqlite.org/docs.html" target="_top">SQLite
Documentation Page.</a>
</p>
<p>
That said, there are a few small differences between the
two interfaces. These are described in the remainder of
this chapter.
</p>
</div>
</div>
<div class="navfooter">
<hr />
<table width="100%" summary="Navigation footer">
<tr>
<td width="40%" align="left"><a accesskey="p" href="moreinfo.html">Prev</a> </td>
<td width="20%" align="center"> </td>
<td width="40%" align="right"> <a accesskey="n" href="buildinstall.html">Next</a></td>
</tr>
<tr>
<td width="40%" align="left" valign="top">For More Information </td>
<td width="20%" align="center">
<a accesskey="h" href="index.html">Home</a>
</td>
<td width="40%" align="right" valign="top"> Getting and Installing BDB SQL</td>
</tr>
</table>
</div>
</body>
</html>
|
