How to Choose the Right Database for Your Project: A Guide Between SQL and NoSQL
summary
Guides how to choose between SQL and NoSQL databases by comparing relational SQL with four NoSQL categories—document, key-value, columnar, and graph—highlighting their pros, cons, and ideal use cases. Presents concrete examples and real-world scenario analyses to show how to match a project’s specific requirements (performance, scalability, maintainability, development time) to the right database type.
AI-written summary · about
chapters (16)
- 0:00Introduction
- 2:55CAP theorem and database types
- 5:02SQL versus NoSQL differences
- 7:31Music F case study
- 9:59Redis for session handling
- 14:56Lyrics search SQL vs Elastic
- 17:49Inverted indexes in NoSQL
- 18:54Graph databases
- 20:19Key takeaways
- 22:28Q&A part 1
- 24:35SQL future
- 27:05JSONB and document stores
- 29:54Hybrid database approach
- 30:56Tips for junior devs
- 32:19Cost mitigation in projects
- 34:02Q&A part 2
related talks
45mSay YES! to NoSQL: A Guide on When to Ditch Relational Databases
45mSay YES! to NoSQL: A Guide on When to Ditch Relational Databases
42mSay YES! to NoSQL: A Guide on When to Ditch Relational Databases
01h 00mFrom Relational Databases to NoSQL
45mDemystifying NoSQL: The SQL developer's guide
19mRelational or Non-Relational? Choosing the Best Database for the Task
01h 01mNoSQL: An Analysis
01h 20mProblems with Relational Databases in 2020