PostgreSQL Client 4+
Filippo Maguolo
-
- Free
- Offers In-App Purchases
Screenshots
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 maguolo.ios@outlook.com
What’s New
Version 38.1
• Fix DDL table viewer
• Fix SQL editor crash
Ratings and Reviews
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!
Developer Response ,
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.
App Privacy
The developer, Filippo Maguolo, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy.
Data Not Collected
The developer does not collect any data from this app.
Privacy practices may vary, for example, based on the features you use or your age. Learn More
Information
- Seller
- Filippo Maguolo
- Size
- 70.9 MB
- Category
- Developer Tools
- Compatibility
-
- iPhone
- Requires iOS 14.0 or later.
- iPad
- Requires iPadOS 14.0 or later.
- iPod touch
- Requires iOS 14.0 or later.
- Apple Vision
- Requires visionOS 1.0 or later.
- Languages
-
English
- Age Rating
- 4+
- Copyright
- © Filippo Maguolo
- Price
- Free
- In-App Purchases
-
- PRO FEATURES $8.99