<< back

SQLiteFlow 6.5.0

SQLite editor aiming to be intuitive, stable and reliable to use

Category: Developer Tools
Price: Free
Popularity: Low
Version String: 6.5.0 (169)
Release Date: 2024-10-03
Architecture: Intel & AppleSilicon(ARM)
Minimum OS: macOS 13.0
Vendor Name: Chenliang Jia
Homepage: www.sqliteflow.com

Version History 6.5.0 (169)

• Query Editor. Explain and Explain Query Plan now respect to user selection text.
• Alter Table. Fix an issue that may cause editing indexed columns by choosing an item from a popup menu item have no effect.
• Purchase Plan. Fix an issue that may cause Purchase Plan page displays unexpectedly when app launches.
• Inside Explorer. When open a database file, the temp database journal files will no longer flush to main file automatically.
• Inside Explorer. Fix an issue that may lead to app crashes.
• Shortcut. Run Query action. Fix an issue that when query is empty and the setting Include Query Message in Result in turned on, query message is not included in result.
• Additional bug fixes and stability improvements.

Description:

Two-week free trial! SQLiteFlow is an SQLite editor for Mac & iOS which is intuitive, stable and reliable to use.

It contains features:

Query Editor
• Multi-query execution.
• Customize syntax highlighting.
• SQL auto-completion.
• Format query.
• Copy query with custom style.
• 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 image.
• Copy data to CSV.

Alter Table
• View, edit or add table fields, indexes, foreign keys, checks.
• View triggers.
• View DDL.
• Preview the query that for altering table.

Remote Connect
• Supports open remote SQLite databases on iPhone or iPad with SQLiteFlow(iOS) installed.

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. (* Requires macOS 10.13+)

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.

Dark Mode
• Supports Dark Mode for macOS Mojave.

Drag and Drop
• Open databases and sql scripts.
• Create multiple windows.

Handle Database File Name or Directory Changes
• For instance, 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 feature that could save lots of your time from writing ATTACH DATABASE commands.

REGEXP operator
• Supports REGEXP operator for local databases when 'REGEXP operator' is enabled in Preferences.