NB
Back to Selected Projects
Software EngineeringStatus: CompletedYear: 2024

RyMeds

A high-reliability pharmacy management software streamlining inventory control, billing, and prescription tracking.

01. Overview & Description

My first major software project designed to digitize local medical store billing workflows with zero training requirement.

02. System Architecture Diagram

Python Modular GUI -> SQLite ACID Engine -> PDF Report Generator

Interactive System Flow Diagram

Click any node below to inspect its operational role in the pipeline.

● Live Animated Flow
1React18 DashboardFrontend Client2FastAPIEngineREST & SSE Middl3Authentication/ RLSSecurity Policy4PostgreSQL/ SQLitePersistence Laye5LocalOllama LLMQuantized Infere6StreamedResponseUI Rendering Out
Selected Node: React 18 Dashboard(Frontend Client)

Handles user prompt input, interval charts, SSE streaming data rendering, and dark-theme state management.

03. Database Schema & API Specifications

Database Schema Design

SQLite relational tables: medicines (id, name, batch_no, expiry_date, stock_qty), sales, sale_items.

API Endpoints
  • processInvoice(items)
  • updateStock(medicineId, qty)
  • generateMonthlyReport()

04. Codebase Folder Structure

rymeds/
├── src/
│   ├── controllers/InventoryController.py
│   ├── views/BillingWindow.py
│   └── database/schema.sql
└── rymeds.py

05. Visual Evidence & Artifacts

Counter Billing Interfacecode

$ rymeds --status active

[OK] System pipeline initialized

Fast item barcode scan & instant receipt generation

06. Engineering Challenges

Calculating accurate expiry warnings while keeping billing speed fast during high customer traffic.

07. Key Lessons Learned

Software utility is measured by how effectively it solves immediate daily operations for non-technical users.

Technologies Used

PythonSQLiteDesktop UIDatabaseSoftware Engineering