search

fr-ser / grafana-sqlite-datasource

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

Encryption support with sqlite-jdbc-crypt #95

Closed bradygt closed 1 year ago

bradygt commented 1 year ago

I'm using https://github.com/Willena/sqlite-jdbc-crypt to secure connection to the database. Is it possible to support that in this Grafana datasource plugin?

fr-ser commented 1 year ago

I am not actually aware how this tool works. If you create/use a database via this sqlite-jdbc-crypt tool, can you open the database with any other program, too?

bradygt commented 1 year ago

I have only ever used that library to open it. I would think that you could with the same cipher settings and key but that's not my area of expertise either.

fr-ser commented 1 year ago

I don't have the setup to test this Java tool. If you could try out opening a database created with the java tool with the SQLite CLI command, then it could tell me if I can support that or not.

It might be also worth asking in the Github repo of that encryption, tool, though how other tools are supposed to work with it (that don't use Java for example). Reimplementing the cipher settings from this tool in this Grafana plugin does not seem like a scalable solution, though. Maybe another tool uses different settings for example. 🤔

stale[bot] commented 1 year ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.