3 ms·

Hi. What tool do you use to access production database remotely? Say you need to browse some data, perform queries. Is there something like pgAdmin? I'm intere

• tmp_anon_22 5y ago
  Its SQLite so you would just copy the file and download it to a local machine for analysis through any number of tools. Presumably your setup would already be doing this as a form of backing up the data periodically.
• Glench 5y ago
  Copying and pasting my answer from another subthread: I just scp the whole database to my local machine and use "db Browser for SQLite" (a mac app) :) Would love to hear if there are other server-based db browsers for SQLite, though.
  • jprd 5y ago
    CloudBeaver works great for me, though I'm not doing anything intense. https://github.com/dbeaver/cloudbeaver/ https://github.com/dbeaver/cloudbeaver/
  • eatonphil 5y ago
    scp is the way I implemented querying a remote SQLite database under the hood in my data ide. Now that I think of it though I should probably add some clarification to docs or the UI that you're querying a local copy of the database and that your edits won't affect the original. https://github.com/multiprocessio/datastation https://github.com/multiprocessio/datastation
• irq-1 5y ago
  You can use the command line for sqlite on the server. There are lots of GUI tools if you copy the file local. Here's one I use https://sqlitestudio.pl https://sqlitestudio.pl
• justinclift 5y ago
  > Is there something like pgAdmin? A fairly well used GUI is https://sqlitebrowser.org https://sqlitebrowser.org (a project I help out personally).
• shedam 5y ago
  You can do that with adminer https://www.adminer.org/ https://www.adminer.org/