search

tattle-made / Uli

Software and Resources for Mitigating Online Gender Based Violence in India
https://uli.tattle.co.in
GNU General Public License v3.0
40 stars 30 forks source link

MySQL to Postgres Migration #613

Open dennyabrain opened 1 month ago

dennyabrain commented 1 month ago

Because of the following reasons we want to migrate from MySQL to Postgres :

  1. Postgres being more modern and versatile tool
  2. Rest of our tech stack at Tattle has moved to Postgres
  3. Our current MySQL instance on AWS has reached end of service period

In scope for this task it to evaluate

  1. If there are standard tools that we can use to migrate existing mysql database to postgres
  2. any issues with the current database schema that prevents this migration
  3. a working script or command to demonstrate successful schema and data migration from MySQL to Postgres locally
eternaltyro commented 2 days ago

@maanasb01 re: #619 can you also parameterize the DB name to be picked up from envvar? Like process.env.DB_NAME,

aatmanvaidya commented 2 days ago

hi @eternaltyro - have made that small change here - https://github.com/tattle-made/Uli/pull/620, hope that is what you were referring too

eternaltyro commented 2 days ago

@aatmanvaidya yes, that's what I wanted, thanks.