JDbrowser
A terminal SQLite database browser. written in rust.
Install / Use
/learn @Jkeyuk/JDbrowserREADME
JDbrowser - Terminal TUI Sqlite Browser V1.4
Browse an Sqlite database from the terminal with a text user interface.
Usage
- Run the application from the directory containing the database.
jdbrowser
- Select your database from the initial file menu.
[!NOTE] File menu looks for files with extentions ".db", ".sqlite3", ".db3". To open databases with custom extenstions types, see "Open File Directly".
-
Use the keybindings to browse the tables and views of your database.
-
Copy data to clipboard with
ykey. ( On wayland clipboard text is cleared after exiting JDbrowser )
Open File Directly
You can open a database file directly by passing the file path as an argument.
jdbrowser -f file_name.my_wierd_extention
Key Binds
General
| Action | Keybind | | -------------- | --------------- | | Exit Application | Escape | | Help Menu Open/Close | ?|
File Menu
| Action | Keybind | | ------------- | -------------- | | Up | k | | Down | j | | Select | Enter |
Main view left side navigation
| Action | Keybind | | ------------- | -------------- | | Show Table/Views | q, e | | Up | shift + k | | Down | shift + j |
Table View
| Action | Keybind |
| ------------- | -------------- |
| View Data/Schema | shift + h, l |
| Page Up / Down Half | u, d |
| Move Cell Up | k |
| Move Cell Down | j |
| Move Cell Left| h |
| Move Cell Right | l |
| Yank Cell to Clipboard | y |
Installation and Building
No configuration needed.
Arch Linux
You can install JDbrowser from the AUR. Example using yay.
yay -S jdbrowser-git
Download Binary
Binaries are available for download Here
Simply download the binary run chmod +x ./jdbrowser and use where ever you want.
Install With Rust
A simple way to install the binary using Rust:
cargo install --path .
Build with Rust
A binary can also be directly built with:
cargo build --release
or:
64-bit Linux (kernel 3.2+, glibc 2.17+)
cargo build --release --target x86_64-unknown-linux-gnu
The binary will be available at target/release/jdbrowser
Screen Shots
TODO
- error handling popup
- handle blob data
