Difference between revisions of "SQLite-form of the CCDB database"
From GlueXWiki
Line 5: | Line 5: | ||
If the sqlite database is /home/user/ccdb.sqlite then to use it with the CCDB CLI | 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 ??? | + | 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 | To use it with JANA |
Revision as of 15:17, 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 ???
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 .