NoSQL database with range queries?

You may want to check out MongoDB It's popular 1 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 1 See: MongoDB : Production Deployments.

You may want to check out MongoDB. It's popular1, 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 1 See: MongoDB : Production Deployments.

– Hubert Kario Oct 9 '10 at 16:03 @Hubert: It's a trade off. You may want to check out this SO question: Is there any NoSQL that is ACID compliant?. MongoDB still remains one of the NoSQL solutions that suppost many features from SQL databases.

– Daniel Vassallo Oct 9 '10 at 16:36 @Hubert: You might also be interested in this: mongodb. Org/display/DOCS/Durability+and+Repair and this: blog.mongodb.Org/post/381927266/what-about-durability – Daniel Vassallo Oct 9 '10 at 16:38 I know, that's the problem with noSQL databases, I just want to know which part of ACID it drops to achieve the performance, this way I could write an application around to mitigate this problem. If I cared about 100% ACIDity I wouldn't be looking at NoSQL solutions but went straight to PostgreSQL :) – Hubert Kario Oct 9 '10 at 17:12 Looks like it's exactly what I need, many thanks!

– Hubert Kario Oct 9 '107 at 8:44.

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).

Then it won't be good for my needs, two reasons: using a "greater than" score is only part of the query (possibly also other non-equal like) and second: I do need queries like that to be very fast – Hubert Kario Oct 13 '10 at 22:39 This feature is planned for the next release: code.google. Com/p/orient/issues/detail? Id=64.

How much records are we talking about? Millions or billions? – Lvca Oct 15 '10 at 22:55 millions, but I plan on running it on VPS, so I need all the performance I can get :) – Hubert Kario Oct 16 '10 at 16:22.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.