Sololearn: Learn to Code
New course! Every coder should learn Generative AI!
Try a free lesson
+ 5
Both are good for different applications. SQL compliant solutions are well organized, array or matrix-like, which provides data conformity and integrity. It gets pretty heavy though, even for relatively sparse datasets, as tables are always "column-wide" for all rows, whether a particular cell contains data or not. NoSQL solutions are more flexible, as they work on a different logic. Each entry may contain different type of data, of different length, size or format. Memory-wise, it grows only to the size of its data. A mechanism inside it keeps control of data integrity.
21st Jul 2017, 9:22 PM
Kuba Siekierzyński
Kuba Siekierzyński - avatar