Database

Types of database

  • Relational
    • Tables have a common key per row
    • Use joins to get the complete data
  • Non-Relational
    • Document Structure ~ Think you’re saving the whole json ~

TIP

  • Use PostgreSQL or MySQL if you’re building a system with clear business rules and many data relationships (like a SaaS, billing system, marketplace).

  • Use MongoDB or Firebase if your app needs flexibility, real-time updates, or stores user-defined schemas (like a chat app, social feed, or CMS).

    Types of database

  • Relational

    • Tables have a common key per row
    • Use joins to get the complete data
  • Non-Relational

    • Document Structure ~ Think you’re saving the whole json ~

TIP

  • Use PostgreSQL or MySQL if you’re building a system with clear business rules and many data relationships (like a SaaS, billing system, marketplace).

  • Use MongoDB or Firebase if your app needs flexibility, real-time updates, or stores user-defined schemas (like a chat app, social feed, or CMS).