access Sqlite3 database over SSH

未计划

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



 

评论操作 固定链接

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

-4
评论操作 固定链接

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?

2
评论操作 固定链接

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
评论操作 固定链接

Try sshfs. It will not work directly in PyCharm.

0
评论操作 固定链接

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
评论操作 固定链接

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
评论操作 固定链接

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

请先登录再写评论。