Is there a way I can use a sqlite db located on a remote server I can access with public key authentication?
As far as I know SQLite does not provide any network support.
Yes, I know. But you support ssh tunnel. So maybe there is a way to open a connection to the remote host in order to access the remote file.
After searching a bit I think it won't be feasible :(
But another idea could be to allow for an automatic scp when opening and when closing the connection? So an option to define a command which is run before the database is opened and one command which is run when the connection is finished. One can then define an `scp user@remote:/path/to/data.db locallocation` when opening and `scp locallocation/data.db user@remote:/path/to/data.db`