PostgreSQL Client

PostgreSQL Client

By Filippo Maguolo

  • Category: Developer Tools
  • Release Date: 2017-05-16
  • Current Version: 41.2
  • Adult Rating: 4+
  • File Size: 78.43 MB
  • Developer: Filippo Maguolo
  • Compatibility: Requires iOS 15.0 or later.
Score: 4.57599
4.57599
From 125 Ratings
Free On itunes

Description

DB Compass for PostgreSQL allows you to access your PostgreSQL database directly and without any server setup. You can manage your data with a clean and simple iOS user interface. FEATURES: • Connection over TLS encryption and/or SSH tunnel • Database authentication supported: plain, MD5 and SASL (SCRAM-SHA-256 and SCRAM-SHA-256-PLUS) • SSH authentication support Secure Enclave Key and U2F/FIDO NFC Key • Assisted table creation and alter structure • Explore, filter, sort, and quick search table data • Query script with A.I. assisted composition and plan analysis • Database objects (tables, views, procedures, etc.) • Database statistics, sessions manager, server status graphs • ER Diagram Viewer • Advanced data grid for browse, edit, conditional formatting • Blob field preview, import and export • Job Activity Monitor • User list and Privileges • Import and Export in multiple formats • iCloud Sync for SQL and JS scripts • SQL plan analysis • Execute queries with Shortcuts App • Charts & Widgets OpenAI integration requires your key and is only available in allowed regions. Ollama integration requires your server to connect to. Tested on PostgreSQL 9.5, 9.6, 10, 11 and 12. -- This is a Premium app and some features may require an in-app lifetime unlock -- For feedback or suggestions contact info@dbcompass.net

Screenshots

Reviews

  • Connection lost immediately after switching to a different app

    1
    By ezioadi
    The app loses connection when I switch to notes or something to copy over some text. The results page cannot be rebooted or closed and the reconnecting process hangs up. So I have to logout from the server and start over. Is this a bug?

  • Was good

    5
    By Most Unhappy
    This app worked for several months, then suddenly I cannot connect to my existing database. After verifying Face ID, the “wheel” just spins until it gives up!

  • Good Value

    5
    By DaveXXIV
    I don’t know how much value of the pg app that cost $219 for a lifetime license over this one but for nine bucks it’s a no brainer.

  • Yup

    5
    By hallach
    It works, as others have mentioned it’s not “perfect” but it gets the job done when you need to access your databases on the go. Displays a form entry for your stored proc’s arguments too which is nifty! It’s all better than trying to manipulate psql through a terminal app on iOS thats for sure. And for a good price too.

  • Better than PGAdmin on Desktop

    5
    By JohnGalt131
    Fantastic app. Very feature rich, very stable. This is now my default means for db admin.

  • Lots of bugs but good idea

    3
    By Isleofgough
    Until yesterday's update, time fields were incorrect. For example 13:30:00 would show 1:00 AM. That was fixed but now you cannot add a new record that has a date and time field. There are nice clocks and calendars but they will not actually fill in a field. I had to purchase another front end for anything more than viewing data.

  • Many imperfections; unbeatable price

    4
    By Tcabeen
    Look, for the price, you’re not going to do better. The competition have enterprise-level subscription rates. This app has a fantastic hobbyist-level price. And that’s what I am, so it’s the only viable option for iPad as far as I can see. It works. It runs queries. It connects and reconnects beautifully. I’ve been creating tables, inserting data, parsing tens of thousands of records without trouble. It crashes sometimes (but brings all your saved queries right back up). The interface can’t run an individual query, only everything that’s in the current window. The query and the results are in different “tabs” but you can’t switch from the query tab to the results tab without exiting the tab because of the keyboard-helper bar along the bottom (the one that’s still there even when you’re on a hardware keyboard). So it lacks polish, sure, but it’s WAY faster and easier than typing out the queries from the CLI. And again, check out that outstanding price!

  • Excellent

    5
    By Jayson.T
    Great functionality at a very reasonable price. A must have!

  • Should be able to save 1 connection

    2
    By Minbari20170127
    At first this looked promising until the app crashed. Since you need the pro version to save even 1 connection, I had to re-enter all the connection info each time the app crashed on me. The free version should at least allow 1 saved connection. I hope the pro version doesn't crash as often as the free version. Too unstable for me to buy the pro version.

  • Very good. Redshift mostly works too

    5
    By Missing my tabs
    Very good postgresql support. But I bought because it is one of the few solutions able to work with Redshift. Seems to support about 90%. Which is good enough for emergency support on the go. Hopefully this helps others.

More by Filippo Maguolo

keyboard_arrow_up