[Q] Panel integration with a MariaDB database about volkovlabs-form-panel HOT 7 CLOSED

Pls create an example for this. In your Custom Code in the update statement, it is not very clear where are the postgres database name and the table names. A video tutorial would be a great help as well.

from volkovlabs-form-panel.

Hello @sanchomuzax, you will need an API server, which will implement an interface to a MariaDB or any other database.

Please check out the YouTube video https://www.youtube.com/watch?v=DXALVG8GijM&t=486s and our blog post https://volkovlabs.com/how-to-connect-the-data-manipulation-plugin-for-grafana-to-api-server-1abe5f60c904

The API Server should be similar to our Postgres example: https://github.com/VolkovLabs/volkovlabs-form-panel/blob/main/server-pg/server.ts

Let me know if there is anything else.

from volkovlabs-form-panel.

@sanchomuzax Please let me know if it works.

from volkovlabs-form-panel.

Thank you for your help.

Unfortunately, I'm not a developer, although I can create scripts at a basic level, and I know how to manage sql databases. However, the operation of web interfaces is a level of knowledge that I don't understand.
The documents described in the linked descriptions aren't detailed enough and don't contain enough concrete steps for me to prepare the server side settings of the plugin. 😞

from volkovlabs-form-panel.

@sanchomuzax It's an interesting idea. Using Custom Code in the update statement we can create an INSERT statement based on the form elements. Then query the data source performing update.

This is what you are looking for? I can create an example and it's a great topic for the video tutorial.

from volkovlabs-form-panel.

@anilsagar Thank you for your interest. We are working on it.

from volkovlabs-form-panel.

Selecting data sources for the initial and update requests implemented in v3.1.0.

from volkovlabs-form-panel.