Lib.rs

› Database interfaces
#view #query #csv #csv-tsv #applications #value #separated

bin+lib tabiew

Tabiew is a lightweight, terminal-based application to view and query delimiter separated value formatted documents, such as CSV and TSV files

by shshemi

6 releases

new 0.3.3 May 21, 2024
0.3.2 May 14, 2024
0.2.1 May 10, 2024

#600 in Database interfaces

Download history 175/week @ 2024-05-05 472/week @ 2024-05-12 185/week @ 2024-05-19

832 downloads per month

MIT license

275KB
1K SLoC

Tabiew

Tabiew is a lightweight, terminal-based application to view and query delimiter separated value formatted documents, such as CSV and TSV files.

Image Alt text

Features

  • 📊 Table View: Explore your data with an easy-to-navigate table view.
  • 🔍 Detailed View: Dive deep with a detailed view of individual records.
  • 🛠️ SQL Query Capability: Utilize SQL for powerful data querying, such as filtering, sorting, and aggregations.
  • ⌨️ Vim Inspired Keybindings: Navigate through your data effortlessly using Vim-style keybindings.

Keybindings️

Key Combination Functionality
v Toggle detailed view
k or Arrow Up Move up in the table or scroll up in detailed view
j or Arrow Down Move down in the table or scroll down in detailed view
h or Arrow Left Move to the previous item in detailed view
l or Arrow Right Move to the next item in detailed view
Page Up or Ctrl+b Move one page up
Page Down or Ctrl+f Move one page down
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
q Quit
: Command mode

Commands

Command Example Description
:Q or :query :Q SELECT * FROM df Query the data in Structured Query Language (SQL). The table's name is 'df'
:S or :select :S price, area, bedrooms, parking Query the original for selected columns
:F or :filter :F price < 20000 AND bedrooms > 4 Query the original dataset where the condition(s) match
:O or :order :O area Query the original data frame ordering by requested columns
:goto :goto 10 Jumps to the specified line index
:moveup :moveup 10 Jump a specified number of lines up
:movedown :movedown 10 Jump a specified number of lines down
:q or :quit :q Quit Tabiew
:reset :reset Reset the table to the original data frame
:help :help Show help menu

Installation

There are various ways to install Tabiew:

Debian-based

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

sudo dpkg -i <path_to_package.deb>

RPM-based

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

sudo rpm -i <path_to_package.rpm>

Windows

Download the .exe file from the GitHub releases page and place it in a directory that is included in system's PATH environment variable.

Disclaimer: The Windows version may experience performance lag.

Cargo

Install Tabiew from Crates.io:

cargo install tabiew

Build from Source

Ensure you have the 1.80.0-nightly (or higher) version of Rust installed, then:

git clone https://github.com/shshemi/tabiew.git
cd tabiew
rustup override set nightly
cargo build --release
cp ./target/release/tabiew <system_or_local_bin_path>

Usage

Start Tabiew with tw

tw <path_to_csv>

Options:

  • --no-header: Use this option if the CSV file does not contain a header row.
  • --ignore-errors: Ignore parsing errors while loading the CSV file.
  • --infer-schema: Set the schema inference method. Options are no, fast, full, and safe.
  • --quote-char: Set the quote character.
  • --separator: Set the separator character.

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

~32–63MB
~1M SLoC