RE: Using Streamdevice to run SQL Query ?

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

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@aps.anl.gov> On Behalf Of Zimoch Dirk
> via Tech-talk
> Sent: 25 March 2025 11:04
> To: Heinz Junkes <junkes@fhi-berlin.mpg.de>
> Cc: EPICS Tech Talk <tech-talk@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@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
> >