SQLite Query Analyzer is a lightweight and efficient desktop utility designed to simplify the process of managing SQLite databases.
It provides an intuitive interface for executing queries and direct table editing, making database operations seamless and straightforward.
Features
CLI Usage
SQLite Query Analyzer can be used as a command-line tool for automating database operations without the GUI. It supports several options for exporting data, executing SQL scripts, and more.
Help Text
$ sqlitequery --help
Usage: /snap/sqlitequery/3/bin/SQLiteQueryAnalyzer [options] database
A fast and lightweight cross-platform command line and GUI tool for querying and manipulating SQLite databases
Options:
-h, --help Displays help on commandline options.
--help-all Displays help, including generic Qt options.
-v, --version Displays version information.
-p, --progress Show progress during copy
-e, --export-csv Export data to CSV.
-d, --target-directory Target directory for export.
-r, --run-sql Execute SQL file.
Arguments:
database Database file to open.
Usage Examples
Opening a database in GUI mode:
sqlitequery /path/to/database.db
Exporting data to CSV files:
# Export all tables to CSV files in the current directory
sqlitequery --export-csv /path/to/database.db
# Export with progress indicator
sqlitequery --export-csv --progress /path/to/database.db
# Export to a specific directory
sqlitequery --export-csv --target-directory /path/to/export/folder /path/to/database.db
Executing SQL scripts:
# Execute a SQL script file against a database
sqlitequery --run-sql /path/to/script.sql /path/to/database.db
CLI Features
You are about to open
Do you wish to proceed?
Thank you for your report. Information you provided will help us investigate further.
There was an error while sending your report. Please try again later.
Snaps are applications packaged with all their dependencies to run on all popular Linux distributions from a single build. They update automatically and roll back gracefully.
Snaps are discoverable and installable from the Snap Store, an app store with an audience of millions.
On Arch Linux, snap can be installed from the Arch User Repository (AUR). The manual build process is the Arch-supported install method for AUR packages, and you’ll need the prerequisites installed before you can install any AUR package. You can then install snap with the following:
git clone https://aur.archlinux.org/snapd.git
cd snapd
makepkg -si
Once installed, the systemd unit that manages the main snap communication socket needs to be enabled:
sudo systemctl enable --now snapd.socket
If AppArmor is enabled in your system, enable the service which loads AppArmor profiles for snaps:
sudo systemctl enable --now snapd.apparmor.service
To enable classic snap support, enter the following to create a symbolic link between /var/lib/snapd/snap and /snap:
sudo ln -s /var/lib/snapd/snap /snap
Either log out and back in again, or restart your system, to ensure snap’s paths are updated correctly.
To install SQLite Query Analyzer, simply use the following command:
sudo snap install sqlitequery
Browse and find snaps from the convenience of your desktop using the snap store snap.
Interested to find out more about snaps? Want to publish your own application? Visit snapcraft.io now.