Re:MongoDB, Better
by AdrianRossouw on Sunday March 30, 2014 @08:26PM
(#7498685)
I use elasticsearch to index my couch database and query it using the rest based json query language.
i find it helps being able to scale them out separately too.
http://daemon.co.za/2012/05/replacing-couchdb-views-with-ela...
Hey Adrian I have got a question. Why did you chose elastic search for indexing couchdb data. Why not couchdb-lucene?
Couchdb-lucene seems more tightly integrated with couchdb to to me.
Re:MongoDB, Better
by AdrianRossouw on Monday March 31, 2014 @09:46AM
(#7501381)
I think it wasn't 'ready' at that point in time, and the json based query language was closer to what we needed.
The real problem was that the data was being imported in bulk by the user, from a many-meg-sized csv . It would grind couchdb to a halt trying to build views, so having elasticsearch be a separate process that could work through it made a lot of sense.
Thanks for answering. I have used elastic search before and I was very impressed by it. Now I am trying to evaluate couchdb-lucene to see if it can prove to be a good alternative.
There's no need to go through all of that trouble.. Why not just use Cloudant until the BigCouch merge hits ? :)
Re:MongoDB, Better
by AdrianRossouw on Sunday March 30, 2014 @10:40PM
(#7499247)
Trouble? It's a single REST request to get a couch database continued indexed in elasticsearch in almost 'real-time'.
It just subscribes to the _changes feed and updates the index, in the same way couch replication works.
I spoke too soon, seems pretty bad ass in that case. gotta love _changes
Re:MongoDB, Better
by AdrianRossouw on Monday March 31, 2014 @12:41AM
(#7499667)
yeah, it's totally overpowered. =)
I think trello uses mongo primarily for production. technically it's feasible but I've found it to be more trouble than it's worth to scale -- too many machines are required per shard. I'm currently looking into rethink db as a replacement now though.