[Halld-offline] New RCDB version with SQLite capability.

[Mark Ito]

Folks,

As some of you know, lately we have been having problems with RCDB 
reading its data from an SQLite file using the C++ API. The main 
customer for this is mcsmear. For the last couple of months we have been 
relying on MySQL servers for RCDB data (via C++). Because of the small 
volume of data needed from the RCDB, this has not been killing us.

This has now been fixed with the new GlueX code currently on branches of 
their respective repositories. There are three packages that need to be 
updated and a new one that needs to be installed:

Upgrade:

  * RCDB (branch  = sqlitecpp_standalone)
  * sim-recon (branch = sqlitecpp_standalone)
  * build_scripts (branch = make_sqlitecpp)

Install:

  * SQLiteCpp (version 2.2.0)

All four of these changes have to installed for the fix to work. 
Installing one without the others with break the build.

Some testing has been done. In particular, the b1pi test runs mcsmear 
successfully with an SQLite version of the database.

Note that SQLiteCpp was already part of the old RCDB version; it came 
included with the RCDB source. That implementation did not work with 
sim-recon. We are dropping back to a source code distribution from the 
original author. See the new Makefile_sqlitecpp in build_scripts for the 
GitHub repository.

I've not yet merged any of these changes onto any of the master 
branches. My proposal is to prepare public versions of RCDB, SQLiteCpp, 
and build_scripts at JLab, and then submit a pull request for the change 
to sim-recon. When that gets merged I can create a tagged version and 
build that with the appropriate version set (version.xml).

Let me know what you think. We can discuss it further at Friday's 
offline meeting if necessary.

   -- Mark

-- 
Mark Ito, marki at jlab.org, (757)269-5295

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/halld-offline/attachments/20180124/2a8555d4/attachment.html>