How to connect to sqlite db on remote server?

Z

zdr2019-09-13 05:24:22

SQLite

zdr, 2019-09-13 05:24:22

On a remote machine (ubuntu), a python program is running that created a database (sqlite3), and writes some data there.
From time to time you need to look at what's in the database.
Question:
How can I remotely connect to the database from my home PC? Make selects.

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

�

Александр, 2019-09-13
@NeiroNx

Sqlite - файловая база. Нужна либо программа(локальная утилита способная делать запросы и выводить результат) на том сервере(и доступ на него RDP,SSH) либо скачивать базу целиком(FTP,SMB) и ковырять локально.

R

Román Mirilaczvili, 2019-09-13
@2ord

Connect via SSH and use the sqlite3 program for fetches. You don't need to download the file locally.