22. When would you choose SQL vs NoSQL?
MediumDatabases
Technical
Show model answer
Relational databases give a fixed schema, joins, and ACID transactions; they fit data with clear relationships and strong integrity needs, such as orders and payments.
NoSQL stores (document, key-value, wide-column, graph) trade some of that for flexible schemas, simple horizontal scaling or specific access patterns. Choose from the access patterns and consistency needs, not hype; many systems use both.