Evan Chime

Some Of Me Projects


ebookstore | September 2024

Python, SQL, Git, GitHub

A program that can be used by a bookstore clerk to manage the bookstore's inventory. The clerk is able to add new books to the database, update book information, delete books from the database and search the database to find a specific book.

Some of the challenges overcame include getting the title and author fields of the database table to do unicode caseless comparisons, making the id field of the database table sequential, implementing the book search feature and getting accurately the pre-defined records from the file external source


Inventory Python Project | August 2024

Python, Git, GitHub

A python project for managing inventory. It allows store staff members to keep track of shoes, their quantities, and other relevant information. Some of the features include adding new shoes to the inventory, updating quantity of shoes, viewing all shoes in the inventory, determining the product with the lowest quantity and restocking, searching products by code, calculating total value of each shoe and showing shoes on sale.

Some of the challenges overcome were getting the shoes data from the external source and converting the data into a shoe object accurately. Also ensuring consistency when reading from and writing to the external source, the shoe data


Task Manager | July 2024

Python, Git, GitHub

A program for a small business to help it manage tasks assigned to each member of the team. Some of the features include registering users, adding tasks, viewing all tasks, viewing a specific user's task, displaying statistics and generating reports

Some of the challenges overcame was how to ensure the date entered by the user was valid and getting the data from the external source accurately


WhatsApp AI Chatbot (Node.js version) | February 2024

Node.js, Express.js, WhatsApp Business Platform API, Heroku, OpenAI's Assistant API, Redis, Git, GitHub

An AI Chatbot written in Node.js. The user sends a message from their WhatsApp app. The WhatsApp Platform receives and forwards the message to a webhook. The webhook calls a web app, running in Heroku, passing along the user message. The web app calls OpenAI's Assistants API with the user message. The Assistant's API returns the answer. The web app sends the answer and user phone number to the WhatsApp Platform. The WhatsApp platform sends the answer back to the user's WhatsApp app

The major achievement and challenge that was overcame was getting the chatbot to remember previous conversations and not allowing the chatbot and its conversations to live forever