TrashTruck — Waste Management System
This project is purposed at tackling the pressing issue of waste management especially in Uganda by providing a digital solution that waste management companies can adopt to connect to their clients in an efficient and eco-friendly way.
This project was thought and built by a team of three as shown below:
Peter Lubega and Andrew Ssentongo (Back-end Developer), and Rino Kitimbo who worked as the front-end Developer.
We are looking forward to deploying and doing final tests by the end of June 2024.
This system/project is meant for all people around Kampala suburbs finding it difficult and unsure on when their trash is to be picked, uncertain about how much to pay. This is the solution.
Our focus was mainly on digitalizing the entire trash collection process from requests, and payments up to the trash collection bit.
In our architecture, for the Frontend we chose to use HTML5, CSS3 and JavaScript without any additional frameworks. We opted not to use other frameworks because we wanted to dedicate our time to solidifying our understanding of flask. Notably we also used postgress for data base.
Under the features, we designed databases using Postgres. The system is web accessible as well.
Major challenges that we faced in this project were optimizing database performance, handling concurrent requests, and ensuring robust error handling when logging in.
We have optimized the database schema to support efficient querying and data retrieval. This involved carefully designing the structure of the database tables, choosing appropriate data types, and establishing relationships between different entities. We ensured that indexes are properly defined on columns frequently used in queries can significantly improve query performance.
- We noticed that tables that are not indexed were slow and this only changed when we optimized the DBs and this is a key take away.
- We have learnt how great flask can work and run in building a system.
- The need to master at least a few languages for both backend and frontend in order to understand the project worked on.
This project informed our procedure on how Project status is tracked ie via Trello, how to present and so forth.
Before we had dived into this project, we thought it was impossible to do an MVP in such a very small time but this has been possible.
Index I:
Links:
https://www.linkedin.com/in/rino-kitimbo-881090116/
- GitHub link for the project
- Landing Page Link
Originally published on Medium
