20 Apr 2022
→ What type of data are you analyzing?
- Fits nicely into rows and columns → SQL
- Needs flexibility → NoSQL
→ How much data will you be working with?
- A lot of data → NoSQL
- Not a lot of data → SQL
→ Intensive read/write operations? → SQL
→ What kind of resources do you have for setup and maintenance?
- Small engineering team → SQL
- SQL databases take less time to manage
- A lot of developers already know how to work with SQL databases
- Big engineering team → will handle NoSQL better
- NoSQL requires more programming because it needs to deal with non standard data structures
- Team might have to learn other programming languages
→ Do you need real-time data? → SQL