SQLiteFlow vs TablePro

Two-week free trial! So you can purchase SQLiteFlow after you know you like it! SQLiteFlow is an SQLite editor for Mac & iOS which is intuitive, stable and reliable to use. It contains features as described below: Browse • Manage files. Supports add, remove, duplicate, rename folders, SQLite databases, SQL files, CSV files, etc. • Supports import database from iCloud Drive by the file picker. • Supports open external SQL files, CSV files and Filter files. • Supports open external folders. Requires iOS 13.0 or iPadOS 13.0. • Supports show recents files. Query Editor • Multi-query execution. • Syntax highlighting. • SQL auto-completion. • Format query. Data Editor • View, edit or add table data. • Multiple cells/rows/columns selection. • View table data with a convenient filter. • Sort records by tapping on column title. • Edit blob data as hex or show it as preview if possible. Alter Table • View, edit or add table fields, indexes, foreign keys, checks. • View triggers. • View DDL. Table List • Supports display each table's name and records count. Connect • Supports let SQLiteFlow(macOS) connect databases in this app. One use case is that you can debug query performance issue on your iPhone or iPad directly through your Mac. Drag and Drop • Supports drag and drop to import or export SQLite databases and SQL files in iPad. Database Statistics • Supports show records count of each table. • Supports show total size of each table • Supports show size of each table's content. • Supports show size of each table's index. This feature may help you get more insight about your SQLite databases' data storage information, which may let you see if there're any chances to let SQLite working in a more effective way in your device. ER Diagram • Supports display ER diagram. • Supports toggle field type hide or show. • Supports Relationship Guessing. • Supports copy as Mermaid markdown. Database Diff • Supports generate SQL text that can let you transform a database content into another. • Supports show a summary of the differences between two databases. Import • Supports import CSV data. • Supports import JSON data. Export • In Data Editor or Query Results, supports export data to CSV, JSON, Markdown or List. • In Data Editor, supports export data to Insert Statement or Update Statement if possible. Multiple Windows • Supports multiple windows for iPadOS 13 or later. Dark Mode • Supports dark mode. visionOS • Supports visionOS. Shortcuts • Supports "Run Query" action. • Supports "Import CSV" action. • Supports "Import JSON" action. Create Function • Supports create scalar function using a simple JavaScript routine. Terms of Use: https://www.apple.com/legal/internet-services/itunes/dev/stdeula/

TablePro is a native database client for iPhone and iPad. Browse tables, run queries and edit rows, using the same connections you use in TablePro on the Mac. DATABASES - MySQL and MariaDB - PostgreSQL - Microsoft SQL Server - Oracle - MongoDB - ClickHouse - Redis - SQLite and DuckDB files on your device - TiDB and OceanBase - Amazon Redshift connections synced from the Mac - Cloudflare D1, with the database picked from your account's list BROWSE - Search tables and page through rows, 50 to 500 at a time - Sort by any column, search text columns, and stack filters with AND or OR - Show rows and query results as cards or as a grid with a pinned header and key column - Tap a foreign key to preview the row it points to, then open it - See the columns, indexes and foreign keys of any table - On iPad, the table list sits beside the open table EDIT - Open a row full screen, change values, set NULL and save - View and edit JSON values - Insert and delete rows, truncate or drop a table - Every save, insert and delete runs in a transaction - An open transaction shows on every tab, with Commit and Roll Back - Safe mode for each connection: Off, Confirm Writes or Read-Only QUERY - SQL editor with syntax highlighting - Suggestions for tables, columns and keywords as you type - Run the statement at the cursor or the whole script, and stop it while it runs - Saved queries, synced with your Mac - Copy or export results as JSON, CSV or SQL INSERT statements - Query history for each connection - Follow a running query in a Live Activity on the Lock Screen and in the Dynamic Island CONNECT SECURELY - SSH tunnels with a password, a private key or keyboard-interactive sign-in, with host key checks - SSH jump hosts and two-factor codes - SSL with CA and client certificates - Sign in with AWS IAM or Google Cloud IAM instead of a stored password - Passwords and private keys kept in the Keychain - Lock the app with Face ID, Touch ID or Optic ID WORKS WITH YOUR MAC - iCloud sync of connections, groups, tags and saved queries with TablePro for Mac, off until you turn it on - Password sync through iCloud Keychain, off by default - Continue an open connection on another device with Handoff - Import connections from a .tablepro file through Files or AirDrop ORGANIZE - Favorites, recent connections, groups and tags - Custom icons for connections and groups - A Quick Connect widget for your Home Screen - Shortcuts and Siri actions to open a connection or add rows to a table TRY IT FIRST Open the built-in Chinook sample database to browse, query and edit without setting up a server. PRIVACY Usage data is off unless you turn it on, and it never includes hostnames, usernames, passwords, queries or data.