In-reply-to » @prologic not me mate, I asked as I was genuinely curious and as someone who only really knows SQL as far as databases go, I keep wondering what life is like on the NoSQL side of the fence 😅

@prologic@twtxt.net you’re just reinventing relational databases with a lot of that stuff though. Row stores are pretty bad but column stores have a huge number of advantages and are superior to keys value stores in certain cases, like when you do have a fairly strictly tabular dataset with multiple distinct concepts and want to flexibly query it without the rigmarole of reindexing every possible combination of fields you may want to query like you’d do in a key value store. Choose the right tool for the job etc.

⤋ Read More