There are three common ways to store data
- Files
- Optimized for storing large items
- SQL
- THE STANDARD
- Easy things are easy
- Optimized for storing and searching many many items
- Powerful search
- ACID properties
- Can easily impose business rules at a single point
- Requires structured data
- noSQL
- So many to chose from
- Optimized for storing and searching many many items
- Maybe powerful search
- Maybe probably not the ACID properties
- Maybe but probably not able impose business rules at a single point
- Does not requires or enforce structured data
- Often faster than SQL