PyLiteAdmin

PyLiteAdmin is a simple command-line tool for browsing and editing SQLite databases, written in Python. It provides a user interface for viewing tables, searching for data, and performing basic CRUD (Create, Read, Update, Delete) operations. All inside of the terminal thanks to the Textual framework.

Features

• Use a TUI (Terminal User Interface) to view your sqlite database
• Search Columns
• Delete Rows
• Add Rows
• Edit Cell values
• Executable as "pyliteadmin /path/to/database.db"
• Add "paging" to ensure large databases are loaded and viewed efficiently

Installation

Install via PyPi

pip install pyliteadmin

Usage

pyliteadmin /path/to/database.db

This will start the PyLiteAdmin interface, which consists of three main components:

• Table Selector: allows you to select a table from the database.
• Table Viewer: displays the contents of the selected table.
• Table Search: allows you to search for data within the selected table.

You may need to expand your terminal window to make all of the elements fit

Use the Table Selector on the top left side of the terminal window to select which table you would like to view.

Use the "Search Column" widget on the bottom left side of the terminal window to search for a specific search term on the selected column. Returns a new table view with all matching/similar rows.

Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

License

MIT License