Issue
I need to connect to a Sqlite3 database in a 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 the local computer where Python is running. I tried to search for but could not find any solution to this. Any help is appreciated!
Solution
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.
Answered By - hd1 Answer Checked By - Katrina (WPSolving Volunteer)