Database editor for SQLite 3.
Ranked in these QuestionsQuestion Ranking
Pros
Pro Intuitive, stable and reliable
A very great GUI tool for SQLite on macOS. It's intuitive, stable and reliable.
Pro Handle database file name or directory changes automatically
This is a feature that once you found it exists, you can't leave it!
Pro Query editor
The query editor not only has some common features that most editor has like auto completion, syntax highlighting, it also has features like format query, copy query to custom style. And copy query to custom style means you can copy query to most languages (like C, C++, Objective-C, Swift, Java, etc) quoted string after some configuration, and yes, this is another feature that SQLiteFlow can save your time.
Pro Remote connect
Supports open remote SQLite database in iPhone or iPad with SQLiteFlow(iOS) installed.
Pro Attach opened databases through UI
This is a useful feature if you deal with attach database thing in your daily work, very convenient, save your time from writing ATTACH DATABASE commands.
Pro Convenient data viewer
View, edit, add or search table's data directly through UI without any code. And table's data in data viewer can be copied to CSV with only few clicks.
Pro Alter table GUI tool
SQLiteFlow has an alter table GUI tool to help you maintenance your database structure without any pain to write alter table query, instead it can generate the query for you after you tell SQLiteFlow in UI that what need to be changed.
Pro Available on App Store
SQLiteFlow can be purchased and downloaded from Mac App Store.
Pro Inside explorer
Show inside data structure of SQLite database file, journal file, WAL file or WAL-Index file.
Pro Database diff
Supports generate SQL text that can let you transform a database into another. Supports show only a summary of the differences between two databases.
Pro Dark Mode
Supports Dark Mode for macOS Mojave.
Pro Database statistics
Display table counts and each table’s record count.
Display each table’s storage consumed and storage consumed detail, including table data storage consumed and indexes storage consumed.
Cons
Con Database encryption is not supported
SQLiteFlow use system embedded SQLite library which makes database encryption within SQLiteFlow not available.
Commonly Compared
Alternative Products
