22 releases (6 breaking)

new 0.8.2	Feb 11, 2025
0.8.0	Dec 12, 2024
0.7.1	Nov 13, 2024
0.6.1	Jul 26, 2024

#647 in Database interfaces

87 downloads per month

MIT license

7.5MB
5.5K SLoC

Tabiew

Tabiew is a lightweight TUI application that allows users to view and query tabular data files, such as CSV, Parquet, Arrow, and ...

Image Alt text

Features

⌨️ Vim-style keybindings
🛠️ SQL support
📊 Support for CSV, Parquet, JSON, JSONL, Arrow, FWF, and Sqlite
🔍 Fuzzy search
📝 Scripting support
🗂️ Multi-table functionality

Tutorial

For a guide on using Tabiew, including instructions on opening files, navigating tables, performing queries, and using inline queries, kindly visit the tutorial page.

Keybindings️

Key Combination	Functionality
`Enter`	Open record sheet
`k` or `Arrow Up`	Move up
`j` or `Arrow Down`	Move down
`h` or `Arrow Left`	Scroll left
`l` or `Arrow Right`	Scroll right
`e`	Toggle Auto-Fit
`Page Up` or `Ctrl+b`	Move one page up
`Page Down` or `Ctrl+f`	Move one page down
`H` or `Shift+Arrow Left`	Select previous tab
`L` or `Shift+Arrow Right`	Select next tab
`Ctrl+u`	Move up half a page
`Ctrl+d`	Move down half a page
`Home` or `g`	Move to the first row
`End` or `G`	Move to the last row
`Ctrl+r`	Reset the data frame
`q`	Close tab / sheet
`:`	Command Pallete
`/`	Fuzzy Search

Commands

Command	Example	Description
`Q` or `query`	`Q SELECT * FROM df`	Query the data in Structured Query Language(SQL). The table name is the file name without extension
`S` or `select`	`S price, area, bedrooms, parking`	Query current data frame for columns/functions
`F` or `filter`	`F price < 20000 AND bedrooms > 4`	Filter current data frame, keeping rows were the condition(s) match
`O` or `order`	`O area`	Sort current data frame by column(s)
`tabn`	`tabn SELECT * FORM user WHERE balance > 1000`	Create a new tab with the given query
`q` or `quit`	`q`	Return to table from sheet view otherwise quit
`schema`	`schema`	Show loaded data frame(s) alongside their path(s)
`reset`	`reset`	Reset the table to the original data frame
`help`	`help`	Show help menu

Installation

There are various ways to install Tabiew:

Arch Linux

You can install from the official repositories using pacman:

pacman -S tabiew

Debian-based

Download the .deb package from the GitHub releases page and run:

sudo dpkg -i <path_to_package.deb>

RPM-based

Download the .rpm package from the GitHub releases page and run:

sudo rpm -i <path_to_package.rpm>

MacOS

Installing Tabiew using Homebrew from Homebrew core:

brew update
brew install tabiew

or tap:

brew install shshemi/tabiew/tabiew

Note: Please be aware that installing Tabiew from the tap involves compiling it from the source, which may take some time to complete.

Cargo

Installing Tabiew from Crates.io:

cargo install tabiew

Build from Source

Ensure you have rustc version 1.80 (or higher) installed. Download the desired source version from the release page. Extract the downloaded file and navigate into the extracted directory. Then run the following command:

cargo build --release
cp ./target/release/tw <system_or_local_bin_path>

Usage

Start Tabiew with tw

tw <path_to_csv(s)>

To open TSV file(s), use:

tw <path_to_tsv(s)> --separator $'\t' --no-header

To open parquet file(s), use:

tw <path_to_parquet(s)> -f parquet

Themes

Monokai (default):

Image Alt text

Argonaut:

Image Alt text

Nord:

Image Alt text

Catppuccin:

Image Alt text

Tokyo Night:

Image Alt text

Terminal:

Image Alt text

Contributing

Contributions are welcome! Please fork the repository and submit pull requests with your features and bug fixes.

License

This project is licensed under the MIT License - see the LICENSE file for details.

Dependencies

~60–92MB
~1.5M SLoC