5 ms·

How do you access remotely, from your workstation, to the SQLite database on your server, while it is still serving requests?

• cheez 8y ago
  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.