search

fr-ser / grafana-sqlite-datasource

Grafana Plugin to enable SQLite as a Datasource
Apache License 2.0
124 stars 17 forks source link

Build SQLite with JSON support #25

Closed ebarnard closed 3 years ago

ebarnard commented 3 years ago

This adds support for the built-in JSON1 extension which supports naively querying JSON data stored in an SQLite database.

The extension documentation can be found at https://www.sqlite.org/json1.html.

fr-ser commented 3 years ago

That looks like a neat feature. Sadly I am by no means an expert of compiling SQLite into a feature set, that is fitting :sweat_smile:

If you could add to the example SQLite database in the repo a new table with a single row of JSON-data and make a dashboard that uses it, it would help testing :ok_hand:

ebarnard commented 3 years ago

I had a go but the Grafana docker instance won't recognise the grafana-sqlite-datasource plugin.

I've moved to using Postgres instead of sqlite in order to use repeating panels so I won't be able to spend more time on this.

tejpochiraju commented 3 years ago

@fr-ser - I played around with the plugin yesterday and it works great! However, we will need JSON support so let me try my hand at building this PR and adding the dashboard you requested for testing.