RE: Using Streamdevice to run SQL Query ?

[Freddie Akeroyd - STFC UKRI via Tech-talk <tech-talk at aps.anl.gov>]

You could also use the c++ mysql connector from e.g. an aSub record

Freddie

> -----Original Message-----
> From: Akeroyd, Freddie (STFC,RAL,ISIS)
> Sent: 25 March 2025 12:38
> To: 'Zimoch Dirk' <dirk.zimoch at psi.ch>; Heinz Junkes <junkes@fhi-
> berlin.mpg.de>
> Cc: EPICS Tech Talk <tech-talk at aps.anl.gov>
> Subject: RE: Using Streamdevice to run SQL Query ?
> 
> Hi Heinz,
> 
> We've done this in python using pcaspy and the python mysql connector
> 
> Regards,
> 
> Freddie
> 
> > -----Original Message-----
> > From: Tech-talk <tech-talk-bounces at aps.anl.gov> On Behalf Of Zimoch
> > Dirk via Tech-talk
> > Sent: 25 March 2025 11:04
> > To: Heinz Junkes <junkes at fhi-berlin.mpg.de>
> > Cc: EPICS Tech Talk <tech-talk at aps.anl.gov>
> > Subject: Re: Using Streamdevice to run SQL Query ?
> >
> > Hello Heinz,
> >
> > Does your sql database have a TCP socket to write the queries to?
> > Maybe a web interface?
> > If not, can you use for example ncat to pass queries from a TCP socket
> > to stdin of a sql command line interface?
> >
> > Once you have a TCP port that accepts sql queries, it should be
> > possible to use it with StreamDevice.
> >
> >
> > Dirk
> >
> > > On 25 Mar 2025, at 07:24, Heinz Junkes via Tech-talk <tech-
> > talk at aps.anl.gov> wrote:
> > >
> > > Good morning,
> > > We are currently having an EPICS training week. A participant asked
> > > if it is possible to create PVs that can make an SQL query against a
> > > mySQL
> > database.
> > > The measurement data is stored by a foreign system in a database.
> > > The idea is to provide the values in the database as EPICS-PVs for
> > caput/caget.
> > > Has anyone done this before?
> > >
> > > Thanks Heinz
> > >