Portbase vs PatchDoc

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.

Patchdoc is a local file tool for iPhone and iPad, designed to open, edit, preview, save and organize all common documents. Core Features - Edit TXT, Markdown, JSON, YAML, CSV, XML, HTML, SVG, LaTeX, source code and configuration files - Create new files including TXT, Markdown, Python, C++ and other code documents - Markdown: toggle between source code and preview modes; export as HTML or PDF - HTML: toggle between source code and preview modes; export to PDF - PDF tools: reading, annotation, signature, image/text stickers, page management, cropping, compression and format conversion - Archive support: preview directories and inner files inside ZIP, RAR, 7Z, TAR archives, plus decompression - Image editor: crop, rotate, color adjustment, text overlay, brush drawing and mosaic blur - Video toolkit: playback, frame capture, rotation, mute audio, compressed export and SRT subtitle preview - Built-in local storage: create folders, import files, search, move, rename, delete, compress, pin items, add notes, and transfer files over LAN - WebDAV / FTP access: read-only browsing with file import; mount external folders or single files - Home screen widgets for quick shortcuts