Release v2.2.1

Release Notes

This is an official release of the Grafana SQLite plugin code. For some releases it takes a while
to also appear in the Grafana repository, which is used to populate the plugins for the Grafana
website as well as their grafana-cli. Some releases (especially pre-releases) from Github never
appear in the Grafana repository.

To install this specific release use one of the following methods.

More details can also be found in the installation section of the Readme.

Installation

Using the grafana-cli

1. Run this command:

   grafana-cli --pluginUrl https://github.com/fr-ser/grafana-sqlite-datasource/releases/download/v2.2.1/frser-sqlite-datasource-2.2.1.zip plugins install frser-sqlite-datasource

2. See the installation instructions in the Readme.

Manual Installation

1. Download the zip file below

2. Extract the zip file into the data/plugins subdirectory for Grafana: unzip <the_download_zip_file> -d <plugin_dir>/

   Finding the plugin directory can sometimes be a challenge as this is platform and settings
   dependent. A common location for this on Linux devices is /var/lib/grafana/plugins/

3. See the installation instructions in the Readme.

Changelog

For the full changelog see here.

Added

• An additional option securePathOptions has been added in case the user wants to protect some
  options (typically credentials). For examples see here:
  https://github.com/mattn/go-sqlite3#connection-string

Release v2.2.0

Release Notes

This is an official release of the Grafana SQLite plugin code. For some releases it takes a while
to also appear in the Grafana repository, which is used to populate the plugins for the Grafana
website as well as their grafana-cli. Some releases (especially pre-releases) from Github never
appear in the Grafana repository.

To install this specific release use one of the following methods.

More details can also be found in the installation section of the Readme.

Installation

Using the grafana-cli

1. Run this command:

   grafana-cli --pluginUrl https://github.com/fr-ser/grafana-sqlite-datasource/releases/download/v2.2.0/frser-sqlite-datasource-2.2.0.zip plugins install frser-sqlite-datasource

2. See the installation instructions in the Readme.

Manual Installation

1. Download the zip file below

2. Extract the zip file into the data/plugins subdirectory for Grafana: unzip <the_download_zip_file> -d <plugin_dir>/

   Finding the plugin directory can sometimes be a challenge as this is platform and settings
   dependent. A common location for this on Linux devices is /var/lib/grafana/plugins/

3. See the installation instructions in the Readme.

Changelog

For the full changelog see here.
The plugin now supports adding a Path Prefix and Options to the SQLite connection string.

Added

• Ability to provide a prefix and options in the connection string. For examples see here:
  https://github.com/mattn/go-sqlite3#connection-string

Changed

• slightly changed the Plugin Health Check (when adding the data source) to provide better error
  messages.
• conversion errors during a query are now logged at DEBUG level to avoid too large log files.

Release v2.2.0-rc.1

Release Notes

This is an official release of the Grafana SQLite plugin code. For some releases it takes a while
to also appear in the Grafana repository, which is used to populate the plugins for the Grafana
website as well as their grafana-cli. Some releases (especially pre-releases) from Github never
appear in the Grafana repository.

To install this specific release use one of the following methods.

More details can also be found in the installation section of the Readme.

Installation

Using the grafana-cli

1. Run this command:

   grafana-cli --pluginUrl https://github.com/fr-ser/grafana-sqlite-datasource/releases/download/v2.2.0-rc.1/frser-sqlite-datasource-2.2.0-rc.1.zip plugins install frser-sqlite-datasource

2. See the installation instructions in the Readme.

Manual Installation

1. Download the zip file below

2. Extract the zip file into the data/plugins subdirectory for Grafana: unzip <the_download_zip_file> -d <plugin_dir>/

   Finding the plugin directory can sometimes be a challenge as this is platform and settings
   dependent. A common location for this on Linux devices is /var/lib/grafana/plugins/

3. See the installation instructions in the Readme.

Changelog

For the full changelog see here.
The plugin now supports adding a Path Prefix and Options to the SQLite connection string.

Added

• Ability to provide a prefix and options in the connection string. For examples see here:
  https://github.com/mattn/go-sqlite3#connection-string

Changed

• slightly changed the Plugin Health Check (when adding the data source) to provide better error
  messages.

Release v2.1.1

Release Notes

This is an official release of the Grafana SQLite plugin code. For some releases it takes a while
to also appear in the Grafana repository, which is used to populate the plugins for the Grafana
website as well as their grafana-cli. Some releases (especially pre-releases) from Github never
appear in the Grafana repository

To install this specific release use one of the following methods.

More details can also be found in the installation section of the Readme.

Installation

Using the grafana-cli

1. Run this command:

   grafana-cli --pluginUrl https://github.com/fr-ser/grafana-sqlite-datasource/releases/download/v2.1.1/frser-sqlite-datasource-2.1.1.zip plugins install frser-sqlite-datasource

2. See the installation instructions in the Readme.

Manual Installation

1. Download the zip file below

2. Extract the zip file into the data/plugins subdirectory for Grafana: unzip <the_download_zip_file> -d <plugin_dir>/

   Finding the plugin directory can sometimes be a challenge as this is platform and settings
   dependent. A common location for this on Linux devices is /var/lib/grafana/plugins/

3. See the installation instructions in the Readme.

Changelog

For the full changelog see here.

This release adds support for sub second precision for unix time.

Added

• When using numeric values for a timestamp in SQLite (unix timestamp)
  the plugin now supports precision below the second (at nanosecond precision)

Release v2.1.0

[2.1.0]

This release adds the JSON extension to the compiled SQLite code.

Added

• JSON extension for SQLite

Release v2.0.2

[2.0.2]

This release adds testing against Grafana v8.1.0 and fixes an issue with query variables.

Fixed

• Query variables can now also be used in Grafana v8.X.X

Release v2.0.1

[2.0.1]

This release fixes some long standing issues that prevented the right use of the alerting feature
of the plugin even though it was enabled already.

Fixed

• Using the $__from and $__to variables for alerting
• Fixing a caching bug for the query (for alerting)

Release v2.0.1-rc.1

[2.0.1-rc.1]

This release fixes some long standing issues that prevented the right use of the alerting feature
of the plugin even though it was enabled already.

Fixed

• Using the $__from and $__to variables for alerting
• Fixing a caching bug for the query (for alerting)

Release v2.0.0

[2.0.0]

All current Raspberry Pi Zero and 1 models have an ARMv6 architecture.
All other models (2 Mod. B v1.2, 3 and 4) have an 64Bit ARMv8 architecture.
As only the Raspberry Pi 2 Mod. B has an ARMv7 architecture this is not used as default anymore.
The Raspberry Pi 2 Mod. B will require a manual installation and all others will be handled
via the Grafana CLI.

Changed

• Using ARMv6 instead of ARMv7 as 32Bit ARM default

Release v2.0.0-rc.1

[2.0.0-rc.1]

All current Raspberry PI Zero and 1 models have an ARMv6 architecture.
All other models (2 Mod. B v1.2, 3 and 4) have an 64Bit ARMv8 architecture.
As only the Raspberry Pi 2 Mod. B has an ARMv7 architecture this is not used as default anymore.
The Raspberry Pi 2 Mod. B will require a manual installation and all others will be handled
via the Grafana CLI.

Changed

• Using ARMv6 instead of ARMv7 as 32Bit ARM default