Discord AdBot

SUMMER 2021

AdBot is an advertising bot on Discord that allows companies to promote their products/services to guilds our bot reside in. With a team of 7, we worked on and off for about a year, but had to end the project due to Discord's user policies.

Back-End

We first created our API using a Python Flask server, but we later switched to a Golang server in our second iteration for better performance.

  • Wrote endpoints following REST Principles
  • Used a lot of SQL commands for communication with database

Database

One of my roles was to be in charge of the remote database.

  • Hosted PostgreSQL database on AWS's RDS
  • Contributed in design of database (tables, types of info to keep track data types)
  • Set up different tables and foreign key relations between tables
  • Wrote SQL functions for calculating the average velocity of discord messages that told us the optimal time to send ads

Front-End

This was my main team for the duration of the project, as I had the most experience in React and CSS styling. We ended up only completing the homepage before we decided to discontinue.

  • Worked with NextJS / React to create home page
  • Created reusable components for repetitive structures
  • Standardized responsive design using defined CSS-variables and media tags for resizing for different screen sizes

Screenshots

Home page of AdBot website Home page of AdBot website Home page of AdBot website