The project my group is working on is PetPals, a dating app for animal adoption. It aims to pair up potential adopters with animals at shelters. Both adopters and shelters will be able to create accounts with either public or administrative privileges, respectively. Adopters (users) will be able to browse available animals based on their species, breed, and/or dispositions, as well as read daily news blurbs from the shelter. Shelters (admins) will be able to create, modify, and delete animal profiles and news items.
We decided to distribute work for this app by splitting up into 2 pairs, one for the user-side and one for the admin-side. Within these pairs, one person works on the frontend while the other works on the backend. I’m assigned to work on the backend for the user-side which is great because, ever since taking CS 340, I’ve been a big fan of working with the backend.
My favorite tool that I’ve been using is phpMyAdmin which provides a GUI for interacting with the SQL database. I keep it running on a tab when testing out backend functionality to quickly verify that my CRUD operations are working properly. I also use it to easily import DDL for table creation and sample data whenever the database needs to be refreshed. My only complaint is that I wish I could mass delete all of the tables for the purposes of resetting the database instead of dropping each one individually.
Leave a Reply