michac789 / ntusu-index-swapper-be

0 stars 0 forks source link

[Optional] Dockerize Application, Setup MySQL #9

Open michac789 opened 1 year ago

michac789 commented 1 year ago

Setup Docker container:

These container will ensure a more similar environment and predictable results on different places.

michac789 commented 1 year ago

edit: change to mysql instead, to keep consistent with current ntusu db

michac789 commented 1 year ago

Based on research, PostgreSQL actually win against MySQL for almost all functionality... so can reconsider by how large of a margin it is

MySQL: make the setup same with ntusu db (not much work), but a bit less optimal PostgreSQL: can be potentially faster (and from django docs there're some features that are available on postgres but not on MySQL), but need to create the db instance first in aws, and need to migrate existing data, and need to update main su repo db to this