In one of youtubes videos about scalling web sites I found the statement that, however, in term of scallability, noSql is easier and more flexible, though it is better to use SQL for data important enough to not want them be lost (not necessarly secure). Why is so? What mechanism make SQL safer in such term? I'm very VERY beginner with databases so easy answers will be appreciated.
closed as too broad by gnat, Dan Pichelman, TZHX, Robert Harvey♦, Robbie Dee Jul 20 '16 at 15:37
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
I guess what your sources are refering to is ACID compliance. There are lots of SQL databases which provide ACID. Most NoSQL databases, however, do not provide this for the sake of better scalability. Here is an article on Quora which might give you an explanation.
For both categories of databases, however, if one wants data not to get lost, regular backups are important, and that has nothing to do with "SQL" or "NoSql".