Difference between revisions of "SQLite-form of the CCDB database"
From GlueXWiki
| Line 3: | Line 3: | ||
By its nature SQLite requires no network connection and no additional software should be required.??? | By its nature SQLite requires no network connection and no additional software should be required.??? | ||
| − | A SQLite database is created nightly. Files can be found at /group/halld/Software/calib/ccdb_sqlite . The latest version is available for download | + | 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. Files can be found at /group/halld/Software/calib/ccdb_sqlite . The latest version is available for download [https://halldweb1.jlab.org/dist/ccdb.sqlite here] . | ||
Revision as of 14:54, 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. Files can be found at /group/halld/Software/calib/ccdb_sqlite . The latest version is available for download here .
