PostgreSQL Client 4+

Name: PostgreSQL Client
Rating: 4.6 (114 reviews)
Author: Filippo Maguolo

Filippo Maguolo

- 4.6 • 114개의 평가

- 무료
- 앱 내 구입 제공

설명

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 maguolo.ios@outlook.com

2024년 7월 31일

버전 38.1

• Fix DDL table viewer
• Fix SQL editor crash

4.6/5

114개의 평가

Yup

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.

Many imperfections; unbeatable price

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!

Thanks a lot for the feedback and feel free to contact me for more.
I can add the you can select the text on the query windows to run only that part of sql.

Very good. Redshift mostly works too

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.