Is it supposed to work (or even planned) to be able to use the SQLite block with SSH? Currently it fails, while the script approach works.
Thanks, and keep up the good work!
Hi suhlig,
Can you try giving the full path to he file as in Sqlite block URI - #2 by ellie?
I’m afraid not! I’d love it if it could, though we would need to have some sort of agent installed on the remote that could run the queries + return results for us. Would that be acceptable for your environment?
Otherwise, we can sort something to make it more clear that those blocks will not function over SSH
ellie:
we would need to have some sort of agent installed on the remote that could run the queries + return results for us
Not knowing how it is implemented, I was assuming that the SSH block somehow provides a way to run arbitrary commands on that server (the script block appears to work that way).
IF the server has the sqlite cli installed, the SQLite block could invoke it remotely using the SSH connection. With the output mode set to ‘json’, the results could easily be parsed and inserted into the block.
That way no agent would be needed, but the sqlite cli being installed and of a compatible version is a big if.
I’d prefer that over installing an agent, but I see pros and cons for both approaches.