3 ms·

ssh user@server sqlite file://$PWD/db.sqlite?mode=ro

• ngrilly 8y ago
  Yes, 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.
  • Redoubts 8y ago
    There's https://sqlitebrowser.org https://sqlitebrowser.org, But I suppose you'll have to string up something if you want it to access a remote db.
    • ngrilly 8y ago
      There is also https://www.phpliteadmin.org https://www.phpliteadmin.org, but I'm not a fan of the user interface.
  • cheez 8y ago
    I use https://sqlitebrowser.org/ https://sqlitebrowser.org/ if I need to but primarily Jupyter w/ Pandas to explore and understand the data and prototype new queries.
    • ngrilly 8y ago
      Regarding SQLiteBrowser, I guess you have to download a copy of the database on your local workstation?
      • cheez 8y ago
        Correct. I use it rarely.
      • cheez 8y ago
        Just ran it using X remotely, so that's an option too.
  • marcosdumay 8y ago
    Whatever exists specifically for sqlite, sshfs is your friend too.