SQLite-form of the CCDB database

The CCDB can be accessed as a SQLite file. Full history and read/write access is supported. However note that there is no current 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 should be required.???

If the sqlite database is /home/user/ccdb.sqlite then to use it with the CCDB CLI

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

or supply the URL directly to CCDB (interactive version)

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

To use it with JANA

setenv JANA_CLAIBRATION URL sqlite:///home/user/ccdb.sqlite ???

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