Search by multiple keys in CouchDB

While developing a simple Twitter clone on V8CGi + CouchDB stack, we faced an interesting problem.
We have a CouchDB database with users and messages. Each user has many followers and he'd like to see messages from all these
followers. So we need to query tweets database for all documents that have author belonging to the list.
In SQL it's something as simple as:

SELECT * FROM tweets WHERE author IN ("szymon", "wiktor", "marek") SORT BY timestamp;

In CouchDB it turned out to be an open issue https://issues.apache.org/jira/browse/COUCHDB-523

As far as I remember we ended up with running two separate queries. I'd be happy to hear how others solved this!

Comments

  1. CheesoJune 28, 2012 at 11:43 AM

    I don't think the couchdb issue you flagged is the same as what you described.

    This issue https://issues.apache.org/jira/browse/COUCHDB-523 relates to multiple independent ranges. What you're looking for is to select all items with a given key equal to one or more values. The former is a generalization of the latter, but they are not the same. In fact the simpler case is documented to be supported in Couchdb, using the keys query param, in which you specify an array. http://wiki.apache.org/couchdb/HTTP_view_API?action=show&redirect=HttpViewApi#Querying_Options

    ReplyDelete

Post a Comment

Popular posts from this blog

Drawing in Graphiti

Image
It seems Eclipse Graphiti is really popular lately. Germany is using it to build cars, Engineers in India are getting to speed with it as well. Finally I made a try as well and fell in love with the simple APIs and helpful docs. The only thing that struck me is that most diagram editors out there are used mostly to draw just boxes and connections between them. Is that really all you can do!?!?? Ok so you here's what I did, a simple drawing tool in Graphiti: Click below to see it in action! And Fork it on Github Youtube video:
Read more

Trouble signing Apps for OSX Mountain Lion

Image
If you're building desktop Apps for OSX, chances are you'll need or you're already working on getting them signed with Apple's certificate. Otherwise your users might see this, starting with Mountain Lion: I just signing few apps and scored new items in my erroropedia: Error 1: "Error signing data" $ productsign --sign 'Developer ID Application: YourCompany' from.pkg to.pkg productsign: signing product with identity "Developer ID Application: YourCompany" from keychain /Users/user/Library/Keychains/login.keychain Error signing data. productsign: error: Failed to sign the product. Reason: keychain is locked for access from SSH. Try security unlock-keychain -p You might also need to enable access to certificate private key for all applications: Error 2: "MyApp.app: object file format unrecognized, invalid, or unsuitable" One solution that worked for me: export CODESIGN_ALLOCATE="/Applications/Xcode.app/Cont
Read more

Spikes in RabbitMQ + NodeJS latency test

Image
Measuring things is a fun way to confront assumptions we put everywhere. In software development products tend to be based on tens of assumptions, such as that network will be fast enough, REST or database transaction time short enough, success rate for external API calls within reasonable range. Knowing the limits of those assumptions is always worth at least one beer. The other day I was looking how long it takes my message queue, RabbitMQ, to pass messages from producer to consumer. RabbitMQ has loads of options: queues, topics, durability, acknowledgements, clustering to name a few. It's not obvious how those different options affect latency.  I wrote two little NodeJS processes - producer and consumer, based on samples from RabbitMQ tutorial, to measure how long it takes a message to fly from one process to the other. Those processes would just run many times with various configs to produce data - big latency table. Unfortunately, the very basic scenario turned out to be a
Read more