Difference between revisions of "SQLite-form of the CCDB database"
From GlueXWiki
Line 11: | Line 11: | ||
setenv JANA_CLAIBRATION URL sqlite:///home/user/ccdb.sqlite ??? | setenv JANA_CLAIBRATION URL sqlite:///home/user/ccdb.sqlite ??? | ||
− | A SQLite database is created nightly | + | A SQLite database is created nightly. The latest version is available for download [https://halldweb1.jlab.org/dist/ccdb.sqlite here] . Older versions of the CCDB can be found at JLab in /group/halld/Software/calib/ccdb_sqlite . |
Revision as of 14:56, 16 January 2014
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 ???
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 .