6.2.1
2023-11-15
• 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
2023-11-06
• 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
2023-10-15
• 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
2023-04-11
• 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
2022-12-11
• 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.4
2022-10-23
• Bug fixes and stability improvements.
5.8.3
2022-09-20
• Bug fixes and stability improvements.
5.8.2
2022-07-20
• 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
2022-06-27
• Bug fixes and stability improvements.
5.7.2
2022-06-11
• Bug fixes and stability improvements.
5.7.1
2022-06-01
• Fix a potential crash issue when editing query.
• Additional bug fixes and stability improvements.
5.7.0
2022-05-22
• 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
2022-03-30
• Bug fixes and stability improvements.
5.3.0
2021-09-29
• Data Editor, more convenient filter behavior.
• Query Editor, supports customize syntax highlighting.
• Additional bug fixes and stability improvements.
5.1.2
2021-08-18
• Shortcuts, allows "Run Query" and "Import CSV" run when device is locked to make it convenient for automation purpose.
4.8.2
2021-01-10
• Support for Japanese.
4.8.1
2020-12-15
• Bug fixes and stability improvements.
4.8.0
2020-12-14
• Data Editor, supports export data as insert/update statement.
• Supports dump database to a SQL file.
• Additional bug fixes and stability improvements.
4.6.2
2020-11-30
• Bug fixes and stability improvements.
4.6.1
2020-11-23
• Import CSV, now the default value of the option "First Line in CSV is Header" is "on", to make it consistent with the Export CSV feature.
• Import CSV, now supports truncate a table before importing.
• Add Shortcuts support. Now "Run Query" and "Import CSV" are available in the Shortcuts app. This feature requires iOS 14.0 or later.
4.6.0
2020-09-18
• Supports export data as JSON.
• Supports export data as Markdown.
• This version of SQLiteFlow now requires iOS 13 or later.
4.3.6
2020-09-07
• Bug fixes and stability improvements.
4.3.5
2020-08-06
• Data Editor, supports keyboard arrow keys to move selection between cells. Requires iOS 13.4 or iPadOS 13.4.
• Supports recognize SQLite databases with custom extensions if they can appear in Browse.
4.3.4
2020-07-08
• Filter in Data Editor now supports "!=" and "not contains" operator.
4.3.3
2020-07-03
• Supports rename table in Table List.
• Supports pick a journal mode (WAL or DELETE) when creating a database.
• Table Schema, supports reorder columns using drag and drop.
• Table Schema, add support for setting a table to WITHOUT ROWID table.
4.3.2
2020-06-19
• Bug fixes and stability improvements.
4.3.1
2020-06-09
• Bug fixes and stability improvements.
4.3.0
2020-06-08
• Format Query, allow user choose the prefer indent using Spaces or Tabs.
• Format Query, allow user to set indent width. Now the default indent width is 4 to match the default Tab Width which is also 4. The default indent width is 3 in previous versions when the value is not customizable.
• Format Query, allow user to set comma that split column definition style to leading or trailing.
• Text Editing, allow user to set tab width. The default tab width is 4.
• Text Editing, allow user to set the behavior of the Tab key to inserts tab character or inserts spaces.
• The setting ‘Enable Foreign Key Constraints’ now move from Data Editor to Settings - General, so now this setting will affects to Data Editor, Query Editor and Import CSV.
• Import CSV now supports use semicolon(;) as delimiter to import data.
4.2.0
2020-04-27
• Alter Table now supports show the SQL that altering the table.
• Improve the user experience of Alter Table.
• Improve the inputing experience in Query Editor when a hardware keyboard connected to device. Requires iOS 13.4 or iPadOS 13.4.
• Merge Query Editor and Query Result to same page.
• Additional bug fixes and stability improvements.
4.1.1
2020-03-28
• Bug fixes and stability improvements.
4.1.0
2020-03-26
• Supports multiple cells/rows/columns selection in Data Editor & Query Results.
• Supports run selected query in Query Editor.
• Fix an issue that may cause mark external file to Recents list failed.
• Additional bug fixes and stability improvements.
4.0.0
2019-12-31
• Database List now rename to Browse.
• Supports open/create local folders, SQLite databases, SQL files, CSV files in Browse.
• Supports open Filter files in Browse.
• Supports open external SQL files, CSV files and Filter files in Browse.
• Supports open external folders in Browse. Requires iOS 13.0 or iPadOS 13.0.
• Supports show recents files.
• Supports show blob data as hex in Query Result.
• Supports long press to show context menu preview for a record in Data Editor and Query Results. Requires iOS 13.0 or iPadOS 13.0.
• Add the ability to enable foreign key constraints in Data Editor.
• Add 'Done' button at the top of screen when editing in Data Editor to trigger saving data.
• Supports copy a row in Data Editor and Query Result.
• Now, filter in Data Editor is file based.
• Supports tap filter button to open or create a filter file in Data Editor.
• After opened a filter file, users can edit and apply a filter to Data Editor.
• After applied a filter in Data Editor, tap filter button, users can choose 'Edit Filter', 'Remove Filter' or 'Choose Another Filter'.
• Fix an issue that may cause unreadable code imported to table when import CSV data from a file.
• Fix an issue that cause can't copy data record in Query Result.
• Additional bug fixes and stability improvements.
3.9.3
2019-09-30
• Fix an issue that cause unwanted quotes translation after formatting a query in Query Editor.
3.9.2
2019-09-28
• Fix an issue that could lead the share sheet in Database List show empty.
3.9.1
2019-09-25
• Supports multiple windows for iPadOS 13.
3.9.0
2019-09-20
• Supports dark mode for iOS 13.
• Remove the global editing text field in Data Editor, so now you can edit data directly in the data field cell.
3.8.0
2019-08-22
• Syntax Highlighting & Format Query need to support UPSERT clause and window function for compatible with the future version of iOS.
• Fix an inputing issue when use Pinyin keyboard.
• Additional bug fixes and stability improvements.
3.7.0
2019-07-02
• Support for Chinese (Simplified), Chinese (Traditional).
• Additional bug fixes and stability improvements.
3.6.0
2019-06-20
• Hex Editor now supports save blob data to a file.
• Hex Editor now supports drag and drop to import data from another app like Files.
• Hex Editor now supports drag and drop an image to export it to another app like Files.
3.5.0
2019-06-18
• Supports edit blob as hex.
• Supports show blob as image if possible.
• Supports IS NULL and IS NOT NULL filter in Data Editor
• Supports create sample database.
• Fix an issue that cause load database failed when a database contains virtual table that use an unknown module.
3.4.0
2019-05-07
• Supports export table/view data and query result to CSV format.
3.3.0
2019-04-18
• Supports import CSV data.
3.2.0
2019-04-12
Data Viewer
• Supports sort records by tap on column title.
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 into another.
• Supports show a summary of the differences between two databases.
3.1.0
2019-04-04
• Supports drag and drop to import or export SQLite databases and SQL files.
• Supports use a document picker to import SQLite databases and SQL files.
• Additional bug fixes and stability improvements.
3.0.3
2018-08-03
• Fix an issue that may cause 'Copy to SQLiteFlow' from Files app have no response.
3.0.2
2018-08-03
• Fix an issue that may cause duplicate purchase.