EPICS Home EPICS Controls Argonne National Laboratory

Experimental Physics and
Industrial Control System

Format page
for printing


Search Tech-talk
1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017  2018  2019  2020  2021  2022  <2023>  2024  Index 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017  2018  2019  2020  2021  2022  <2023>  2024 
<== Date ==> <== Thread ==>
Subject: Re: [EXTERNAL] Re: Question about fetching history data from MySQL by using phoebus
From: "Kasemir, Kay via Tech-talk" <tech-talk at aps.anl.gov>
To: Han Lee <jeonglee at lbl.gov>
Cc: "tech-talk at aps.anl.gov" <tech-talk at aps.anl.gov>
Date: Wed, 28 Jun 2023 15:39:54 +0000

> Can we access MySQL directly?

 

Not per se as in reading any data from arbitrary tables.

If you’re using the RDB archive engine, the one that writes to Oracle, Postgres or MySQL, then yes, we can read that archived data back out by directly connecting to Ora, PG or MSQL using URLs like jdbc:mysql://192.168.1.230/archive
So we’re assuming to find tables like “channel”, “sample”, … with archived data as used by the RDB archive engine.

It you’re using the archive appliance, then you’ll read data via the AA’s web service, using  something like pbraw://your_host_name…

 

 

Replies:
Re: [EXTERNAL] Re: Question about fetching history data from MySQL by using phoebus Han Lee via Tech-talk
References:
Question about fetching history data from MySQL by using phoebus neu lzf via Tech-talk
Re: Question about fetching history data from MySQL by using phoebus Kasemir, Kay via Tech-talk
Re: Question about fetching history data from MySQL by using phoebus Han Lee via Tech-talk
Navigate by Date:
Prev: Re: Question about fetching history data from MySQL by using phoebus Han Lee via Tech-talk
Next: Re: [EXTERNAL] Re: Question about fetching history data from MySQL by using phoebus Han Lee via Tech-talk
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017  2018  2019  2020  2021  2022  <2023>  2024 
Navigate by Thread:
Prev: Re: Question about fetching history data from MySQL by using phoebus Han Lee via Tech-talk
Next: Re: [EXTERNAL] Re: Question about fetching history data from MySQL by using phoebus Han Lee via Tech-talk
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017  2018  2019  2020  2021  2022  <2023>  2024 
ANJ, 28 Jun 2023 Valid HTML 4.01! · Home · News · About · Base · Modules · Extensions · Distributions · Download ·
· Search · EPICS V4 · IRMIS · Talk · Bugs · Documents · Links · Licensing ·