[RFC] migrate to DynamoDB

Objectives

• From a scalability perspective it much more scaleable
• Has inbuilt cache support (something with Redis | ElastiCache)
• Aggregation query is much better
• Indexing
• Right now Client side is deriving our database model
• Database modeling is loosely packed
• Limited Read/Write (Free Tier is much more benefiting)

Procedure

• Creating Schema for the database
• AWS migration tools (explore)
• Middleware to write on both databases (zapier some ### tool)
• Will use complete Typescript

V1 goals

• API with higher traffic will be migrated first then otherwise i.e ()
• Firestore and DynamoDB will co-exist
• Schema Enforcing
• Creating typescript objects according to the schema to share with frontend development
• Documentation for migration and guidelines

End Goal

• Completely build up DynamoDB and then slowly remove firestore
• Database tightly packed with proper schema
• A npm @types package for the database models (will be used on the frontend)
• Fully migrated to typescript.
• Database modeling will have a single source of truth

Supporting Docs

• Zapier Tool
• AWS migration example

The issue names no files, tests, or entry points; begin with its Objectives, Procedure, and V1 goals, then review the linked AWS migration example. Done would require an agreed migration scope covering coexistence, schema enforcement, TypeScript models, migration documentation, and the eventual Firestore removal path.