Move the entire platform from MongoDB to Postgres.
This should be a non-user facing change and the API contract should not change at all.
Implementation
Use drizzle as an orm and repository pattern to centralize all the DB related functionality.
Local testing
Use Postgres docker container
Migration
Write a migration script too for moving all records from MongoDB to Postgres
Move the entire platform from MongoDB to Postgres.
This should be a non-user facing change and the API contract should not change at all.
Implementation
Use drizzle as an orm and repository pattern to centralize all the DB related functionality.
Local testing
Use Postgres docker container
Migration
Write a migration script too for moving all records from MongoDB to Postgres