SQLiteFlow vs Hexer

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/

Hexer is a desktop level hex viewer packed with features. It was developed from the ground up for iOS and iPadOS. It is natural and intuitive to use for everyone. It is integrated with the Files app. So you can browse Dropbox, Google Drive, your git repositories, your downloads, your documents in iCloud Drive or your desktop. Or you can just share any file to it. Bytes are highlighted in different colors: Printable characters are cyan, spaces blue, null bytes grey, control characters pink and so on. The colors appear across the binary, hexadecimal, and ascii column — or can just be turned off completely. ▶ Many advanced options • Many popular themes from text editors and terminals • Line numbers (offsets) • Overscroll • Complete control over the formatting of what you copy or share • Column counts in powers of two (8 bytes, 16, 32, ...) or in any number that fits • Interpret bytes as ASCII, ISO Latin 1 or EBCDIC • The UI is navigable by keyboard and there are keyboard shortcuts to toggle almost everything • Further features for you to discover ▶ Search • Search for content in the hexadecimal, ASCII or binary column • Preview results with context and jump to and highlight them in the document • Filter results with Regular Expression and based on case sensitivity • Jump between results with arrow keys ▶ Analysis • Get information about the selection or the entire document • Decode to integers • See byte frequencies • See detected file signatures (magic numbers) • Read metadata like creation date and Unix permissions ▶ The App is made by a real person out of love When you buy the app (no hidden in app purchases) the money goes straight to me to support development. If you have any questions or feature requests you can just write me an email and let me know. I will continue development with many more planned features like editing. ▶ The App is friendly There are no in app purchases, ads, tracking, nor is there any data collected. You buy it once and then use it. Nothing more. Nothing less.