Pharmacy Management System Using Python and SQLITE

Kiran1

PG Student

Department of CSE (M.Tech)

Lingaraj Appa Engineering College Bidar-585403, Karnataka, India

Email ID- kiran.ranjolkar@gmail.com

Basavarajappa2

Assistant Professor

Department of CSE

Lingaraj Appa Engineering College Bidar-585403, Karnataka, India

Email ID- bassusedam756@gmail.com

P Sripalreddy3

Associate Professor

Department of CSE

Lingaraj Appa Engineering College Bidar-585403, Karnataka, India

Email ID- sripal.patlola@gmail.com

ABSTRACT

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.