Start a new topic

remote sqlite DB?

Is there a way I can use a sqlite db located on a remote server I can access with public key authentication?

Hi Stephan,

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`

Login or Signup to post a comment