Migrate from Mongoose to Postgres

[MridulDhiman]

Problem Statement

You have to migrate from mongodb database which is currently using mongoose ODM to postgres database using prisma or drizzle as an ORM abstraction layer.

Technical Details

1. Add abstraction methods so that data layer is separate from business layer and presentation layer.
2. Normalize the schema design by making separate tables for each embedded documents, and references to be converted to foreign keys, focusing on the transactional workloads. If we still require some flexible schema and nested structure, just add that column of jsonb type
3. Use Drizzle as an ORM as they are edge compatible.
4. Use Turso or Neon for your postgres server or setup one locally via docker.