Python CLI Book Manager Personal Book Collection Manager

A Python and SQLite3-based application demonstrating full CRUD (Create, Read, Update, Delete) functionality.

This project showcases fundamental database interaction skills and a clean Command Line Interface (CLI) design.

Key Features (CRUD)

The application provides comprehensive management of your book collection:

• Create: Efficiently add new book entries to the database.
• Read: Retrieve and display a well-formatted list of all stored books.
• Update: Modify existing records, such as updating a book's status (e.g., 'Read'/'Unread') by its ID.
• Delete: Permanently remove specific book records from the system.

Tech Stack

• Language: Python 3.x
• Database: SQLite3 (Built-in, requires no additional installation).
• Architecture: Modular design with functional separation for clean and maintainable code.
• Security: Implemented Parameterized Queries to ensure protection against SQL Injection.

Installation & Usage

Follow these steps to run the project locally:

1. Clone the Repository:

   git clone https://github.com/yael-shr/python-Book-Manager.git
   cd python-Book-Manage

2. Set up a Virtual Environment (Recommended):

   python -m venv venv
   .\venv\Scripts\activate  # Windows (CMD/PowerShell)
   source venv/bin/activate # Linux/Mac OS
   

3. Run the Application:

   python app.py

First-Time Execution

Upon the first run, the system automatically initializes and creates the books.db file within the project directory.