Difference between revisions of "SQLite-form of the CCDB database"

From GlueXWiki
Jump to: navigation, search
m
Line 8: Line 8:
 
  sqlite:////absolute/path/to/file.db
 
  sqlite:////absolute/path/to/file.db
  
Note that three /'s indicate a relative path, four /'s an absolute path.  
+
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,
 
For example, sqlite database is /home/user/ccdb.sqlite then to use it with the CCDB software,

Revision as of 15:33, 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 shown),

 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 at midnight. 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 .