Software Engineer
CurrentGather Peace - a Social Media site with data hosted on SupaBase (Postgres DBaaS)-Leveraged ‘explain analyze’ and pgMustard to optimize SQL query to prioritize filtering data to relevant rows prior to joining other tables, reducing query load time from 645ms to 128ms. -Refactored React components to use context instead of state to store a user’s liked posts, preventing repetitive queries to the database when navigating to different pages. -Refactored additional React components to reflect updated state without redundantly querying the database after writing. -Designed a social media newsfeed using a polymorphic SQL table, allowing multiple data types to be fetched and rendered with a single query.