Portbase vs DBKit

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.

Connect to MySQL and PostgreSQL, or open local SQLite files on your iPhone or iPad. Write SQL, inspect tables, save reusable queries, and export results while away from your computer. DATABASES & CONNECTIONS • SQLite: Open local .sqlite and .db files, including when offline. • MySQL and PostgreSQL: Connect from your device to a database server you specify. A network connection and appropriate database permissions are required. • Database traffic does not require a DBKit relay server. EVERYDAY TOOLS • SQL editor with syntax highlighting and auto-completion. • Schema browser for columns, indexes, and foreign keys. • Searchable query history and named SQL snippets. • Table view of query results. • Result exports in CSV, TSV, JSON, SQL, and Markdown formats, ready to save or share. • Import SQL files or CSV data into a selected table. DATA & PRIVACY Connection passwords are stored in iOS Keychain. Execution history is stored locally, retains up to 500 recent entries, and can be deleted or cleared in the app. Remote queries and authentication information are sent to the database you specify. The developer does not collect your database contents. FREE & PRO Free use includes 3 executions per day on non-sample databases, resetting when the local date changes on your device. Sample databases are exempt. Upgrade to Pro to remove the daily execution limit. Subscription and lifetime purchase options, prices, and terms are shown on the in-app purchase screen. Terms of Use (EULA): https://www.apple.com/legal/internet-services/itunes/dev/stdeula/ Privacy Policy: https://leotan1990.github.io/databases/AppStore/privacy_en.html