Navicat for PostgreSQL vs Portbase

***** Navicat Premium named “Best Database Administration Solution” by Database Trends and Applications Magazine ***** ** First Complete iOS Database GUI ** Navicat for PostgreSQL is the first complete database administration tool developed for iOS, giving you the power to manage your databases on the go. Whether you are working from an iPhone or an iPad, Navicat frees you from your workstation. Navicat has a whole new set of features aimed at making your database administration portable and at enhancing the classic Navicat experience. Sync your connections and queries to Navicat Cloud, or organize your work through a UI-enhanced multi-tasking workflow. Navicat is compatible with PostgreSQL and has sophisticated features that provide professional developers with the tools they need, but are accessible and easy-to-learn for users new to database servers. Navicat Cloud - Get real-time connections and queries anytime, anywhere. - Create projects to share connections & queries with your team members. - Add members and define each member role in the project. - Get visibility into your team activities from the Activity Log. Simplify Your Data Editing - Add, modify, delete with an iOS-centric UI. - Zoom into tables for optimum clarity. - Use filters to isolate and find data. - Anchor and view connected databases. Streamline Your Queries - Construct queries with our code completion feature. - Select properties and SQL keywords from a suggestion list. Control Your Objects - Create, modify, and design database objects. - Field Type Prediction predicts field types based on input. - Avoid complex SQL editing.. Increase Your Productivity - Multi-task with the Tab View. - View Tables and Objects in a unified workspace. - Simultaneously access Tables and Objects across different servers. Choose Your Connections - Establish secure SSH/SSL sessions through SSH/SSL Tunneling. - Strong authentication and secure encryption. - Bypass ISP restrictions with HTTP Tunneling. For more detail about Navicat, please visit: https://www.navicat.com/en/products/navicat-for-postgresql ** For technical questions, please visit: https://help.navicat.com/hc/en-us

Portbase is a database client for MySQL, MariaDB, PostgreSQL, MongoDB, SQLite, Redis, ClickHouse and Elasticsearch on iPhone and iPad. • SQL consoles with autosaved drafts, completion, formatting, Explain and execution at the cursor. • Browse supported schemas, views, indexes, keys and DDL; follow related SQL rows. • Resize, pin, hide and sort result columns. Select and copy cell ranges. • MongoDB Find, Aggregation and Command editors with typed BSON document editing, table views and charts. • Create local SQLite databases or import a consistent snapshot. Files stay on this device. • Browse Redis keys with SCAN; inspect strings, hashes, lists, sets, sorted sets and streams; manage expiration and reviewed writes. • Query ClickHouse over HTTP(S). Inspect Elasticsearch mappings, search documents and aggregations. • Inspect chart points, filter dates, open matching loaded rows and export PNG/PDF. • Save unlimited connections, queries and charts, with Trash and recovery. • TLS and SSH connection options. Connection secrets stay in this device’s Keychain. Operations vary by engine. Manual Commit/Rollback is available for MySQL, MariaDB and PostgreSQL. CSV/JSON import and full query export are available for MySQL, MariaDB, PostgreSQL, MongoDB and SQLite; other engines export loaded results. Tables display up to 10,000 rows. Charts inspect loaded results; full exports respect the query’s filters and limits. MongoDB document editing requires MongoDB 4.2 or later and a transaction-capable replica set or sharded cluster. Redis supports standalone endpoints, without Cluster/Sentinel discovery or scripting. SQLite commands commit individually; manual console transactions and temporary objects are unavailable.