Remote Sqlite?

I'm on windows 10 with a standard python 2.7 remote interpreter on centos6.

to manually view sqlite I've been using bash in my ssh console or downloading the sqlite db file locally and using the pycharm database tool. 

I noticed in the tool for db connections it has options for ssh forwarding and a url for sqlite. 

Is it possible to set it up so that the pycharm db tool uses a ssh url/path to connect to the db on the other server? 

I'm just talking about doing this for some basic verifying and maybe writing some queries or editing the schema so I don't have to download it, make changes and then upload it again.

 

Please sign in to leave a comment.