Faculty Sponsor

Nick Rosasco


Arts and Sciences


Computer Science

ORCID Identifier(s)

https://orcid.org/0000-0001-8998-906X , https://orchid.org/0000-0002-7887-8265 , https://orcid.org/0000-0001-6635-0220 , https://orcid.org/0000-0002-4150-0023 , https://orcid.org/0000-0002-4237-2625

Presentation Type

Poster Presentation

Symposium Date

Spring 5-14-2020


This project is implementing and deploying a functional patient database with customizable treatment plans and progress notes for Choices!, a counseling service center. To build this application and support the various requirements, several frameworks were considered for this project including Django, Flask, and Ruby on Rails. The Ruby on Rails suite was selected for reasons of existing familiarity for the team. Existing libraries within Rails allow for a choice of several database engines; MySQL, Postgresql, MongoDB, and NoSQL were considered. MySQL was adopted as a result of the extensive documentation and for continuity with the previous solution. Front-end requirements were met with a combination of HTML and Javascript, linked to a Bootstrap 5 framework in order to streamline user accessibility. A key quality desired by the customer was ease-of-use, to encourage higher efficiency and easy adoption by the stakeholders. In the process of development, secure data handling also emerged as a further and highly-desired attribute.