Re:You Are Not Google (2017)
by ngrilly on Friday April 05, 2019 @03:10AM
(#19580400)
How do you access remotely, from your workstation, to the SQLite database on your server, while it is still serving requests?
[ Parent
| on HN ]
ssh user@server
sqlite file://$PWD/db.sqlite?mode=roYes, this will work of course :-)
I was thinking of something more "graphical", similar to pgAdmin or SequelPro, when you need to navigate in a dataset.
I use https://sqlitebrowser.org/ if I need to but primarily Jupyter w/ Pandas to explore and understand the data and prototype new queries.
Regarding SQLiteBrowser, I guess you have to download a copy of the database on your local workstation?
Correct. I use it rarely.
Just ran it using X remotely, so that's an option too.
There's https://sqlitebrowser.org,
But I suppose you'll have to string up something if you want it to access a remote db.
There is also https://www.phpliteadmin.org, but I'm not a fan of the user interface.
Re:You Are Not Google (2017)
by marcosdumay on Saturday April 06, 2019 @02:36PM
(#19592279)
Whatever exists specifically for sqlite, sshfs is your friend too.