Grocery Management CLI
Python CLI with MySQL Database Integration
Manual Ledgers & Gaps
Local merchants suffer from product counting errors, manual ledger bookkeeping mistakes, and stock discrepancies. There was a direct need for an offline-first inventory management ledger that securely links item categories with sales bills.
Product Tracking & MySQL
Constructed relational database models with foreign-key relationships representing Products, Transactions, Employees, and stock counts. Engineered constraints to block duplicate entry logs.
Billing & stock management
Coded standard Python connectors managing high-frequency transactions. Developed inventory trackers, billing aggregations, customer purchase logs, and invoice text generators.
MySQL Schemas & Connection
Technical Challenges
Guaranteeing safe data transactions and configuring thread-safe MySQL connections over standard local sockets.
Key Take-aways
Gained structural understanding of primary keys, database normalizations, SQL query speed, and data integrity practices.
Educational Website Design
Educational Platform UX Case Study
Ahmed Bhawrasa
"Focused on building modern, user-first digital experiences."