Feature request: server-less remote sqlite access via ssh

[cameronelliott]

Is your feature request related to a problem? Please describe. Yes, I use a mac for doing remote work to linux where my sqlite db lives

Describe the solution you'd like I want to access and administer my sqlite db file on a remote linux box, from my Mac, over ssh.

Additional context Sure, the default model for sqlite is as an in-process embedded database, but there are different ways to make it accessible for remote access via ssh.

Additional context

Dbbeaver also allows editing sqlite over ssh: https://github.com/dbeaver/dbeaver/wiki/Database-driver-SQLite#secure-connection-configurations https://github.com/dbeaver/dbeaver/issues/6876#issuecomment-1246913626

This is an blog post on an open source project (dead) which allows sqlite admin access over ssh. https://ricardoanderegg.com/posts/sqlite-remote-explorer-gui/ https://github.com/litements/litexplore

notes on changing sqlite to access a remote copy https://arc.net/l/quote/vfzlszys

[cameronelliott]

If you want to discuss the many various approaches of doing this, let me know. It seems the basic approaches are:

1. Run sqlite in json output mode like litexplore
2. Replace the virtual file system code in the sqlite source code to do SFTP reads and writes over ssh
3. Research how DBeaver does it, and consider that approach
4. Some kind of leveraging of sshfs to enable mounting of filesystems (sounds brittle, and admin-heavy)

[stefansaasen]

Hey @cameronelliott, thanks for taking the time to write this up.

I agree that this would be quite useful. But this is not something I will likely be adding in the near future. All the options are quite involved and I need to balance this with the other work/feature requests I already have for the existing mode of operation.

I will leave this open to gauge interest in the feature and will keep you posted when/if I have plans of addressing this.

Thanks again for your report!