
#include "bacula_template.inc" title="Internal Bacula Database" num=23

<H1>Internal Bacula Database</H1>

<h3>Internal Bacula Database</h3>
The <b>Bacula</b> internal database is no longer
supported, please do not use it.
<p>Previously it was intended to
be used primarily by <b>Bacula</b> developers for
testing; although SQLite is also a good choice for
this.  We do not recommend its use in general.  

<p>This database is simplistic in that it consists
entirely of Bacula's internal structures appended
sequentially to a file.  Consequently, it is in most cases
inappropriate for sites with many clients or systems
with large numbers of files, or long-term production
environments.

<p>Below, you will find a table comparing the features available with
SQLite and MySQL and with the internal Bacula database.  At the current
time, you cannot dynamically switch from one to the other, but must
rebuild the Bacula source code.  If you wish to experiment with both, it
is possible to build both versions of Bacula and install them into
separate directories.
</p>
<table cellspacing="4" cellpadding="4" border="1">

<tr><th>Feature</th>  <th>SQLite or MySQL</th>     <th>Bacula</th> </tr>
<tr> <td>Job Record</td>            <td>Yes</td>     <td>Yes</td> </tr>
<tr> <td>Media Record</td>          <td>Yes</td>     <td>Yes</td> </tr>
<tr> <td>FileName Record</td>       <td>Yes</td>     <td>No</td> </tr>
<tr> <td>File Record</td>           <td>Yes</td>     <td>No</td> </tr>
<tr> <td>FileSet Record</td>        <td>Yes</td>     <td>Yes</td> </tr>
<tr> <td>Pool Record</td>           <td>Yes</td>     <td>Yes</td> </tr>
<tr> <td>Client Record</td>         <td>Yes</td>     <td>Yes</td> </tr>
<tr> <td>JobMedia Record</td>       <td>Yes</td>     <td>Yes</td> </tr>
<tr> <td>List Job Records</td>      <td>Yes</td>     <td>Yes</td> </tr>
<tr> <td>List Media Records</td>    <td>Yes</td>     <td>Yes</td> </tr>
<tr> <td>List Pool Records</td>     <td>Yes</td>     <td>Yes</td> </tr>
<tr> <td>List JobMedia Records</td> <td>Yes</td>     <td>Yes</td> </tr>
<tr> <td>Delete Pool Record</td>    <td>Yes</td>     <td>Yes</td> </tr>
<tr> <td>Delete Media Record</td>   <td>Yes</td>     <td>Yes</td> </tr>
<tr> <td>Update Pool Record</td>    <td>Yes</td>     <td>Yes</td> </tr>
<tr> <td>Implement Verify</td>      <td>Yes</td>     <td>No</td> </tr>
<tr> <td>MD5 Signatures</td>        <td>Yes</td>     <td>No</td> </tr>

</table>

<p>In addition, since there is no SQL available, the Console commands:
<b>sqlquery</b>, <b>query</b>, <b>retention</b>, and any other
command that directly uses SQL are not available with the Internal
database.

<page_prev name="Installing and Configuring SQLite" url="sqlite.html">
<page_next name="Bacula Licenses" url="license.html">
