Pharmacy Management System Using Python and SQLITE
International Scientific Journal of Engineering and Management · 06.08.2026 · 05 (08) · 1-9
DOI: 10.55041/isjem08465 ↗Kurz gefasst
Fachartikel in der Zeitschrift International Scientific Journal of Engineering and Management, online erschienen am 06.08.2026. Verfasst von Kiran Kiran und 2 weiteren Autor:innen.
Abstract (Originalsprache)
The manual management of pharmacy operations — including inventory tracking, billing, and supplier records — is time-consuming and highly susceptible to human error. Issues such as incorrect stock counts, expired medicine dispensation, and delayed billing are common in small and medium-sized pharmacies that continue to rely on registers and spreadsheets. This project, “Pharmacy Management System Using Python and SQLite,” presents a lightweight, desktop-based software solution designed to automate and streamline these day-to-day operations. The system is developed using Python as the core programming language and SQLite as the embedded relational database, making it portable, easy to deploy, and free of external database server dependencies. The application provides modules for medicine inventory management, supplier management, sales and billing, stock-level monitoring, and report generation. A simple, role-based login mechanism restricts access to authorised staff. The system was developed following the Software Development Life Cycle (SDLC), beginning with requirement analysis and progressing through design, implementation, and testing. Various diagrams, including the system architecture, Data Flow Diagrams (DFDs), and an Entity-Relationship (ER) diagram, were used to model the system prior to implementation. Unit and integration testing were carried out on all core modules to validate correctness. The resulting application successfully reduces manual effort, minimises billing errors, provides real-time visibility into stock levels, and generates low-stock alerts to prevent stock-outs. The project demonstrates how a combination of Python and SQLite can be used to build a functional, low-cost management information system suitable for small-scale retail pharmacies, and it concludes with a discussion of possible future enhancements such as a graphical user interface, barcode scanning, and cloud synchronisation. Keywords: Pharmacy Management System, Python, SQLite, Inventory Management, Billing System, DBMS.
Zitieren
APA
Kiran, K., Basavarajappa, B., & Sripalreddy, P. (2026). Pharmacy Management System Using Python and SQLITE. International Scientific Journal of Engineering and Management, 05(08), 1-9. https://doi.org/10.55041/isjem08465
Vancouver
Kiran K, Basavarajappa B, Sripalreddy P. Pharmacy Management System Using Python and SQLITE. International Scientific Journal of Engineering and Management. 2026;05(08):1-9. doi:10.55041/isjem08465
BibTeX
@article{Kiran2026,
author = {Kiran, Kiran and Basavarajappa, Basavarajappa and Sripalreddy, P},
title = {Pharmacy Management System Using Python and SQLITE},
journal = {International Scientific Journal of Engineering and Management},
year = {2026},
volume = {05},
number = {08},
pages = {1--9},
doi = {10.55041/isjem08465}
}
EUVIMED