Oh3 widget and MySQL database, a few questions

[marc1310 (marc schlüter)]

Hello,
I’m trying to find out what is possible with openhab3 and eg a MySQL database.

I would like to certain data that I call up via json written into a database. To display these in a widget, e.g. with an oh repeater.

Is it possible to have certain data written into an SQL database?
And is it possible to display this data in widgets without having to write it in items? Or in temporary items?

If so, can someone give me an example?

[rossko57]

Related thread from a few minutes ago

How to access persistence data from widget expression

I’m looking to add a widget that shows the power/energy usage during the last hour, based on an item that stores the cumulative all-time energy usage. The approach that seems sensible, is to access the persistence/history data directly from the widget using an expression, but I suspect that this is not possible. Maybe because widget expressions really are just ran in the browser on a very limited subset of data, while the persistence methods are available in the server only? I’m not quite sure,…

@marc1310

Is it possible to have certain data written into an SQL database?

You can write what you like with some external script.

@marc1310

And is it possible to display this data in widgets without having to write it in items?

You can use a webview or similar to display the results of some external script.

[marc1310 (marc schlüter)]

i take a look at it, gives perhaps a example how it looks with a webview?