Comnts for post MongoDB and Redis: a different interpretation of what's wrong with Relational DBs

Comments for post MongoDB and Redis: a different interpretation of what's wrong with Relational DBs

jimmybot writes: Wow you are fast. Thanks. I think you are right that SQL can be unpredictable, though *if* there was some kind of index on value functionality, it could be implemented in a way with predictable performance. At any rate, Redis looks to be shaping up very interestingly. Props on a great project.

antirez writes: @jimmybot: ah ok, got it, indeed it is true. In Redis you have to build all your "views" by hand. But this also means you don't have surprises. Most SQL troubles come from the fact you ask queries that are processed inside a black box. With Redis you have to handle more carefully your model, but you end up with something really predictable.

jimmybot writes: Well, I mean you can just store the value as a key and the key as a value, but I think it's one more thing to think about and possibly get wrong.

antirez writes: @jimmybot: search Redis "Sorted Sets". It's our Index.

jimmybot writes: My understanding of redis is that there is no built-in easy index for <i>values</i>. No index means slow queries/searches. I think that is a very big difference as well, though not something that can't be changed.

Leandro writes: So much misunderstanding... first, ðe problems you aßume are not problems of relational databases, but of SQL implementations; second, many of ðem would probably be solved by relational implementations such as Alphora Dataphor. Þird, ðese problems aren t to be solved by object orientation, which has even worse problems ðan even SQL. One must understand whatever one wants to criticise.

dm writes: exactly - what we need is the right tool for a particular job. Sometimes that is RDBMS. But doesn't have to be for 100% of problems. We don't use one programming language for everything.

Brian Ketelsen writes: Well thought out discourse on relational and non-relational data stores, it's pleasant to see such a post free of the typical "Mine is better than yours" ego that is so rampant in the technical community today.

home