An old video but still relevant

Key Take aways

• Complex SQL queries- Joins : SQL
• Transaction management / ACID Properties: SQL (commit and rollback are by default whereas you need to tackle them in NSQL)
• Huge quantity of data/ fast scalability – NOSQL
• Write Heavy – Logging system – NoSQL
• Read Heavy- Queries/ indexes – SQL
• Fixed Schema- SQL, Flexible schema-NOSQL (Alter table statements are costly and have restrictions)
• JPA/ hibernate/ django- by default support SQL
• Archiving and managing huge data- NoSQL