Bite is a command-line interface tool for viewing and interacting with SQLite databases. It provides an easy-to-use, interactive way to explore SQLite database contents directly from your terminal.
- Browse tables in SQLite databases
- View table contents with pagination
- Sort table data by columns
- Search within tables
- Horizontal scrolling for wide tables
To install Bite, follow these steps:
-
Clone the repository:
-
git clone https://github.com/NhSimple/bite.git cd bite
-
Install the package: pip install -e .
After installation, you can use Bite by running: bite <path_to_sqlite_database>
For example: bite mydatabase.db
Once you've opened a database, you can:
- Use arrow keys to navigate through tables and data
- Press 'q' to quit the current view or the application
- Press 's' to sort by a column
- Press 'f' to search within the current table
- Use 'h' and 'l' to scroll horizontally in wide tables
- Use Page Up and Page Down to navigate through pages of data
- Python 3.6+
- blessed
- simple-term-menu
Contributions to Bite are welcome! Please feel free to submit a Pull Request.
This project is licensed under the MIT License.
Created by NhSimple