I need to inspect an SQLite file on Mac. What viewer should I use? Requirements: Free, ideally open source; Browse schema, data. Run queries; Bonus if updated in near real time when the file is modified by an external program, no need to click 'Refresh'. Datum is a streamlined and efficient OS X application that provides you with all the necessary tools for managing, editing, and organizing SQLite databases. Efficient database editor that doesn’t stray off the common SQLite editor look. As you would expect from an SQLite database manager such.
Introduction
SQLiteFlow is an SQLite editor for Mac & iOS which is intuitive, stable and reliable to use.
Platform
macOS 10.13+ / iOS 13.0+
Download
Version 4.6.1 | Sep 15, 2020 | Release Notes
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.
Query Editor - Multi-query Execution
Query Editor - Copy Query with Custom Style and It’s Setting
Data Editor
View, edit or add table data.
View table data with a convenient data filter.
Edit blob as hex, show blob as image if possible.
Copy data to CSV.
Data Editor
Table Schema
View, edit or add table fields, indexes, foreign keys, checks.
View triggers.
View DDL.
Preview the query that for altering table.
Alter Table - Fields
Alter Table - Preview
Import
Supports import CSV data.
Import from CSV Text
Dark Mode
Supports Dark Mode for macOS 10.14+.
Database Statistics
Display table counts and each table’s record count.
Display total size of each table, size of each table’s content and size of each table’s indexes.
Database Statistics
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.
Remote Connect
Supports open remote SQLite database in iPhone or iPad with SQLiteFlow(iOS) installed.
Remote Connect
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.
Attach Opened Databases
Drag and Drop
Drag and drop to open databases and sql scripts.
Create multiple windows.
Inside Explorer
Show inside data structure of SQLite database file, journal file, WAL file and WAL-Index file.
Inside Explorer
Handle Database File Name or Directory Changes
For instance, this makes SQLiteFlow can work friendly with your SQLite databases in iOS simulator.
REGEXP operator
Supports REGEXP operator for local databases when ‘REGEXP operator’ is enabled in Preferences.
Languages
English | 简体中文 (Chinese, Simplified) | 繁體中文 (Chinese, Traditional)
Support or Contact
Have any questions or feature requests? Please feel free to create an issue.
(Please consider sponsoring us on Patreon ?)
Windows
Our latest release (3.12.0) for Windows:
Note - If for any reason the standard Windows release does not work(e.g. gives an error), try a nightly build (below).
Nightly builds often fix bugs reported after the last release. ?
macOS
Our latest release (3.12.0) for macOS:
Homebrew
If you prefer using Homebrew for macOS, our latest release can be installed via Homebrew Cask:
Nightly builds
Download nightly builds for Windows and macOS here:
Linux
DB Browser for SQLite works well on Linux.
Arch Linux
Arch Linux provides an up to date version
Install with the following command:
Fedora
Install for Fedora (i386 and x86_64) by issuing the following command:
openSUSE
Debian
Note that Debian focuses more on stability rather than newest features. Therefore packages will typically contain some older version, compared to the latest release.
Update the cache using:
Install the package using:
Ubuntu and Derivatives
Stable release
For Ubuntu and derivaties, @deepsidhu1313provides a PPA with the latest release here:
To add this ppa just type in these commands in terminal: Vk music for mac os.
Then update the cache using:
Install the package using:
Ubuntu 14.04.X, 15.04.X, 15.10.X and 16.04.X are supported for now (untilLaunchpad decides to discontinue building for any series).
Ubuntu Precise (12.04) and Utopic (14.10) are not supported:
Precise does not have a new enough Qt package in its repository by default,which is a dependency
Launchpad does not support Utopic any more, which has reached its End ofLife
Nightly builds
Nightly builds are available here:
To add this ppa, type these commands into the terminal:
Then update the cache using:
Install the package using:
Other Linux
On others, compile DB4S using the instructionsin BUILDING.md.
FreeBSD
DB Browser for SQLite works well on FreeBSD, and there is a port for it (thanksto lbartoletti ?). DB4S can be installedusing either this command: