Databases - EMPHATICSoft/emphaticsoft GitHub Wiki

EMPHATIC uses PostgreSQL databases (a standard for Fermilab experiments, supported by Fermilab Computing Division), and the offline software uses the Fermilab-supported Query Engine and Conditions Database web interfaces to both read and write to tables. There are generally two types of database tables: "flat" tables, which are simply columns and rows, and "conditions" tables, which contain data associated with a "validity context" which typically has data associated by at least (timestamp, channel).

Note too that we also use the "ifbeam" database, which stores all of the data associated with the various beamline settings and read backs. See the IFBeam Wiki and the IFBeam Data Server for more details if you are interested. The EMPHATIC code that extracts information from the ifbeam database lives in the SpillInfo package.