<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Folks,</p>
<p>I have updated a section of the wiki page on the SQLite form of
the CCDB at
<a class="moz-txt-link-freetext" href="https://halldweb.jlab.org/wiki/index.php/SQLite-form_of_the_CCDB_database">https://halldweb.jlab.org/wiki/index.php/SQLite-form_of_the_CCDB_database</a>
. Find the updated section is reproduced below.</p>
<p> - Mark</p>
<p>__________________</p>
<h2><span class="mw-headline" id="Nightly_generated_SQLite_files">Nightly
generated SQLite files</span></h2>
<p>An new SQLite database is created at midnight. The latest version
is available for download from the web at
</p>
<pre><a rel="nofollow" class="external free" href="https://halldweb.jlab.org/dist/ccdb.sqlite">https://halldweb.jlab.org/dist/ccdb.sqlite</a> .
</pre>
<p>This file is on the disk at JLab at
</p>
<pre>/group/halld/www/halldweb/html/dist/ccdb.sqlite .
</pre>
<p>To use the file with your JANA-based program at JLab
</p>
<pre>setenv JANA_CALIB_URL sqlite:////group/halld/www/halldweb/html/dist/ccdb.sqlite
</pre>
<p>for C-shell and
</p>
<pre>export JANA_CALIB_URL=sqlite:////group/halld/www/halldweb/html/dist/ccdb.sqlite
</pre>
<p>for Bourne shell. <b>Using the SQLite form of the CCDB is
important when you run multiple farm or grid jobs.</b> Otherwise
the MySQL database server gets overwhelmed (too many connections).
</p>
<p>Older versions of the CCDB can be found at JLab in
/group/halld/Software/calib/ccdb_sqlite . See the section <a
href="https://halldweb.jlab.org/wiki/index.php?title=SQLite-form_of_the_CCDB_database&printable=yes#Archive_of_SQLite_Files">below</a>
on archiving old versions for more details on what is stored
there.
</p>
<p><br>
</p>
<pre class="moz-signature" cols="72">--
Mark Ito, <a class="moz-txt-link-abbreviated" href="mailto:marki@jlab.org">marki@jlab.org</a>, (757)269-5295
</pre>
</body>
</html>