Migrate Database from MongoDB to PostgreSQL

[ratnesh-maurya]

Description:

We need to migrate our current database from MongoDB (NoSQL) to PostgreSQL (Relational Database). This transition is crucial for enhancing data consistency, supporting complex queries, and improving scalability in relational contexts. The migration process should ensure data integrity, and smooth application functionality post-migration.

Key Objectives:

Data Mapping: Analyze the current MongoDB schema and map it to appropriate PostgreSQL tables. This includes designing a normalized schema, handling nested structures, and considering the best relational database practices.

Application Updates: Update the application codebase to interact with PostgreSQL instead of MongoDB. This includes rewriting database queries, updating models, and ensuring compatibility with PostgreSQL’s SQL dialect.

Requirements:

PostgreSQL expertise.

• Knowledge of both NoSQL and relational databases.
• Familiarity with migration tools and best practices.

Acceptance Criteria:

• [ ] All data successfully migrated to PostgreSQL.
• [ ] Application performs as expected with PostgreSQL.

Priority: Low

[mienpham04]

Hey, I am interested in this issue. Can you assign that to me and I will work on it?

[ratnesh-maurya]

Sure , go ahead