Efficient Record-Keeping: A GUI-Based Python Library Management System
Article Sidebar
Main Article Content
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.
Downloads
References
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
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
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
GeeksforGeeks. (2025, July 11). Introduction to SQLite. https://www.geeksforgeeks.org/introduction-to-sqlite/
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
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
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
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
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
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
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
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
Singh, P. (2024). Library management system. Gurukul Multidisciplinary Research Journal, 407–417. https://doi.org/10.69758/jubi7297
Urwin, M. (2025, April 24). What is SQLite?. https://builtin.com/learn/sqlite
Valdez, J. P. (2022). Usability evaluation of library management system: A user experience approach. Library Philosophy and Practice. https://scholarworks.sjsu.edu/libphilprac/8165

This work is licensed under a Creative Commons Attribution 4.0 International License.
All articles published in our journal are licensed under CC-BY 4.0, which permits authors to retain copyright of their work. This license allows for unrestricted use, sharing, and reproduction of the articles, provided that proper credit is given to the original authors and the source.