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 includes the following features: Query Editor • Multi-query execution. • Customize syntax highlighting. • SQL auto-completion. • Format query. • Copy query as code. • Paste recent query sessions. • Explain query. Data Editor • View, edit, add or remove records. • View table data with a convenient data filter. • Edit blob data as hex or show it as preview if possible. • Edit JSONB as JSON. • Copy data to CSV，JSON, Markdown, and to Insert Statement or Update Statement if possible. Table Schema • View, edit or add table fields, indexes, foreign keys, checks. • View triggers. • View DDL. • Preview the query that for altering table. Database Statistics • Display tables count and each table's records count. • Display total size of each table, size of each table's content and size of each table's indexes. Database Diff • Supports generate SQL text that can let you transform a database into another. • Supports show a summary of the differences between two databases. Import • Supports import CSV data to a table. • Supports import JSON data to a table. • Supports import data by SQL file. 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. Database Encryption • Supports access encrypted SQLite database which is encrypted by SQLCipher library. Remote Connect • Supports open remote SQLite databases on SQLiteFlow(iOS). Dark Mode • Supports Dark Mode for macOS Mojave or later. Drag and Drop • Open databases and SQL scripts. • Create multiple windows. Access Apple simulator • Supports access Apple simulator. So you can open your app's Documents directory more easily than before when developing your apps. Handle Database File Name or Directory Changes • One of a cool thing that benefit from this feature is, this makes SQLiteFlow can work friendly with your SQLite databases in iOS simulator. Attach Database • Attach opened databases without any code. This is a very handy way to do attach database thing, and could save a lot of your time from writing ATTACH DATABASE commands if your business mode relies on it. Inside Explorer • Show binary data structure of SQLite database file, journal file, WAL file or WAL-Index file. Shortcuts • Supports "Run Query" action. • Supports "Import CSV" action. • Supports "Import JSON" action. (Requires macOS 14.0 or later.) Create Function • Supports create scalar function using a simple JavaScript routine. Load Extension • Supports SQLite load extension. LLDB Co-worker • Supports sfopen command. Let you open a copy of a temporary local database that originally in debugged device. • Supports sfsave command. Let you copy the temporary local database (that originally created by sfopen command) to debugged device. Terms of Use: https://www.apple.com/legal/internet-services/itunes/dev/stdeula/
