search

subhra74 / snowflake

Graphical SFTP client and terminal emulator with helpful utilities
GNU General Public License v3.0
2.18k stars 234 forks source link

Sqlite manager #115

Open megasoft78 opened 4 years ago

megasoft78 commented 4 years ago

Would it be possible to integrate a tool like this? https://sqlitebrowser.org/

subhra74 commented 4 years ago

if it takes the file as command line arguments like text editors, then it can be achieved easily.

megasoft78 commented 4 years ago

mmm, Not sure that approach will work. I imagine you mean automatically download the file and edit locally and then push it back to the server. For text file that can work but for database I don't think it will work as database are normally bigger and have concurrency problems. I think it should be more a sending commands to remote server and get the result from it instead of changing the file directly. It's probably more complicated. I'll stick with command line. :)

subhra74 commented 4 years ago

As per my knowledge sqllite db is just a single file, which can be downloaded and modified on local system and upload back. You are right about concurrency though it will not be safe to replace the sqllite file while some other application is already accessing the file( existing session )

Creating an interface for sqllite, is interesting enough, will try if it is possible in future

megasoft78 commented 4 years ago

Nice, thank you! ;)