Debian Codegraph @

doc/driver-guide/databasedirectories.html

raw
1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
2 <HTML
3 ><HEAD
4 ><TITLE
5 >Database directories</TITLE
6 ><META
7 NAME="GENERATOR"
8 CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
9 REL="HOME"
10 TITLE="Database Independent Abstraction Layer for C"
11 HREF="index.html"><LINK
12 REL="UP"
13 TITLE="Driver Infrastructure"
14 HREF="driverinfrastructure.html"><LINK
15 REL="PREVIOUS"
16 TITLE="Driver Capabilities"
17 HREF="drivercaps.html"><LINK
18 REL="NEXT"
19 TITLE="Driver data"
20 HREF="driverdata.html"></HEAD
21 ><BODY
22 CLASS="SECTION"
23 BGCOLOR="#FFFFFF"
24 TEXT="#000000"
25 LINK="#0000FF"
26 VLINK="#840084"
27 ALINK="#0000FF"
28 ><DIV
29 CLASS="NAVHEADER"
30 ><TABLE
31 SUMMARY="Header navigation table"
32 WIDTH="100%"
33 BORDER="0"
34 CELLPADDING="0"
35 CELLSPACING="0"
36 ><TR
37 ><TH
38 COLSPAN="3"
39 ALIGN="center"
40 >Database Independent Abstraction Layer for C: libdbi Driver Author's Guide</TH
41 ></TR
42 ><TR
43 ><TD
44 WIDTH="10%"
45 ALIGN="left"
46 VALIGN="bottom"
47 ><A
48 HREF="drivercaps.html"
49 ACCESSKEY="P"
50 >Prev</A
51 ></TD
52 ><TD
53 WIDTH="80%"
54 ALIGN="center"
55 VALIGN="bottom"
56 >Chapter 2. Driver Infrastructure</TD
57 ><TD
58 WIDTH="10%"
59 ALIGN="right"
60 VALIGN="bottom"
61 ><A
62 HREF="driverdata.html"
63 ACCESSKEY="N"
64 >Next</A
65 ></TD
66 ></TR
67 ></TABLE
68 ><HR
69 ALIGN="LEFT"
70 WIDTH="100%"></DIV
71 ><DIV
72 CLASS="SECTION"
73 ><H1
74 CLASS="SECTION"
75 ><A
76 NAME="DATABASEDIRECTORIES"
77 >2.2. Database directories</A
78 ></H1
79 ><P
80 >Many database engines use database directories which they manage themselves. Other engines, like sqlite, sqlite3, or firebird, allow the database user to store database files basically anywhere on the filesystem. Drivers of such engines should follow some guidelines to make database operations as transparent as possible across all drivers. In order to allow e.g. listing available databases, most applications should keep all databases managed by such a driver in the same directory.</P
81 ><DIV
82 CLASS="SECTION"
83 ><H2
84 CLASS="SECTION"
85 ><A
86 NAME="DEFAULTDATABASEDIRECTORIES"
87 >2.2.1. Default Database Directories</A
88 ></H2
89 ><P
90 >libdbi-drivers uses a common root directory (<TT
91 CLASS="FILENAME"
92 >&lt;localstatedir&gt;/lib/libdbi</TT
93 >) containing homonymous subdirectories for each driver as a default database path. If nothing else is specified (see <A
94 HREF="databasedirectories.html#CUSTOMDATABASEDIRECTORIES"
95 >Section 2.2.2</A
96 >), databases will be created and accessed in these subdirectories. Using different subdirectories for each driver makes switching between drivers painless without having to re-create database files from scratch.</P
97 ><P
98 >Users can change the compile-time default root directory using the <CODE
99 CLASS="OPTION"
100 >--with-dbi-dbdir</CODE
101 > option when configuring libdbi-drivers.</P
102 ></DIV
103 ><DIV
104 CLASS="SECTION"
105 ><H2
106 CLASS="SECTION"
107 ><A
108 NAME="CUSTOMDATABASEDIRECTORIES"
109 >2.2.2. Custom Database Directories</A
110 ></H2
111 ><P
112 >In order to allow applications to store databases outside of the default directory if desired, a driver should implement a &lt;drivername&gt;_dbdir option which overrides the default database path in a connection.</P
113 ></DIV
114 ></DIV
115 ><DIV
116 CLASS="NAVFOOTER"
117 ><HR
118 ALIGN="LEFT"
119 WIDTH="100%"><TABLE
120 SUMMARY="Footer navigation table"
121 WIDTH="100%"
122 BORDER="0"
123 CELLPADDING="0"
124 CELLSPACING="0"
125 ><TR
126 ><TD
127 WIDTH="33%"
128 ALIGN="left"
129 VALIGN="top"
130 ><A
131 HREF="drivercaps.html"
132 ACCESSKEY="P"
133 >Prev</A
134 ></TD
135 ><TD
136 WIDTH="34%"
137 ALIGN="center"
138 VALIGN="top"
139 ><A
140 HREF="index.html"
141 ACCESSKEY="H"
142 >Home</A
143 ></TD
144 ><TD
145 WIDTH="33%"
146 ALIGN="right"
147 VALIGN="top"
148 ><A
149 HREF="driverdata.html"
150 ACCESSKEY="N"
151 >Next</A
152 ></TD
153 ></TR
154 ><TR
155 ><TD
156 WIDTH="33%"
157 ALIGN="left"
158 VALIGN="top"
159 >Driver Capabilities</TD
160 ><TD
161 WIDTH="34%"
162 ALIGN="center"
163 VALIGN="top"
164 ><A
165 HREF="driverinfrastructure.html"
166 ACCESSKEY="U"
167 >Up</A
168 ></TD
169 ><TD
170 WIDTH="33%"
171 ALIGN="right"
172 VALIGN="top"
173 >Driver data</TD
174 ></TR
175 ></TABLE
176 ></DIV
177 ></BODY
178 ></HTML
179 >