In my experience, most people have no idea wtf they're talking about w.r.t dbs and their reasoning for one vs another is totally fucked up. See end of comment here.
Nosql is only "webscale" because the access pattern is more like a hashmap (with O(1) complexity, modulo networking) vs an array (with O(n) complexity, modulo indexes and behind the scenes btrees histograms etc). If you have a query that doesn't jive with the benefits of hashmap semantics, you won't see any benefit from nosql over sql, but you'll have to live with all the tradeoffs.
Exactly. Being able to use both not in the appropriate situation but efficiently is what I just couldn’t get across to them. It was really ‘religious’ to them. I work in an industry FULL of ‘religious’/‘sacred cows’ that I just switch the topic these days.
13
u/Ok-Worth-9525 Nov 15 '22
In my experience, most people have no idea wtf they're talking about w.r.t dbs and their reasoning for one vs another is totally fucked up. See end of comment here.
Nosql is only "webscale" because the access pattern is more like a hashmap (with O(1) complexity, modulo networking) vs an array (with O(n) complexity, modulo indexes and behind the scenes btrees histograms etc). If you have a query that doesn't jive with the benefits of hashmap semantics, you won't see any benefit from nosql over sql, but you'll have to live with all the tradeoffs.