Designing a Library Management System Using Python and SQLite: A Scalable Digital Framework for Academic Use

Dinesh Vimalan

Abstract: This paper presents a Library Management System (LMS) developed using Python and SQLite to automate and streamline routine library operations such as book issuance, returns, and record tracking. The system addresses the limitations of manual methods such as data duplication, misplacement of records, and inefficient tracking by offering a scalable, user-friendly interface and real-time access to inventory and borrower information. Designed for academic and public libraries, the LMS supports core functionalities like adding, updating, and deleting records, ensuring ease of use and reduced administrative burden. It also outlines necessary software and hardware requirements to ensure broad compatibility. By enhancing accuracy and efficiency, the proposed system contributes to the digital transformation of library services.

Keywords: library automation, Python, SQLite, book management, user interface

How to Cite?: Dinesh Vimalan, "Designing a Library Management System Using Python and SQLite: A Scalable Digital Framework for Academic Use", Volume 14 Issue 6, June 2025, International Journal of Science and Research (IJSR), Pages: 427-432, https://www.ijsr.net/getabstract.php?paperid=SR25604192108, DOI: https://dx.doi.org/10.21275/SR25604192108