Post a reply

Before posting, please read how to report bug or request support effectively.

Bug reports without an attached log file are usually useless.

Options
Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)

Options

Topic review

Freitag

Re: How to open Sqlite database using WINSCP.

khansam wrote:

Hi.

I access linux based handheld terminals from a windows pc using winscp, to support remote users.
I often need to copy sqlite database on windows PC to make any changes, and need to repush the same to remote linux Handheld terminals.Can somebody share the method of acessing sqlite database directly from winscp window. Rather than copying it on Windows PC and opening it.


You may have a local sqllite editor that you can use, but even if you set up WinSCP to open the editor for you, in teh background it will copy the file to a local temporary directory and then upload it back to the server when it sees the file changed.

In order to be able to edit locally without bringin the file over you'd have to have some kind of server running on the remote side that understands sqllite file format and presents a user interface (like phpMyAdmin does for MySQL via a web page)

This link (<invalid hyperlink removed by admin>) describes 3 different servers (not all in one place) that have the functionality you are describing.
khansam

How to open Sqlite database using WINSCP.

Hi.

I access linux based handheld terminals from a windows pc using winscp, to support remote users.
I often need to copy sqlite database on windows PC to make any changes, and need to repush the same to remote linux Handheld terminals.Can somebody share the method of acessing sqlite database directly from winscp window. Rather than copying it on Windows PC and opening it.