SQLiteFlow - SQLite Editor

SQLiteFlow - SQLite Editor


Manage your SQLite databases


FreeOffers In-App Purchases

6.2.1for iPhone, iPad
9.3
27 Ratings
晨亮 贾
Developer
8.9 MB
Size
Nov 15, 2023
Update Date
#152
in Developer Tools
4+
Age Rating
Age Rating
4+
Apps in this category do not contain restricted content.
9+
Apps in this category may contain mild or occasional cartoon, fantasy or real-life violence, as well as occasional or mild adult, sexually suggestive or horrifying content and may not be suitable for children under 9 years of age.
12+
Apps in this category may contain occasional mild indecent language, frequent or intense cartoon or real-life violence, minor or occasional adult or sexually suggestive material, and simulated gambling, and may be for children under 12 years of age.
17+
You must be at least 17 years old to access this App.
Apps in this category may contain frequent and intense offensive language; Frequent and intense cartoon, fantasy or realistic violence: frequent and intense adult, scary and sexually suggestive subjects: as well as sexual content, nudity, tobacco, alcohol and drugs, may not be suitable for children under 17 years of age.
SQLiteFlow - SQLite Editor Screenshots
SQLiteFlow - SQLite Editor posterSQLiteFlow - SQLite Editor posterSQLiteFlow - SQLite Editor posterSQLiteFlow - SQLite Editor posterSQLiteFlow - SQLite Editor posterSQLiteFlow - SQLite Editor posterSQLiteFlow - SQLite Editor posterSQLiteFlow - SQLite Editor poster
SQLiteFlow - SQLite Editor posterSQLiteFlow - SQLite Editor posterSQLiteFlow - SQLite Editor posterSQLiteFlow - SQLite Editor posterSQLiteFlow - SQLite Editor posterSQLiteFlow - SQLite Editor posterSQLiteFlow - SQLite Editor posterSQLiteFlow - SQLite Editor poster

About SQLiteFlow - SQLite Editor

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.

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.

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.

Shortcuts
• Supports "Run Query" action.
• Supports "Import CSV" action.
• Supports "Import JSON" action.
Show More

What's New in the Latest Version 6.2.1

Last updated on Nov 15, 2023
Old Versions
• Export, add an export type: List. The List type behaves similar with the list output mode in sqlite3 command line shell, but show BLOB data as empty. Available on Data Editor, Query Editor and Run Query Shortcuts action.
• Data Editor, supports show 16 bytes BLOB as UUID string. You can go to Settings - Data Editor to enable it.
Show More
Version History
6.2.1
Nov 15, 2023
• Export, add an export type: List. The List type behaves similar with the list output mode in sqlite3 command line shell, but show BLOB data as empty. Available on Data Editor, Query Editor and Run Query Shortcuts action.
• Data Editor, supports show 16 bytes BLOB as UUID string. You can go to Settings - Data Editor to enable it.
6.2.0
Nov 6, 2023
• Supports import JSON to a table.
• Shortcuts. Supports import JSON to a table. Requires iOS 16.4 or later.
• Allows user changing file extension in Browse.
• UI enhancement.
6.1.0
Oct 15, 2023
• Fix a bunch of compatible issues with the latest version of iOS.
• This version of SQLiteFlow now requires iOS 16.1 or later.
6.0.0
Apr 11, 2023
• Database Diff. Supports use primary key instead of RowID to pair to diff, and this option is enabled by default now.
• Shortcuts. The Run Query action now offers an option to exclude query message in result.
• This version of SQLiteFlow now requires iOS 15.0 or later.
5.8.6
Dec 11, 2022
• Query Editor. Supports find text. (Require iOS 16 or later.)
• Table Schema. Add extra space at top to make context info more clearer. And the extra space is also a trick to avoid back button be tapped by accident.
• Additional bug fixes and stability improvements.
5.8.5
Oct 27, 2022
• Bug fixes and stability improvements.
5.8.4
Oct 23, 2022
• Bug fixes and stability improvements.
5.8.3
Sep 20, 2022
• Bug fixes and stability improvements.
5.8.2
Jul 20, 2022
• Import CSV, supports transpose rows and columns when import.
• Import CSV, if “First Line in CSV is Header” is enabled, and is set to import to an existing table, then if the sequence of the header fields is different from the sequence of the table fields, you can now import it correctly.
• Import CSV, if “First Line in CSV is Header” is enabled, and is set to import to an existing table, then if the header fields is a subset of the table fields, you can now import it correctly if database constraints allows.
5.8.0
Jun 27, 2022
• Bug fixes and stability improvements.
5.7.2
Jun 11, 2022
• Bug fixes and stability improvements.
5.7.1
Jun 1, 2022
• Fix a potential crash issue when editing query.
• Additional bug fixes and stability improvements.
5.7.0
May 22, 2022
• The speed of loading databases has been significantly improved.
• Data Editor, upgrade show blob as image to show blob as preview. So blob data can not only display as image if possible, but also can display as some other types based on its content if possible, like movie, pdf, etc.
• Data Editor, supports use filter when view views.
• Supports enable or disable display table record counts when open database.
• Import CSV, supports display CSV Data through Quick Look. (Please note that during our test, if the CSV data is too large to display in a short time, then it will be displayed as a brief file info instead of a full CSV content.)
5.3.1
Mar 30, 2022
• Bug fixes and stability improvements.
5.3.0
Sep 29, 2021
• Data Editor, more convenient filter behavior.
• Query Editor, supports customize syntax highlighting.
• Additional bug fixes and stability improvements.
5.1.2
Aug 18, 2021
• Shortcuts, allows "Run Query" and "Import CSV" run when device is locked to make it convenient for automation purpose.
5.1.1
Aug 12, 2021
• Bug fixes and stability improvements.
5.1.0
Aug 3, 2021
• UI enhancement.
• Query Editor, supports syntax aware indenting when typing Return.
• Additional bug fixes and stability improvements.
5.0.5
May 21, 2021
• When the app's language is set to Simplified Chinese, Query Editor's SQL auto-completion feature now supports use Pinyin to search specific table names or fields.
5.0.4
May 17, 2021
• Enhancement to the code auto completion behavior.
5.0.3
May 16, 2021
• Enhancement to the code auto completion behavior.
5.0.2
May 12, 2021
• Enhancement to the code auto completion behavior.
• Additional bug fixes and stability improvements.
4.8.4
Apr 12, 2021
• Shortcuts. When running an intent, SQLiteFlow now will try to download required files like database files, CSV files, etc, which are offloaded before actually do its job.
4.8.3
Mar 14, 2021
• Fix an issue that may cause when exporting table to insert statements, the column names not suitably been escaped.
4.8.2
Jan 10, 2021
• Support for Japanese.

SQLiteFlow - SQLite Editor FAQ

Click here to learn how to download SQLiteFlow - SQLite Editor in restricted country or region.
Check the following list to see the minimum requirements of SQLiteFlow - SQLite Editor.
iPhone
Requires iOS 16.1 or later.
iPad
Requires iPadOS 16.1 or later.
SQLiteFlow - SQLite Editor supports English, Japanese, Simplified Chinese, Traditional Chinese
SQLiteFlow - SQLite Editor contains in-app purchases. Please check the pricing plan as below:
2-week Trial
$0.00
Full App
$9.99

SQLiteFlow - SQLite Editor Alternative

You May Also Like