Installing

From your distribution

Many Linux distributions have packaged Sqliteman for years. A package built from version 2 or later is this program; one at 1.2 or older is the Qt 4 original, which is no longer maintained.

From source

The source is on GitHub, github.com/pvanek/sqliteman. It builds with CMake on Linux, macOS and Windows; see building for what it needs and how.

In short:

git clone https://github.com/pvanek/sqliteman.git
cmake -S sqliteman -B build
cmake --build build
cmake --install build          # or run build/src/app/sqliteman

Which SQLite

Sqliteman needs SQLite 3.38 or later, built with column metadata, as most distributions build it. When the system has no such SQLite, or when asked to with -DSQLITEMAN_BUNDLED_SQLITE=ON, the build downloads a pinned SQLite and puts it inside the program. That copy comes with full-text search (FTS4 and FTS5), R*Tree and Geopoly, the math functions and the dbstat table switched on.

The status bar of the main window says which SQLite the program runs on.