We've had great success with using ElasticSearch to index our couch db databases in near realtime into it's lucene indexes, and then querying those.

It allows each tool to focus on what it does well.