https://forge.codesys.com/forge/talk/Runtime/thread/859fb6bf35/2020-02-27T16:31:49.933000ZRecent posts to Trends from Mysql DB2020-02-27T16:31:49.933000Z2020-02-27T16:31:49.933000Zmprestelhttps://forge.codesys.com/u/mprestel/https://forge.codesys.com2a171a7e496a0e0a8db693153ba1ffbc83a14e75

<div class="markdown_content"><p>Hello,</p> <p>no it is currently not possible to connect the trend with a remote database. There is an open requirement for this.</p> <p>And no, there is no offical description on the structure of the trend sqlite.</p> <p>You can however open the sqlite with e.g. sqlite browser and view the data.</p> <p>Best regards,<br/> Marcel</p></div>

2020-02-27T16:31:47.473000Z2020-02-27T16:31:47.473000Zwitalishttps://forge.codesys.com/u/witalis/https://forge.codesys.com5461049c156df22d17971a04d0f6c0e5879fdcd9

<div class="markdown_content"><p>Hello,</p> <p>I need to present trends of some variables stored in Mysql DB. Is it possible to do it with Codesys? I asked about 2 years ago about this, but there was no helpful answer.</p> <p>I tried to do this with XYchart but I couldn't use on X axis Time type (only Integer and Real is accepted).</p> <p>I also found on the controller the file of SQLite which is used to store recorded data. Maybe I can transfer data from Mysql to this SQLite file? I know how to write some C code to do this without Codesys. What is the structure of stored variables in this DB? Do anybody knows it?</p> <p>Please help me, I have really serious problem with this issue:-)</p></div>