Database Options

SQL (e.g. PostgreSQL)

• Pros
  • Relational data modelling
  • Better for complex data structures
  • More mature
  • Better support
• Cons
  • More expensive (always-on server)
  • Vertical scaling

NoSQL (e.g. Mongo, Firestore)

• Pros
  • Cheaper (pay-as-you-use)
  • Horizontal scaling
• Cons
  • Data duplication (messy)
  • No strict schema (messy)
  • Poorer documentation