Re: Using Streamdevice to run SQL Query ?

[Zimoch Dirk via Tech-talk <tech-talk at aps.anl.gov>]

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 
>