SBist: School Library Management System

SBist: School Library Management System , developed by Santosh Bist, is a powerful desktop application built with Python and PyQt6, designed to streamline school library operations and administrative tasks. Optimized for Windows 10 and 11 (x64), SBist offers robust online and offline functionality, ensuring seamless management even in low-connectivity environments. With Firebase-powered multi-device synchronization, local MySQL storage, and role-based login, SBist is the ultimate solution for schools to manage books, fines, students, and staff efficiently. For support and updates, visit sbist.com.np.

Key Features

• Comprehensive Library Management: Effortlessly track book issuance, returns, renewals, and maximum books allowed per student with an intuitive interface.
• Role-Based Access Control: Secure login system for admins, staff, and students, ensuring data privacy with role-specific permissions.
• Offline & Online Modes: Initial online login retrieves data from Firebase, with subsequent offline access powered by a local MySQL database.
• Multi-Device Data Sync: Synchronize library, student, and staff data across multiple devices using Firebase for real-time updates when online.
• Fine Management: Automate fine calculations for late book returns or other policies, with detailed reporting for administrators.
• Student & Staff Management: Maintain detailed records of students and staff, including personal details, academic information, and attendance.
• Local Data Storage: Securely store all data in a MySQL database for fast access and reliability during offline use.
• Modern Interface: PyQt6-powered GUI delivers a responsive, user-friendly experience, minimizing the learning curve.
• Windows Compatibility: Fully optimized for Windows 10 and 11 (x64), with potential for future platform expansion.
• Secure & Scalable: Supports small schools to large institutions, with Firebase ensuring secure cloud synchronization.

Why Choose SBist?

SBist is tailored for schools and libraries seeking an affordable, feature-rich management solution. Its offline-first design ensures uninterrupted access in areas with limited internet, while Firebase integration keeps data consistent across devices. Developed by Santosh Bist, SBist includes comprehensive documentation, a sample MySQL schema, and dedicated support via sbist.com.np. Perfect for school librarians, administrators, and IT managers looking to optimize operations.

Ideal For

• School libraries and educational institutions
• Administrative offices managing student and staff data
• IT administrators overseeing school databases
• Organizations needing offline/online management tools

Technical Details

• Platform: Windows 10, 11 (x64)
• Framework: Python, PyQt6
• Database: Local MySQL (offline), Firebase (online sync)
• License: Commercial license for distribution
• Installation: Simple setup with included MySQL schema and Firebase configuration guide

What’s Included

• Full source code (Python, PyQt6)
• MySQL database schema
• Firebase setup documentation
• User manual for admins, staff, and students
• Sample data for testing
• 6 months of free support via sbist.com.np

Transform your school’s library and administrative efficiency with SBist—download now for smarter management!

Third-Party Assets & Licensing

This item utilizes the following third-party assets:

• Icons: Provided via the qtawesome Python library. Specific icon sets used (e.g., Material Design Icons by Google) are under licenses permissive for redistribution (e.g., Apache License 2.0). The qtawesome library itself is typically under a permissive license like MIT.
• Fonts: (Only list if you bundle specific non-standard fonts) Specify font name and its license here. If using standard system fonts, this line can be omitted.
• Python Libraries: Core dependencies like PyQt6 (GPL/Commercial License), firebase-admin (Apache 2.0), etc., are included via the installer or requirements.txt (for developers). Their respective licenses permit usage and bundling as done here. [Customize this list based on your actual dependencies]

Note on PyQt6 License: PyQt6 is available under the GPL or a commercial license from Riverbank Computing. If distributing the source code, end-users intending to use it in non-GPL compatible applications must obtain their own commercial license for PyQt6. The included installer uses the GPL version, suitable for the application’s distribution format.

All other code and assets are my original work, created specifically for this item. I confirm I have the full rights to use, modify, and resell all included components as part of this submission on CodeCanyon.