School Library Management System v1.0.1

School Library Management System v1.0.1

A production-ready offline desktop application for managing school library books, students, book issues, returns, reports, backups, and Excel imports/exports.

What’s New

• Improved student Excel import performance
• Prevented duplicate students when importing the same Excel file again
• Prevented duplicate books and inventory quantity doubling
• Added safe batch import and duplicate detection
• Added background processing for long-running operations
• Improved application responsiveness during import, export, backup, and restore
• Added database schema versioning and migration support
• Added database integrity validation
• Improved backup and restore safety
• Added automatic rollback when restore fails
• Improved service-layer error handling
• Added timestamped Excel exports
• Improved student and book form validation
• Added uppercase normalization for student divisions
• Added search debouncing
• Improved large-table performance
• Preserved existing book issue and student borrowing history during updates

Features

• Book management
• Student management
• Book issue and return tracking
• Student borrowing history
• Pending and overdue return reports
• Excel import and export
• Database backup and restore
• Offline SQLite database
• Windows installer
• Automatic database initialization
• Duplicate-import protection

Verification

• All automated tests pass
• Large-dataset import and report workflows tested
• PyInstaller Windows build verified
• Inno Setup installation verified
• Existing user data is preserved during upgrades and uninstallation

Installation

1. Download SchoolLibraryManagement_Setup_1.0.1.exe.
2. Run the installer.
3. Follow the installation instructions.
4. Launch the application using the desktop or Start Menu shortcut.

Important

• The application works completely offline.
• Application data is stored separately under the Windows user data directory.
• Updating or uninstalling the program does not automatically delete library data.
• Always create a backup before performing a major update.

System Requirements

• Windows 10 or Windows 11
• 64-bit operating system
• No separate Python installation required