A high-speed Library Management System for the Desktop Web.
Now powered by a Cleaned SQL Architecture.
The Goal: Building a lightning-fast, persistent library management system for the modern desktop web.
The latest version of AeroLib introduces a Cleaned Feature architecture. We moved away from volatile, memory-heavy JSON lists to a Relational SQL Database.
Why this matters:
-
Instant Retrieval: Replaced manual Binary Search with B-Tree SQL Indexing. Finding a user is now
$O(\log n)$ at the hardware level. -
Data Integrity: Primary Key constraints prevent duplicate
coustomer_identries automatically. - Persistence: Your library data survives server restarts and crashes.
- Scalability: Optimized to handle 100,000+ records without slowing down the RAM.
- 🔍 Google Books Integration: Instant metadata fetching (Title, Author, Genre) via ISBN.
- 🛡️ Smart Deletion Safety: Users with unreturned books are protected from accidental deletion.
- ⚡ Hash Map Catalog: Books are stored in an
$O(1)$ Hash Map for the fastest possible UI response. - 🎨 Aero UI: A clean, responsive desktop webpage interface built with Streamlit.
Our SQL core is designed for efficiency:
CREATE TABLE customers (
coustomer_id INT PRIMARY KEY, -- Indexed unique identifier
name VARCHAR(50) NOT NULL,
email_id VARCHAR(100),
mobile_number BIGINT
);