Bruh.uno is a live project that was meant to store large URLs with queries in a database and provide a redirect, in effect making a URL shortening service.
The Problem was most URL Shorteners, such as bit.ly, tinyurl.com, and so forth, would display the content behind the redirected URL. That is not very effective when specific individuals are wanting to prank their friends and their chat application sends a preview of the YouTube video they secretly sent.
Discord Miner (MineKingdom) was a large Discord bot that allowed users all over the world to send messages and play the popular game Minecraft in a text form. It was an idle game that allowed users to mine, sell resources, create gear, fight other players and mobs, and gain wealth. The ultimate goal for the game was to be the richest user.
Many problems arose during the lifetime of this project. With a total user base of over 3.1 million registered players, it was immensely difficult to maintain the speed and integrity of the database. Originally, this chatbot stored data in RAM and hard SQLite database files. After being live for a few weeks, responses from the database were extremely long. A script was then created to move all of the data to MySQL but that was also difficult given the limited system resources and the slow database. After six months, the MySQL database was overwhelmed with over 1,000 requests every 10 seconds. A script was then created to migrate about 1+ million user accounts over to PostgreSQL which resolved the major concerns.
Many skills were gained or sharpened during my time developing this chatbot. Websites were created that communicated with APIs seperate from the chat bot to retrieve player data from the database. These websites also were used to eventually control individual settings for users and groups (called servers in Discord) and for payment processing (using the PayPal API.)