DolphinDB Backend Datasource

Download and install the latest open-source version (OSS, Open-Source Software) in Grafana's official website.

Download the latest plugin package in releases, such as dolphindb-datasource-go.v1.0.0.zip.

Extract the dolphindb-datasource-go folder from the zip package to the following path (if the plugins directory does not exist, you can create it manually):

• Windows: <grafana installation directory>\data\plugins\
• Linux: /var/lib/grafana/plugins/

The plugin directory should contain the following files:

plugins
├── dolphindb-datasource-go
│   ├── LICENSE
│   ├── README.md
│   ├── components
│   ├── go_plugin_build_manifest
│   ├── gpx_dolphindb_datasource_windows_amd64.exe
│   ├── img
│   ├── module.js
│   ├── static
│   └── plugin.json
├── other_plugin_1
├── other_plugin_2
└── ...

Read Configure Grafana.

Open and edit the configuration file under the [plugins] section. Uncomment allow_loading_unsigned_plugins and configure it to dolphindb-datasource-go, i.e., modify the following configuration:

# Enter a comma-separated list of plugin identifiers to identify plugins to load even if they are unsigned. Plugins with modified signatures are never loaded.
;allow_loading_unsigned_plugins =

to

# Enter a comma-separated list of plugin identifiers to identify plugins to load even if they are unsigned. Plugins with modified signatures are never loaded.
allow_loading_unsigned_plugins = dolphindb-datasource-go

Note: Any configuration changes in Grafana require a restart to take effect.

Follow the instructions in Start the Grafana server to start the Grafana server.

You can see a log similar to the following in the grafana startup log.

WARN [05-19|12:05:48] Permitting unsigned plugin. This is not recommended logger=plugin.signature.validator pluginID=dolphindb-datasource-go pluginDir=<grafana 安装目录>/data/plugins/dolphindb-datasource-go

Log file path:

• Windows: <grafana installation directory>\data\log\grafana.log
• Linux: /var/log/grafana/grafana.log

Or visit the following link to make sure that the DolphinDB plugin is in Installed status: http://localhost:3000/plugins.

Open http://localhost:3000. The initial username and password are both admin.

Open http://localhost:3000/datasources, or click Connections > Data sources on the left-side menu to add a data source. Enter "DolphinDB" in the tab and select the corresponding data source.

After filling in the ip:port details, as well as the username and password credentials required to access the database, click the Save & test button at the bottom.

In a new Panel, you can write query scripts or subscribe stream tables to visualize DolphinDB's time-series data.

Open or create a Dashboard. In the dialog box that opens, select the data source you created. The Edit panel view will then open. You can now write DolphinDB query in the Query editor.

Grafana alerting allows you to create custom alert rules to track particular events or conditions. When these rules detect a specified situation, Grafana can automatically send notifications based on your predefined alert settings.

Let's explore how to use Grafana alerting with a simple example:

(1) Write a script in the Query editor, e.g., query the stock price of a company.

(2) Find the Alert tab in Data section, and choose New alert rule.

(3) Enter a name to identify your alert rule. Then, define a query to get the data you want to measure and a condition that needs to be met before an alert rule fires, e.g., time series data and stock prices.

(4) Define a condition that needs to be met before an alert rule fires, e.g., alerting when the high price is greater than 180.

(5) Use alert rule evaluation to determine how frequently an alert rule should be evaluated and how quickly it should change its state. For example, the following configuration sets that all rules are evaluated every 10s and the alert rule fires if the condition remains active for 10s.

(6) (Optional) Configure notifications. Choose how, when, and where to send your alert notifications. Here, alerts are sent to a contact point, with the destination set as email. Alternatively, you can select other destinations supported by Grafana, such as Slack, Discord, Webhook, and more.

(7) Choose Save rule and exit.

(8) Check whether the alerting works.

When the alert condition is met, it triggers an alert. The alert rule state transitions to Firing, and the alert instance state transitions to Alerting. Additionally, an alert icon will appear on the Panel.