NoSQL database with range queries

Question

I'm looking for a NoSQL database that allows queries that return records that fall in the specified range.

I'm not very good with the NoSQL nomenclature (as I'm still only researching whatever they will be viable) so I'll explain it how I would do it in SQL.

What I'll need to do, is search for records (let's say forum posts), that are above a specific score. More or less something like this: SELECT * FROM posts WHERE score > 2.

The question being, when I'm using PHP, is it possible to do with any NoSQL database (key-value or wide column ones)? If it's impossible with any, which NoSQL databases support such queries?

Answer 1

You may want to check out MongoDB. It's popular¹, and supports range queries:

Unlike many other non-relational database solutions, any field can be queried at any time. MongoDB supports range queries, regular expression searches, and other special types of queries in addition to exactly matching fields. Queries can also include user-defined JavaScript functions (if the function returns true, the document matches).

From: Wikipedia - MongoDB Features

Here's how your SELECT * FROM posts WHERE score > 2 query would look like in Mongo:

db.posts.find( { score : {$gt: 2} } );

Further reading:

• MongoDB Manual : Advanced Queries

---

¹ See: MongoDB : Production Deployments

Answer 2

OrientDB supports SQL with extensions for the schema-less paradigm.

You can execute this query:

SELECT * FROM posts WHERE score > 2

But the underlying index is not used with operators different by = (equals). So it could be not so fast with millions of records because it need to scan the entire cluster to satisfy the condition (something similar to a table in relational world).