Back Midas Rome Roody Rootana
  Midas DAQ System  Not logged in ELOG logo
Entry  06 Mar 2023, Gennaro Tortone, Forum, pull request for PostgreSQL support 
    Reply  06 Mar 2023, Konstantin Olchanski, Forum, pull request for PostgreSQL support 
       Reply  06 Mar 2023, Gennaro Tortone, Forum, pull request for PostgreSQL support 
       Reply  20 Mar 2023, Gennaro Tortone, Forum, pull request for PostgreSQL support 
          Reply  24 May 2023, Gennaro Tortone, Forum, pull request for PostgreSQL support 
             Reply  18 Jul 2023, Konstantin Olchanski, Forum, pull request for PostgreSQL support 
                Reply  21 Jul 2023, Konstantin Olchanski, Forum, pull request for PostgreSQL support 
                   Reply  21 Jul 2023, Gennaro Tortone, Forum, pull request for PostgreSQL support 
                      Reply  28 Jul 2023, Stefan Ritt, Forum, pull request for PostgreSQL support 
                         Reply  09 Aug 2023, Konstantin Olchanski, Forum, pull request for PostgreSQL support 
Message ID: 2471     Entry time: 20 Mar 2023     In reply to: 2461     Reply to this: 2520
Author: Gennaro Tortone 
Topic: Forum 
Subject: pull request for PostgreSQL support 
Hi,
I have updated the PR with a new one that includes TimescaleDB support and some
changes to mhistory.js to support downsampling queries...

Cheers,
Gennaro

> > some minutes ago I published a PR for PostgreSQL support I developed
> > at INFN-Napoli for Darkside experiment...
> > 
> > I don't know if you receive a notification about this PR and in doubt
> > I wrote this message...
> 
> Hi, Gennaro, thank you for the very useful contribution. I saw the previous version 
> of your pull request and everything looked quite good. But that pull request was 
> for an older version of midas and it would not have applied cleanly to the current 
> version. I will take a look at your updated pull request. In theory it should only 
> add the Postgres class and modify a few other places in history_schema.cxx and have 
> no changes to anything else. (if you need those changes, it should be a separate 
> pull request).
> 
> Also I am curious what benefits and drawbacks of Postgres vs mysql/mariadb you have 
> observed for storing and using midas history data.
> 
> K.O.
ELOG V3.1.4-2e1708b5