ZeQLplus: A Fast Terminal SQLite Database Browser

Summary
ZeQLplus is an open-source terminal-based SQLite database browser designed for speed and simplicity. It provides a lightweight solution for interacting with SQLite databases directly from your command line, supporting various platforms. Users can efficiently browse tables, view paginated rows, and execute custom SQL queries.
Repository Info
Tags
Click on any tag to explore related repositories
Introduction
ZeQLplus is an open-source terminal SQLite database browser developed by ZetloStudio. Written in Vlang, it offers a fast, lightweight, and cross-platform solution for managing your SQLite databases directly from the command line. With ZeQLplus, you can easily open any SQLite database file, list tables, browse paginated rows, and run custom SQL queries.
Key features include:
- Open any SQLite database file
- Very fast performance
- Runs in a Terminal / CMD window
- Tiny executable with no dependencies
- List all tables in the database to browse
- Paginated view of table rows
- Run custom SQL queries and view the results
- Cross-platform compatibility: macOS, Linux, Windows
- Open source under the MIT License
Installation
Getting started with ZeQLplus is straightforward. You have two primary options for installation:
Pre-built Binaries
Pre-built binaries for macOS, Linux, and Windows 10+ are available as zip files on the releases page. Simply download the appropriate zip file for your operating system, extract its contents, and run the executable directly. No additional installation steps are required.
Building from Source
If you prefer to build ZeQLplus from its source code, you will need Vlang v0.4.10 or above installed on your system.
- First, ensure you have installed V.
- Clone the ZeQLplus repository from GitHub.
- Navigate to the cloned directory in your terminal.
- Build the executable in production mode using the following command:
v -prod -skip-unused . -o zeql
Examples
Once installed, using ZeQLplus is simple. From your command line in a Terminal or CMD window, execute the zeql command followed by the path to your SQLite database file:
zeql <database_filename>
It is recommended to move the zeql executable to a location included in your system's PATH for easier access.
Sample SQLite Database
To test ZeQLplus's functionality, you can download a sample SQLite database, such as the Chinook SQLite database.
Why Use ZeQLplus?
ZeQLplus stands out as an excellent choice for anyone needing to interact with SQLite databases from the terminal due to several compelling reasons:
- Speed and Efficiency: Built with Vlang, ZeQLplus is exceptionally fast and has a tiny footprint, making it highly efficient.
- No Dependencies: The executable is self-contained, requiring no external dependencies to run.
- Cross-Platform: It runs seamlessly across macOS, Linux, and Windows, providing a consistent experience regardless of your operating system.
- Terminal-Native: For developers and users who prefer command-line interfaces, ZeQLplus integrates perfectly into their workflow.
- Open Source: Being open source, it benefits from community contributions and transparency, offering a reliable and customizable tool.
Links
- GitHub Repository: ZetloStudio/ZeQLplus
- Releases Page: ZeQLplus Releases
- Vlang: The V Programming Language
- Sample Database: Chinook SQLite Database