While Pentaho and Jaspersoft and other legacy reporting solutions have ways to pump data out of MongoDB, there are two newer solutions designed explicitly for analytics and reporting on MongoDB data: JSON Studio. This is a commercial solution that lets you visually build aggregation pipelines and connect them to charts. SlamData. This is an open … Read more
Since 3.2, we can use $arrayElemAt to get the first element in an array db.my_collection.aggregate([ { $project: { resp : { $arrayElemAt: [‘$my_field’,0] } }} ])
If you intend to use $gt with strings, you will have to use regex, which is not great in terms of performance. It is easier to just create a new field which holds the number value of price or change this field type to int/double. A javascript version should also work, like so: db.products.find(“this.price > … Read more
For some reason in Windows 10 it is installed into the hidden AppData directory. At least I found first a shortcut ‘MongoDB Compass’ here: C:\Users\<username>\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\MongoDB Inc and then in the properties of it the actual location seems to be C:\Users\<username>\AppData\Local\MongoDBCompass\MongoDBCompass.exe
You’re right, you need to use NGINX’s stream module by adding a stream section to your .conf file: stream { server { listen <your incoming Mongo TCP port>; proxy_connect_timeout 1s; proxy_timeout 3s; proxy_pass stream_mongo_backend; } upstream stream_mongo_backend { server <localhost:your local Mongo TCP port>; } }
As suggested in accepted answer, you need to have your local server to be run as a replica set to be able to perform transactions, as opposed to standalone server. However, in addition to the proposed solution, you can easily convert your Standalone local db to a Replica Set without using any third-party tool, by … Read more
You have to escape $ by \: db.myCollection.find({ myKey : /.*\$aus.*/i }); // OR db.myCollection.find({myKey: { $regex: ‘.*\\$aus.*’, $options: ‘i’}})
I’m using the mongodb 3.4 official docker image. Since the mongod doesn’t read a config file by default, this is how I start the mongod service: docker run -d –name mongodb-test -p 37017:27017 \ -v /home/sa/data/mongod.conf:/etc/mongod.conf \ -v /home/sa/data/db:/data/db mongo –config /etc/mongod.conf removing -d will show you the initialization of the container Using a docker-compose.yml: … Read more
No, there’d be no way to install and run it if you are only using shared hosting account. You would need the ability to log on and make changes. However, you could always look into alternatives like using an external MongoDB hosted service such as MongoHQ. That way, you can still use MongoDB. The downside … Read more
If you want to just update Role of User. You can do in the following way db.updateUser( “userName”, { roles : [ { role : “dbAdmin”, db : “dbName” }, { role : “readWrite”, db : “dbName” } ] } ) Note:- This will override only roles for that user.