what database should i choose? ^1

focus on the specific requirements of their system, specifically three key factors:

  • Data Model: Determine if your data involves complex relationships or just simple lookups.
  • Consistency: Decide whether you need strong consistency or if eventual consistency is acceptable.
  • Query Pattern: Consider whether your queries involve complex joins, range queries, or analytics.

references

  1. SQL vs NoSQL is the WRONG Question (System Design Tips)