Querying with Redis?

Question

I've been learning Node.js so I decided to make a simple ad network, but I can't seem to decide on a database to use. I've been messing around with Redis but I can't seem to find a way to query the database by specific criteria, instead I can only get the value of a key or a list or set inside a key.

Am I missing something, or should I be using a more robust database like MongoDB?

Just because mongodb supports advanced querying, it doesn't mean it's more robust. — Joshua Partogi, Mar 22 '11 at 06:54
No way for advanced querying in Redis. This tool is simply designed for different task — Dan, Mar 07 '12 at 07:46

score 20 · Accepted Answer · edited Sep 19 '13 at 05:43

20

I would recommend to read this tutorial about Redis in order to understand its concepts and data types. I also had problems to understand why there is no querying support similar to other (no) SQL databases until I read few articles and try to test and compare Redis with other solutions. Maybe it isn't the right database for your use case, although it is very fast and supports advanced data structures, but lacks querying which is crucial for you. If you are looking for a database which allows you to query your data then you should try mongodb or maybe riak.

edited Sep 19 '13 at 05:43

Deep Sharma

3,374
3
29
49

answered Mar 22 '11 at 10:39

yojimbo87

65,684
25
123
131

1

Thanks for the info. So basically I have to build my own indexes if I want to do any sort of querying? – Kevin McTigue Mar 23 '11 at 18:36
Something like that, but you will still lack some kind of query language. – yojimbo87 Mar 23 '11 at 19:13

Alfred · Answer 2 · 2011-03-22T06:45:49.340

7

Redis is often referred to as a data structure server since keys can contain strings, hashes, lists, sets and sorted sets.

If able(easy to implement) you should use these primitives(strings,hashes,lists,set and sorted sets). The main advantage of Redis is that is lightning fast, but that it is rather primitive key-value store(redis is a little bit more advanced). This also means that it can not be queried like for example SQL.

It would probably be easier to use a more advanced store, like for example Mongodb, which is a document-oriented database. The trade-off you make in this case is PERFORMANCE, but I believe you should only tackle that if that is becoming a problem, which it probably will not be because Mongodb is also pretty fast and has the advantage that it can be queried. I think it would be advisable to have proper indexes for your queries(read>write) to make it fast.

edited Mar 22 '11 at 06:45

answered Mar 22 '11 at 06:23

Alfred

60,935
33
147
186

Alright, so I noticed that Riak has querying but it's a key-value store instead of a document-oriented database like Mongo. Would one be better suited for the job over the other? – Kevin McTigue Mar 23 '11 at 18:39
2

From Riak:"Riak relies on MapReduce to perform queries that exceed the limitations that come with the basic key/value storage model.". Redis does not have MapReduce to do this. To be honest I do not have any experience with Riak, but traditional Key-value stores can not query the database... – Alfred Mar 23 '11 at 23:31

MyOwnWay · Answer 3 · 2013-12-23T01:39:52.677

3

I think that the main answer comes from the data structure. Check this article about NoSQL Data Modelling, for me it was very helpful: NoSql Data Modelling.

A second good article ever about Data Modeling, and making a comparison between SQL and NoSQL is the following: The Relational model anti pattern.

edited Dec 23 '13 at 01:39

answered Dec 23 '13 at 00:49

MyOwnWay

741
6
9

Querying with Redis?

3 Answers3

Linked

Related