NoSQL (MongoDB) vs Lucene (or Solr) as your database [closed]

by

This is a great question, something I have pondered over quite a bit. I will summarize my lessons learned:

  1. You can easily use Lucene/Solr in lieu of MongoDB for pretty much all situations, but not vice versa. Grant Ingersoll’s post sums it up here.

  2. MongoDB etc. seem to serve a purpose where there is no requirement of searching and/or faceting. It appears to be a simpler and arguably easier transition for programmers detoxing from the RDBMS world. Unless one’s used to it Lucene & Solr have a steeper learning curve.

  3. There aren’t many examples of using Lucene/Solr as a datastore, but Guardian has made some headway and summarize this in an excellent slide-deck, but they too are non-committal on totally jumping on Solr bandwagon and “investigating” combining Solr with CouchDB.

  4. Finally, I will offer our experience, unfortunately cannot reveal much about the business-case. We work on the scale of several TB of data, a near real-time application. After investigating various combinations, decided to stick with Solr. No regrets thus far (6-months & counting) and see no reason to switch to some other.

Summary: if you do not have a search requirement, Mongo offers a simple & powerful approach. However if search is key to your offering, you are likely better off sticking to one tech (Solr/Lucene) and optimizing the heck out of it – fewer moving parts.

My 2 cents, hope that helped.

More Related Contents:

  1. Update field in exact element array in MongoDB
  2. MongoDB: How to update multiple documents with a single command?
  3. Possibility of duplicate Mongo ObjectId’s being generated in two different collections?
  4. Add new field to every document in a MongoDB collection
  5. Querying internal array size in MongoDB
  6. How can I run MongoDB as a Windows service?
  7. Where does mongodb stand in the CAP theorem?
  8. How to enforce foreign keys in NoSql databases (MongoDB)?
  9. How do you query for “is not null” in Mongo?
  10. MongoDB lookup when foreign field is an array of objects
  11. How to stop insertion of Duplicate documents in a mongodb collection
  12. MongoDB nested array query
  13. Filtering embedded documents in MongoDB
  14. MongoDB/NoSQL: Keeping Document Change History
  15. Is mongodb running?
  16. Does MongoDB support floating point types?
  17. MongoDB normalization, foreign key and joining
  18. Unique IDs with mongodb
  19. Get a document in MongoDB without specifying collection
  20. How does MongoDB sort records when no sort order is specified?
  21. How to listen for changes to a MongoDB collection?
  22. Cascade style delete in Mongoose
  23. using OR and NOT in solr query
  24. MongoDB aggregation comparison: group(), $group and MapReduce
  25. Multiple Counts with single query in mongodb
  26. How do I rename fields when performing search/projection in MongoDB?
  27. How can I sort a Meteor collection by time of insertion?
  28. How to do pagination using range queries in MongoDB?
  29. Export mongodb aggregation framework result to a new collection
  30. MongoDB aggregate by field exists

Leave a Comment