MongoDb Global Search

Hey Dev's,

The best possible approach or tool or service to do a global search across MongoDb database which holds millions of data.

I need some free tool/ product. Any suggestions.

Thanks in advance 👍

Comments

[Matt Ryan]

You could try using Atlas Search

You could also try with js.

db.movies.findOne()
db.getCollectionNames().forEach(function(collection) {
  print(collection);
});

Then run

mongo movies dbsearch.js

Or you can use db.eval

Somthing like

db.eval( function() {
    var one = db.movies.find({"title":"The Matrix"});
    var two = db.movies.find({"title":"Black Panther"});
});

[Dhanush N]

Hi Matt, thanks for your input

Actually Atlas Search is good but it is paid when it comes to production use case & also while creating indexes, there is a limit.

Is there anyother tool which is free of cost or opensource & effective to deal with millions of records in db ?

[Matt Ryan]

Have you checked out ElasticSearch?

Indexing MongoDB with ElasticSearch

Integrating Elasticsearch and MongoDB

[Jordan Finneran]

You could also use Mongo Free Text Search Indexs
docs.mongodb.com/manual/core/index...

[Dhanush N]

But if you have to use for production then we have to pay right ? Any free solution available ?

[Jordan Finneran]

If you're going to use anything in production over 'millions of records' as you said, yes you will probably have to pay for it.
If you are productionising anything you'll have to pay for something.

The best you can do is look for a serverless option so only pay for what you use.

[Dhanush N]

Just thinking of indexing MongoDb with elasticsearch in production so that the search would be free of cost. Still exploring more on that

[Jordan Finneran]

Using mongodbs built in search functionality, if you already have mongodb would be free. If you use the link I provided.

[Dhanush N]

Great Thanks , But do you know whats the key differences between MongoDb built in search vs Atlas search ?

[Jordan Finneran]

Not myself but I'm sure your search engine of choice will 😊