[Halld-offline] SQLite-form of the CCDB database

Mark Ito marki at jlab.org
Thu Jan 16 14:43:05 EST 2014


Folks,

The SQLite version of CCDB is being regenerated nightly now. Find a 
description of how to get it and use it on the wiki at

https://halldweb1.jlab.org/wiki/index.php/SQLite-form_of_the_CCDB_database .

This page is reproduced below.

   -- Mark and Dmitry
_________________________________________________________

SQLite-form of the CCDB database

    The CCDB can be accessed as an SQLite file. Full history and read/write
    access is supported. However note that there is no current automatic
    mechanism for backporting changes from a modified SQLite database to
    the main MySQL database.

    By its nature SQLite requires no network connection and no additional
    software is required.

    Legal forms of the CCDB_CONNECTION URL are:

      sqlite:///relative/path/to/file.db
      sqlite:////absolute/path/to/file.db

    Note that three "/"s indicate a relative path, four "/"s an absolute
    path.

    For example, sqlite database is /home/user/ccdb.sqlite then to use it
    with the CCDB software,

      setenv CCDB_CONNECTION sqlite:////home/user/ccdb.sqlite

    or supply the URL directly to CCDB (interactive version shown),

      ccdb -i -c sqlite:////home/user/ccdb.sqlite

    To use it with JANA,

      setenv JANA_CALIB_URL sqlite:////home/user/ccdb.sqlite

    An SQLite database is created at midnight. The latest version is
    available for download [5]here . Older versions of the CCDB can be
    found at JLab in /group/halld/Software/calib/ccdb_sqlite .

    Retrieved from
"https://halldweb1.jlab.org/wiki/index.php/SQLite-form_of_CCDB_database"

References

    5. https://halldweb1.jlab.org/dist/ccdb.sqlite
    6. 
https://halldweb1.jlab.org/wiki/index.php/SQLite-form_of_CCDB_database



More information about the Halld-offline mailing list