Day 63 - 📚 Flask Book Library

A simple Flask + SQLAlchemy web app that lets users create and view a personal book library. This project demonstrates core backend concepts including routing, forms, database persistence, and template rendering.

README GENERATED BY AI

✨ Features

• 📖 View a list of books
• ➕ Add new books using a form
• 💾 Persistent storage with SQLite
• 🧠 ORM-based database modeling (SQLAlchemy)
• 🧾 Form handling & validation with Flask-WTF

🛠️ Tech Stack

• Python 3
• Flask
• Flask-SQLAlchemy
• Flask-WTF
• SQLite
• Jinja2

📂 Project Structure

. ├── main.py ├── books.db ├── templates/ │ ├── index.html │ └── add.html ├── static/ │ └── (optional CSS) └── README.md

🚀 Getting Started

1️⃣ Clone the repository

bash git clone https://github.com/your-username/your-repo-name.git cd your-repo-name

2️⃣ Install dependencies

bash pip install flask flask-sqlalchemy flask-wtf

3️⃣ Run the app

bash python main.py

You should see:

✅ Tables created

Then open:

http://127.0.0.1:5000/

🧪 Example Output

Dune - Frank Herbert - 9.5/10 The Midnight Library - Matt Haig - 8.7/10

📌 Notes

• The database is automatically created on startup
• SQLite is stored locally as books.db
• This project focuses on backend fundamentals, not styling

🌱 Future Improvements

• ✏️ Edit existing books
• 🗑️ Delete books
• ⭐ Sort by rating
• 🎨 Add CSS styling
• 🔐 User authentication

🏁 Final Thoughts

This project marks the first published project built on a MacBook and serves as a solid foundation for future Flask applications.

Built with curiosity, debugging pain, and a lot of learning 💪