access Sqlite3 database over SSH

Not planned

Hello,

I want to access may sqlite3 DB over SSH. I have no idea what I'm doing wrong.

host: example.com (direct connection)

port: 33322

Auth type: passwordless key pair



 

7 comments
Comment actions Permalink

You can't access to remote SQLite db, since DataGrip works through jdbc.

-1
Comment actions Permalink

Follow up on this?  Why can't Datagrip ssh tunnel to an SQLite db?  You can SSH to a postgres db and that also runs through jdbc?

1
Comment actions Permalink

I’m also interested in this topic, since my SQLite db is 11GB I would really like to edit the SQL locally in CLion and execute it remotely instead of downloading a local copy.

0
Comment actions Permalink

Try sshfs. It will not work directly in PyCharm.

0
Comment actions Permalink

Nice idea ;-) Already tried this before, but this isn’t a real solution, because if you select a relevant amount of data from the 11GB database. SSHFS of course also needs to download all this data in the background. This is only helpful if you only run queries with access to tables with very little data.

0
Comment actions Permalink

You're right. I know this not an answer for your question, but did you try this:

https://stackoverflow.com/questions/7682503/how-to-shrink-sqlite-database

And if yes and it didn't help, you probably should think about migrating to something stronger (mySql, Postgress, etc...)

0
Comment actions Permalink

Thanks. No, it’s part of the design of the application that it’s that big. It’s part of some research project running on cluster hardware. It is just collecting that much data. We won’t change it, because it is a key feature to use a server less DB. We do not intend to access it remotely in normal operation, it would be just nice for the developer for inspection purpose.

0

Please sign in to leave a comment.