SQLiteFlow - SQLite Editor

Developer Tools • Updated 6 months ago

Download from App Store
Version 3.8.1 • Requires iOS 10.12 or newer

Created by:

Chenliang Jia

Price-Log

Current Price: FREE
  • πŸŽ‰ Dropped from $2.99 to $0.00
    9 months ago
  • πŸŽ‰ Dropped from $4.99 to $2.99
    10 months ago
  • πŸ˜• Increase from $3.99 to $4.99
    1 year ago
  • πŸ˜• Increase from $2.99 to $3.99
    1 year ago

Change-Log

Current Version: 3.8.1
  • πŸ”ƒ Updated to v3.7.0
    7 months ago
  • πŸ”ƒ Updated to v3.6.2
    8 months ago
  • πŸ”ƒ Updated to v3.6.1
    8 months ago
  • πŸ”ƒ Updated to v3.6.0
    8 months ago
  • πŸ”ƒ Updated to v3.5.6
    9 months ago
  • πŸ”ƒ Updated to v3.3.1
    11 months ago
  • πŸ”ƒ Updated to v3.3.0
    1 year ago
  • πŸ”ƒ Updated to v3.2.0
    1 year ago
  • πŸ”ƒ Updated to v3.1.0
    1 year ago
  • πŸ”ƒ Updated to v3.0.2
    1 year ago
  • πŸ”ƒ Updated to v3.0.1
    1 year ago
  • πŸ”ƒ Updated to v3.0.0
    1 year ago
  • πŸ”ƒ Updated to v2.2.1
    1 year ago
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 and show it as image if possible.
β€’ 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 SQLiteFlow(iOS).

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 to a table.

Export
β€’ In Data Editor, supports export data from a table/view to a CSV file.
β€’ In Query Result, supports export data from query result or query message to a CSV file.

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.

Inside Explorer
β€’ Show inside data structure of SQLite database file, journal file, WAL file or WAL-Index file.

Changelog

New in this version

β€’ Change 'Set NULL' to 'Set NULL & Apply' in Hex Editor.
β€’ Syntax Highlighting & Format Query now supports UPSERT clause and window function for compatible with the future version of macOS.
β€’ Additional bug fixes and stability improvements.

Videos about this app