How Can I connect to Sqlite3 database over SSH using Python?

Question

I need to connect to a Sqlite3 database in Linux box over SSH. I tried to connect through SSH and then connect to database separately but that did not work. That only connected to the Linux box but made another database (instead of connect) in local computer where Python is running. I tried to search for but could not find any solution to this. Any help is appreciated!

Answer 1

If you can forward the SQLite3 port, you can point python to the forwarded port and it will just work. You may want to set up rqlite to expose your sqlite3 database over TCP easily.