Grafana SQLite Datasource

This is a Grafana backend plugin to allow using a SQLite database as a data source.

Development and Contributing

Any contribution is welcome. Some information regarding the local setup can be found in the DEVELOPMENT.md file.

Plugin installation

The most up to date (but also most generic) information can always be found here: Grafana Website - Plugin Installation

Allowing unsigned plugins

Currently, the plugin is unsigned, which requires users to allow unsigned backend plugins. As of right now there is no process to sign a community plugin at all (see link).

To allow unsigned plugins, see the Grafana Configuration Documentation here.

Installing the Plugin on an Existing Grafana with the CLI

Grafana comes with a command line tool that can be used to install plugins.

1. Run this command: grafana-cli plugins install frser-sqlite-datasource
2. Restart the Grafana server.
3. Login in with a user that has admin rights. This is needed to create datasources.
4. To make sure the plugin was installed, check the list of installed datasources. Click the Plugins item in the main menu. Both core datasources and installed datasources will appear.

Installing the Plugin Manually on an Existing Grafana

If the server where Grafana is installed has no access to the Grafana.com server, then the plugin can be downloaded and manually copied to the server.

2. Get the zip file from https://github.com/fr-ser/grafana-sqlite-datasource/releases/latest
3. Extract the zip file into the data/plugins subdirectory for Grafana: unzip the_downloaded_file.zip -d YOUR_PLUGIN_DIR/frser-sqlite-datasource
4. Restart the Grafana server
5. To make sure the plugin was installed, check the list of installed datasources. Click the Plugins item in the main menu. Both core datasources and installed datasources will appear.

ARM6 / RaspberryPi Zero W support

This plugins supports ARM6 (the version running on RaspberryPi Zero W). There is a problem, though, with Grafana supporting ARM7 (newer Raspberries) and ARM6 at the same time. Grafana chooses the correct plugin by file name. But both ARM6 and ARM7 are named <plugin_dir>/frser-sqlite-datasource/dist/gpx_sqlite-datasource_linux_arm.

Currently the ARM7 build is named like this by default and ARM6 ist added as ..._arm6. In order to run this plugin on an ARM6 machine you need to rename the file <plugin_dir>/frser-sqlite-datasource/dist/gpx_sqlite-datasource_linux_arm6 to <plugin_dir>/frser-sqlite-datasource/dist/gpx_sqlite-datasource_linux_arm.

Configuring the datasource in Grafana

The only required configuration is the path to the SQLite database (local path on the Grafana Server)

1. Add an SQLite datasource.
2. Set the path to the database (the grafana process needs to find the SQLite database under this path).
3. Save the datasource and use it.