SQLiteFlow - SQLite Editor
macOS / developpeurs
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.
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 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). One use case is that you can debug query performance issue on your iPhone or iPad directly through your Mac.
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/
Quoi de neuf dans la dernière version ?
• Bug fixes and stability improvements.
