Efficient Record-Keeping: A GUI-Based Python Library Management System

Manual library record-keeping often leads to misplaced records, slow book searching, inaccurate borrower tracking, and difficulty in monitoring available and borrowed books. To address these problems, this study developed Efficient Record-Keeping: A GUI-Based Python Library Management System, a desktop-based application designed to help manage library book records and borrowing transactions in a faster, more organized, and more accurate way. The system was developed using Python as the main programming language, a graphical user interface for user interaction, and SQLite as the database management system for permanent record storage. The system includes essential library management features such as adding book records, viewing available books, searching book information, editing book details, deleting records, borrowing books, returning books, and generating reports. Through database integration, book and borrower records remain saved even after the program is closed. The system also reduces manual work by allowing users to retrieve records quickly and update book status efficiently. Overall, the developed Library Management System provides a practical and user-friendly solution for improving library record-keeping, book monitoring, and borrowing management.

Library Management System, Python, SQLite, Graphical User Interface, Book Records, Borrowing Management, Record-Keeping

1. Ariyanti, A., & Supriyanto, W. (2023). Optimizing user interface and user experience: Exploring design improvements for the school library system. International Journal of Scientific and Academic Research, 5(2), 45–53. https://ijsar.net/index.php/ijsar/article/view/144 [Google Scholar] [Crossref]

2. Dagogo, D. (2024). Library automation in the 21st century: Challenges and prospects. Information Managers: A Journal of Nigerian Library Association, Rivers State Chapter. https://doi.org/10.61955/liaukn [Google Scholar] [Crossref]

3. Eldaniz, M., & Dashqin, M. (2025). Modern problems of library and information resources management. Zenodo (CERN European Organization for Nuclear Research). https://doi.org/10.5281/zenodo.17187844 [Google Scholar] [Crossref]

4. GeeksforGeeks. (2025, July 11). Introduction to SQLite. https://www.geeksforgeeks.org/introduction-to-sqlite/ [Google Scholar] [Crossref]

5. Jaiswal, G. K., & Pandey, P. K. (2024). Assessing the challenges and issues of implementing library automation in library: A study. ShodhKosh Journal of Visual and Performing Arts, 5(6). https://doi.org/10.29121/shodhkosh.v5.i6.2024.5238 [Google Scholar] [Crossref]

6. Kumar, R., & Singh, P. (2022). Design and development of a web-based library management information system. International Conference on Business Information Systems. https://icobits.ubhinus.ac.id/index.php/ICoBITS/article/view/81 [Google Scholar] [Crossref]

7. Lathifuddin, A. S., Zakariya, A., Rahmawan, A. G., Saragih, D., & Bekti, F. K. (2026). Design and development of a web-based library management information system. ICoBITS, 1, 701–704. https://doi.org/10.32664/icobits.v1.81 [Google Scholar] [Crossref]

8. Lwoga, E. T., & Sangeda, R. Z. (2021). The impact of usability, functionality and reliability on users’ satisfaction during library system adoption. Tanzania Journal of Information Technology, 3(1), 15–27. https://journals.iaa.ac.tz/index.php/tji/article/view/13 [Google Scholar] [Crossref]

9. Mardiyati, S., Pauziah, U., & Sutrisno, D. (2025). Design and creation of book inventory management system in school library. RIGGS Journal of Artificial Intelligence and Digital Business, 4(2), 5524–5530. https://doi.org/10.31004/riggs.v4i2.1405 [Google Scholar] [Crossref]

10. Nurfadillah, S., & Rahman, A. (2023). Usability testing on Online Public Access Catalog (OPAC) interface of SLiMS 8.0 Akasia in BNPB library. Jurnal Pustakawan Indonesia, 22(1), 34–44. https://journal.ipb.ac.id/index.php/jpi/article/view/25673 [Google Scholar] [Crossref]

11. Rijal, M. A. (2024). Customization of KOHA integrated library system (ILS) interface for better usability. Access: An International Journal of Nepal Library Association, 3(1), 55–67. https://www.nepjol.info/index.php/access/article/view/59004 [Google Scholar] [Crossref]

12. Siregar, F., & Wahyuni, D. (2023). Analysis of user interface and user experience on Senayan Library Management System (SLiMS). Lentera Pustaka, 9(1), 21–30. https://journal.uinmataram.ac.id/index.php/light/article/view/8805 [Google Scholar] [Crossref]

13. Singh, P. (2024). Library management system. Gurukul Multidisciplinary Research Journal, 407–417. https://doi.org/10.69758/jubi7297 [Google Scholar] [Crossref]

14. Urwin, M. (2025, April 24). What is SQLite?. https://builtin.com/learn/sqlite [Google Scholar] [Crossref]

15. Valdez, J. P. (2022). Usability evaluation of library management system: A user experience approach. Library Philosophy and Practice. https://scholarworks.sjsu.edu/libphilprac/8165 [Google Scholar] [Crossref]

• Enhancing Formation Control of Multi Agent Systems Using Ann Based Technique
• Improving Sliding Mode Control with Chattering Reduction using Fuzzy Based Technique
• Cooking Quality, Fasting Blood Glucose, Glycemic Index and Load of High–Fiber Noodles Made from Wheat, Tiger Nut Residue and Cassava Flour Blends
• Matrix Rhythm Therapy Versus Interferential Therapy Combined with Lumbar Stabilization Exercises in Chronic Non-Specific Low Back Pain: A Randomized Comparative Trial
• Formulation and Sensory Evaluation of Functional Cake Prepared from Sweet Potato Powder