| 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 |
><localstatedir>/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 <drivername>_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 |
> |