search

Madison-Esports-Club / UWVerifierBot

A bot to verify wisc.edu emails on the UW Madison Esports Discord Server
4 stars 0 forks source link

Swap backing database to MySql #37

Open DMLooter opened 1 year ago

DMLooter commented 1 year ago

Now that the bot is no longer on heroku we gain no significant advantage from using postgresql as our storage medium. Thus I'm proposing that we switch from postgres to the same mysql instance that is hosting the website DB. This would mean less CPU/memory overhead for the server and make manual maintenance of the server significantly simpler (postgres login is stupidly difficult to do securely. Like it takes several minutes to log in If you can type out the password right on the first try)

DMLooter commented 1 year ago

I'm open to arguments for keeping postgres over mysql (and we could potentially swap the website to postgres as well). But I'm more familiar with mysql so that is what I propose we keep.

antgurevich commented 1 year ago

I have no experience with mysql but i'm open to figuring out which one will be more beneficial and whether its worth the effort to migrate everything between databases.