Shelfe
December 2024Software
Shelfe is a Streamlit-based web application built for a Database course. It allows users to manage their reading activities with features like authentication, CRUD operations, and search/filtering. The system uses MySQL for data storage and integrates the Open Library API to fetch book covers, creating a clean and interactive user experience.
A reading manager that combines database design, CRUD operations, and API integration into a personalized book tracking system.
Tech Stack
Python
Features
- User authentication with personalized book shelves
- Full CRUD operations for managing books and progress
- Search and filter by title, author, or reading status
- Dashboard with reading stats and progress tracking
- API-based book cover fetching for better UI
Challenges
- Designing proper relationships between database tables
- Slow search performance with larger data
- Managing joins and queries correctly
- Keeping data consistent across user sessions
Learnings
- Strong understanding of relational database design
- Hands-on experience with SQL queries and joins
- Learned how frontend connects with database systems
- Improved full-stack thinking with API integration