Databases
StackOverflow2013
Postsdbo
POSimplest distributed persistent key/value store that supports primary key range queries
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSimplest distributed persistent key/value store that supports primary key range queries
    text
    copied!<p>I am looking for a properly distributed (i.e. not just sharded) and persisted (not bounded by available memory on single node, or cluster of nodes) key/value ("nosql") store that does support range queries by primary key.</p> <p>So far closest such system is Cassandra, which does above. However, it adds support for other features that are not essential for me. So while I like it (and will consider using it of course), I am trying to figure out if there might be other mature projects that implement what I need. Specifically, for me the only aspect of value I need is to access it as a blob. For key, however, I need range queries (as in, access values ordered, limited by start and/or end values). While values can have structures, there is no need to use that structure for anything on server side (can do client-side data binding, flexible value/content types etc). For added bonus, Cassandra style storage (journaled, all sequential writes) seems quite optimal for my use case.</p> <p>To help filter out answers, I have investigated some alternatives within general domain like: Voldemort (key/value, but no ordering) and CouchDB (just sharded, more batch-oriented); and am aware of systems that are not quite distributed while otherwise qualifying (bdb variants, tokyo cabinet itself (not sure if Tyrant might qualify), redis (in-memory store only)).</p> <p>EDIT: Looks like hBase supports primary key range queries, and its data is distributed due to underlying hdfs. However I don't think it is fully distributed from system perspective, since region servers are just sharding key space but there is no redundancy (assuming I did not misread documentation).</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload