PostgreSQL Client

PostgreSQL Client

By Filippo Maguolo

  • Category: Developer Tools
  • Release Date: 2017-05-16
  • Current Version: 39.1
  • Adult Rating: 4+
  • File Size: 70.10 MB
  • Developer: Filippo Maguolo
  • Compatibility: Requires iOS 14.0 or later.
Score: 4.5
4.58824
From 119 Ratings
Free On itunes

Description

PostgreSQL Client allow you to access your PostgreSQL database directly and without any server setup. You can manage your data with a very clean and simple iOS user interface. BASIC FEATURES: • Connection over SSL/TLS encryption with support for X.509 Certificate authentication • SSH tunnel build-in with password or key authentication (DSA, RSA, ECDSA, Ed25519, Secure Enclave Key) • Database authentication supported: plain, MD5 and SASL (SCRAM-SHA-256 and SCRAM-SHA-256-PLUS) • Table data: browse, filter, sort • Table structure: rename and drop for tables and columns • Browse of Standard View, Materialized Views, Functions and Procedures (v11) • View and edit Functions and Procedures • Free query with assisted composition and plan analysis • View database and table statistics • View and manage sessions • View server status graphs • View ER Diagram (interactive and with PNG/PDF export) • Server log file browser PRO FEATURES (with in-app purchase): • Login information stored in (local or iCloud) Keychain • Table structure: new table, add column, alter or drop • Table data: add, edit and delete record • Blob preview and export • Blob update (from iOS Photos or Files) • Geometry/geography data viewer (with PostGIS extension) • Export data grid to CSV, HTML, Json, NDJson, Excel and MSAccess(XML) format • Export table to CSV, NDJson and SQLite format • Import of CSV, NDJson or MSAccess(MDB/ACCDB) tables • Browsing of DB structure within a query or a record editor • iCloud Sync for saved query statements • Shortcuts support • Table/View updates in grid • JS script (with db access) Tested on PostgreSQL 9.5, 9.6, 10, 11 and 12. For feedback or suggestions write to [email protected]

Screenshots

Reviews

  • 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.

  • Finally an affordable pg client

    5
    By flojoto
    Very useful app. It might not look as nice as as SQL Pro, but it’s not crazy overpriced and has all the features you need including connecting through an SSH tunnel, saving favorite queries, an in-line editor and even a dark mode.

More by Filippo Maguolo

keyboard_arrow_up