Virtual Bookshelf: Flask Website with SQLite Database Integration

Overview

the Virtual Bookshelf project the process of seamlessly integrating an SQLite database into a Flask website, creating a virtual bookshelf accessible at localhost:5000. In this project, you will learn how to perform essential CRUD (Create, Read, Update, Delete) operations on the database, allowing you to manage your personal library with ease.

Installation

1. Clone the repository:

              git clone https://github.com/Siya016/Virtual-Bookshelf.git

2. Navigate to the project directory:

              cd Virtual-Bookshelf

3. Install dependencies:

            pip install -r requirements.txt

Tech Stack

• Flask: A lightweight web framework for Python.
• SQLite: A serverless, self-contained, and zero-configuration database engine.

Project Structure

The project structure is organized as follows:

.

• add.html: Template for adding new books.
• index.html: Template for displaying the book list.
• edit_rating.html: Template for editing book ratings.
• __init__.py: Initialization file for the Flask application.
• main.py: Main application file.
• book.db: SQLite database file.
• requirements.txt: List of dependencies.
• README.md: Project documentation.

CRUD Operations

• Create (C):
  • Add new books to the library using the Flask application.
• Read (R):
  • Retrieve and display the list of books in the library.
• Update (U):
  • Modify existing book details in the library.
• Delete (D):
  • Remove books from the library.

Visit http://localhost:5000 in your web browser to access your virtual bookshelf.

Features

• Add Books:
  • Easily add new books to your virtual library.
• View Book List:
  • Access a comprehensive list of all the books in your library.
• Check Library Status:
  • See if your library is empty or populated with books.