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
- Clone the repository:
git clone https://github.com/Siya016/Virtual-Bookshelf.git
- Navigate to the project directory:
cd Virtual-Bookshelf
- 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.