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.
Snap can be installed from the command line on openSUSE Leap 15.x and Tumbleweed.
You need first add the snappy repository from the terminal. Choose the appropriate command depending on your installed openSUSE flavor.
Tumbleweed:
sudo zypper addrepo --refresh https://download.opensuse.org/repositories/system:/snappy/openSUSE_Tumbleweed snappy
Leap 15.x:
sudo zypper addrepo --refresh https://download.opensuse.org/repositories/system:/snappy/openSUSE_Leap_15.6 snappy
If needed, Swap out openSUSE_Leap_15. for, openSUSE_Leap_16.0 if you’re using a different version of openSUSE.
With the repository added, import its GPG key:
sudo zypper --gpg-auto-import-keys refresh
Finally, upgrade the package cache to include the new snappy repository:
sudo zypper dup --from snappy
Snap can now be installed with the following:
sudo zypper install snapd
You then need to either reboot, logout/login or source /etc/profile to have /snap/bin added to PATH.
Additionally, enable and start both the snapd and the snapd.apparmor services with the following commands:
sudo systemctl enable --now snapd
sudo systemctl enable --now snapd.apparmor
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.