📚 Library Books Management System 📚

This Python-based program is designed to streamline the workflow of a hostel librarian by offering two main functionalities:

1. Book Data Management:
   • A data entry system to store and manage detailed records of books available in the library.
   • Includes information such as book name, author, cost, total pages, and stock status.
2. Customer Section:
   • Dedicated functionality to maintain records of college students who borrow books.
   • Tracks details like the borrower's name, book borrowed, and other necessary information for efficient library management.

This system uses CSV files for data storage, MySQL for database operations, and prettytable for presenting info in a clean, tabular format.
The program makes routine library tasks simpler and more organized, ensuring seamless management of both book inventory and student borrowing records.

Pre-requisites to Run the Code:

To ensure smooth execution, please set up the following:

• Install Python : Python Installation Guide
  

• Install MySQL or PyMySQL : MySQL Installation Guide or PyMySQL Installation Guide
  

• Set Up Python-MySQL Connectivity : Guide for Python-MySQL Connectivity
  

• Download PrettyTable : PrettyTable Library
  

• Download JetBrains Mono Font : JetBrains Mono Font
  
  

Guide to Run the Code Locally:

1. Clone the Repository:

Clone the GitHub repository to your local machine using Git: Open a terminal or command prompt on your PC. Run the following command:

git clone https://github.com/Aadii-01/Library-Books-Management-System.git

2. Navigation

Navigate to the directory where the repository was cloned and install the necessary libraries:

cd Library-Books-Management-System

3. Virtual environment setup (optional)

Create a virtual environment:

python -m venv venv

Activate on Windows:

.\venv\Scripts\activate

Activate on MacOS/Linux:

source venv/bin/activate

4. Install the required libraries (e.g., PyMySQL, PrettyTable):

pip install pymysql prettytable

Run the Code:

Once you have set up the environment and database: Open your terminal/command prompt, navigate to the project directory and run the Python script :

python code.py

That's It! 🎉

Thank you for checking out this project!. If you have any questions, suggestions, feel free to open an issue or reach out.
If you’d like to contribute, feel free to fork the repo and submit a pull request. All contributions are welcome! 😊