<HTML ><HEAD ><TITLE >Driver options</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.73 "><LINK REL="HOME" TITLE="sqlite driver manual" HREF="index.html"><LINK REL="PREVIOUS" TITLE="Build and install the sqlite driver" HREF="x60.html"><LINK REL="NEXT" TITLE="Peculiarities you should know about" HREF="c119.html"></HEAD ><BODY CLASS="CHAPTER" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >sqlite driver manual: A libdbi driver using the SQLite embedded database engine</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="x60.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="c119.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="CHAPTER" ><H1 ><A NAME="AEN98" >Chapter 3. Driver options</A ></H1 ><P >Your application has to initialize libdbi drivers by setting some driver options with the <TT CLASS="FUNCTION" >dbi_conn_set_option()</TT > and the <TT CLASS="FUNCTION" >dbi_conn_set_option_numeric()</TT > library functions. The sqlite driver supports the following options:</P ><P ></P ><DIV CLASS="VARIABLELIST" ><DL ><DT >dbname</DT ><DD ><P >The name of the database you want to work with. As a SQLite database corresponds to one file in your filesystem, <TT CLASS="VARNAME" >dbname</TT > can be any legal filename. If the database/file doesn't exist when you first try to access it, SQLite will create it on the fly.</P ><P >It is important to understand that the full path of the database is composed of <TT CLASS="VARNAME" >sqlite_dbdir</TT > and <TT CLASS="VARNAME" >dbname</TT >. Therefore <TT CLASS="VARNAME" >dbname</TT > should not contain the full path of a file, but just the name.</P ></DD ><DT >sqlite_dbdir</DT ><DD ><P >This is the directory that contains all sqlite databases. Use the full path please.</P ><DIV CLASS="NOTE" ><BLOCKQUOTE CLASS="NOTE" ><P ><B >Note: </B >It is necessary to keep all sqlite databases in one directory to make it possible to list all existing databases through the libdbi API.</P ></BLOCKQUOTE ></DIV ></DD ></DL ></DIV ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="x60.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="c119.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Build and install the sqlite driver</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" > </TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Peculiarities you should know about</TD ></TR ></TABLE ></DIV ></BODY ></HTML >