Project

General

Profile

RCDB and CCDB information » History » Version 1

Alexandre Camsonne, 06/05/2023 06:55 AM

1 1 Alexandre Camsonne
h1. RCDB and CCDB information
2
3
4
Alexandre, Dillon, 
5
6
Here is CCDB documentation:
7
8
https://github.com/JeffersonLab/ccdb/wiki
9
10
Installation of MySQL database is available here
11
https://github.com/JeffersonLab/ccdb/wiki/Installation#mysql
12
13
But I also should mention that in order to try CCDB one doesn’t need MySQL as CCDB also works with SQLite database which is essentially a single file:
14
You may use HallD to play with existing and working database: 
15
16
To play with existing (readonly) HallD database you may use connection string mysql://hallddb.jlab.org/ccdb
17
18
export CCDB_CONNECTION=mysql://hallddb.jlab.org/ccdb
19
ccdb -i
20
21
Or HallD every day generates sqlite DB which you can download here mysql://hallddb.jlab.org/ccdb
22
23
HallD Wiki page 
24
https://halldweb1.jlab.org/wiki/index.php/SQLite-form_of_the_CCDB_database
25
26
RCDB
27
28
Documentation is here
29
30
https://github.com/JeffersonLab/rcdb/wiki/Installation
31
32
The same as with CCDB, you can use live RCDB example at HallD as a playground. The links are at wiki page above.
33
34
35
I should also mention that there are new versions of CCDB and RCDB are being prepared, which brings significant modernization and e.g. both ccdb and rcdb will be installable by pip, but as of now I would suggest using stable production versions as a start point. 
36
37
Kind regards,
38
Dmitry