Difference between revisions of "SQLite-form of the CCDB database"
| Line 1: | Line 1: | ||
| − | The CCDB can be accessed as | + | 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 | + | By its nature SQLite requires no network connection and no additional software is required. |
| − | + | Legal forms of the CCDB_CONNECTION URL are: | |
| − | setenv CCDB_CONNECTION sqlite:////home/user/ccdb.sqlite | + | 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) | 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 | ||
| − | setenv | + | setenv JANA_CALIB_URL sqlite:////home/user/ccdb.sqlite |
| − | + | An 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 15:26, 16 January 2014
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)
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 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 .
