
<h2>Pre requirement</h2>
<ul>
  <li>Set up an AWS account</li>
  <li>MongoDB is running under the EC2 Linux Instance</li>
</ul>
<p>
  To sending MongoDB log file, we assume you have setup EC2 instance with
  MongoDB, now following are steps how to send logs to the CloudWatch logs.
</p>
<h2>Install old CloudWatch logs agent</h2>
<p>Update Amazon Linux 2 instance with the latest repositories.</p>
<pre class="language-markup"><code>sudo yum update -y</code></pre>
<p>Install AWS logs to EC2 instance.</p>
<pre class="language-markup"><code>sudo yum install -y awslogs</code></pre>
<p>
  You'll need to cd to the following file to modify the AWS region if you're not
  using the default region
</p>
<pre class="language-markup"><code>/etc/awslogs/awscli.conf</code></pre>
<p>
  open the awslogs.conf file to modify the configuration for the CloudWatch
  logs.
</p>
<pre class="language-markup"><code>cd /etc/awslogs/
nano awslogs.conf</code></pre>
<p>
  After open the awslogs.conf file, you can modify by add following section,
  <strong>log-stream2</strong>. It will create define a new log group name as
  <strong>ta-mongo-logs</strong>, which will show on the CloudWatch logs, and
  push all the logs from <strong>/var/log/mongodb/mongod.log</strong> to the
  cloudwatch logs.
</p>
<p>
  By doing it in this way, you can continue to add more section for different
  log files and push it to the CloudWatch logs.&nbsp;
</p>
<pre class="language-markup"><code>[log-stream2]
datetime_format = %b %d %H:%M:%S
file = /var/log/mongodb/mongod.log
buffer_duration = 5000
log_stream_name = {instance_id}
initial_position = start_of_file
log_group_name = ta-mongo-logs</code></pre>


This blog shows how to send MongoDB log files to AWS CloudWatch logs, you can spend multiple logs to the AWS CloudWatch logs bydefining the awslogs.config file.

How to Send MongoDB Logs to CloudWatch Logs


<p>
  This blog shows how to set up MongoDB 4.4 Community version on windows 10 as a
  local development environment, create a simple database, table, and
  collection, and how to backup and store data by using mongoexport and
  mongoimport.
</p>
<h3></h3>
<h2>Install MongoDB Server</h2>
<p>
  First, go to the official MongoDB installation link
  <a
    href="https://www.mongodb.com/try/download/community"
    title="MongoDB community download"
    target="_blank"
    rel="noopener"
    >here</a
  >
  to download the installation file. After the download following the
  installation wizard to install MongoDB.&nbsp;
</p>
<h3>Choose Location</h3>
<p>
  The default location is under windows' C drive, you can modify the location to
  other places. I'm using the D:\MongoDB on this blog.
</p>
<h3>Choose Install MongoDB as Service</h3>
<p>
  If you choose to install MongoDB as a service, the installation will create a
  windows service so the MongoDB will be running as background. I think most of
  the time you should choose.
</p>
<h3>Choose Data Directory &amp; Log Directory</h3>
<p>
  By default, MongoDB will store logs under the MongoDB installation location.
  For example, I set D:\MongoDB, so my logs will be D:\MongoDB\log. Same as the
  data should be under D:\MongoDB\data, however, you can change to another
  location if you want.
</p>
<p>
  That should be all to install MongoDB server, if you just need the MongoDB
  server to run you are done with the setup. For example, if you're trying to
  install MongoDB on the production server.
</p>
<h2>Install MongoDB Tools</h2>
<p>
  Starting from MongoDB 4.4, the mongodump, mongoexport, mongoimport and some
  other commands will not include as part of MongoDB server setup, you have to
  install separately, go
  <a
    href="https://www.mongodb.com/try/download/database-tools?tck=docs_databasetools"
    title="Install MongoDB tools"
    target="_blank"
    rel="noopener"
    >here</a
  >
  and download the files. After downloading the file, you should see a list of
  files as mongoexport, mongoimport under the bin folder. You'll need these to
  run mongoexport or mongoimport command later.
</p>
<h2>Install MongoDB Compass</h2>
<p>
  MongoDB Compass is the GUI tool, you should install on your local development
  environment so you can connect to the MongoDB server and run the query from
  GUI. If you installed your MongoDB already, after open the MongoDB Compass,
  you can type the following local URL to connect to the local instance of
  MongoDB.
</p>
<pre class="language-javascript"><code>mongodb://localhost:27017</code></pre>
<h2>Create Database, Collection, and Record</h2>
<p>
  After you install MongoDB Compass and connect to the localhost MongoDB
  instance, you should be able to easily create new database, collection, and
  record.&nbsp;
</p>
<p>
  You could also use the command line or the MONGOSH BETA command line window at
  the Compass UI.
</p>
<h3>Create Database</h3>
<pre class="language-javascript"><code>show dbs
use myNewDatabase</code></pre>
<p>
  &nbsp;First <strong>show dbs</strong> will list all the databases, the
  <strong>use myNewDtabase </strong>will create a database but you won't see it
  until you add a new collection.
</p>
<h3>Create Table and Record</h3>
<pre
  class="language-markup"
><code>db.myUser.insert({name: "john"});</code></pre>
<p>
  This command will create a new table myUser and insert a new record into the
  collection.
</p>
<h2>MongoDB Backup and Restore Data</h2>
<p>
  At this point, you can MongoDB server installed and able to create a database
  and collection, next I'd like to try to backup and restore data by using
  mongoexport and mongoimport. The mongoexport will export the data from MongoDB
  as JSON file, then use mongoimport can import the JSON file into the
  MongoDB.&nbsp;
</p>
<p>
  This will work in a small development environment, as you want to export a
  list of data then dump it into another environment from this JSON file.&nbsp;
</p>
<h3>Use Mongoexport to export data to JSON</h3>
<p>
  First, cd to the location that has the mongoexport executable file then run
  the following command.
</p>
<pre
  class="language-markup"
><code>mongoexport --collection=myUser --db=myDB --out=myUser.json</code></pre>
<p>
  This command will look up the <strong>myDB</strong> database's
  <strong>myUser</strong> collection, then output the whole result into
  <strong>myUser.json</strong> file.&nbsp;
</p>
<h3>Use Mongoimport to import data to the existing MongoDB Server</h3>
<p>
  Following command will use <strong>myUser.json</strong> and then override the
  myUser collection, used mode as upsert so any existing same record will be
  replaced.
</p>
<pre
  class="language-markup"
><code>mongoimport --collection=myUser --db=myDB --file=myUser.json --mode=upsert
</code></pre>
<h4>Conclusion</h4>
<p>
  That's how you can set up MongoDB on Windows as a development environment, and
  how to create simple records along with backup and restore data. MongoDB
  documentation is much better to compare to a few years back, you can find very
  detailed documentation about each step you need. Also, the tool like Compass
  is very helpful.&nbsp;
</p>


This blog shows how to set up MongoDB 4.4 Community version on windows 10 as a local development environment, create a simpledatabase, table, and collection, and how to backup and store data by using mongoexport and mongoimport.

How to Setup MongoDB on Windows


<p>
  This blog will show a tutorial about how to find data into MongoDB by using
  Node.js with Mongoose. Mongoose is the Object Data Modeling library for
  MongoDB and Node.js. It provides functions for schema, query building, and
  more. If you don't use Mongoose to access MongoDB with Node.js, then you can
  use the MongoDB package for Node.js directly.&nbsp;
</p>
<h2>Get Start</h2>
<p>
  First, initialize a new npm package, we'll create a new package and new file,
  and add our code for how to insert data to MongoDB.
</p>
<pre class="language-markup"><code>npm init -y</code></pre>
<p>
  Next, let's install the mongoose package, this will be the only package we'll
  use for this tutorial.&nbsp;
</p>
<pre class="language-javascript"><code>npm install --save mongoose</code></pre>
<p>
  Create an <strong>index.js</strong>, we'll add our code to this file to
  connect to MongoDB and insert data to the Database.
</p>
<h2>Connect to the MongoDB</h2>
<p>
  Now, the following is a sample code to connect to MongoDB. Assume you already
  set up MongoDB at your local and has a database as
  <strong>your-database</strong>.
</p>
<pre class="language-javascript"><code>const {connect} = require('mongoose');

connect('mongodb://localhost:27017/your-database')
.then(() =&gt; {
    console.info('connect successfully')
})
.catch(() =&gt; {
    console.error('connection error');
});</code></pre>
<h2>Defined MongoDB Schema</h2>
<p>
  Here, we'll define our collection in MongoDB, the collection name will be
  <strong>my-collection-name</strong>.
</p>
<pre class="language-javascript"><code>let localModel = new Schema({
    key: {
        type: String
    },
    value: {
        type: String
    },
    culture: {
        type: String
    }
})

let localSchema = model('localization', localModel, 'my-collection-name');</code></pre>
<h2>Find data from MongoDB</h2>
<p>
  Now, this is the final step we'll find data from this collection after this
  code had run it should return a list of result match the key is 'test-key'
  from collection <strong>my-collection-name</strong>.
</p>
<pre class="language-javascript"><code>const getDataAsync = async() =&gt; {
    
    let result = await localSchema.find({key: 'test-key'});

}

getDataAsync();</code></pre>
<p>If you only expect to return one record, you can do the following query.</p>
<pre class="language-javascript"><code>const getOneAsync = async() =&gt; {

    let result = await localSchema.findOne({key: 'test-key'});
    console.info(result);
}

getOneAsync();</code></pre>
<p>
  If you want to find the one then update it, you can try the following code.
  It'll find then update with the new value.
</p>
<pre class="language-javascript"><code>const getAndModifyAsync = async() =&gt; {

    let result = await localSchema.findOneAndUpdate({key: 'test-key'}, {
        value: "my new value"
    })
}

getAndModifyAsync();</code></pre>
<h3>Conclusion</h3>
<p>
  Above is how you can get data from MongoDB by using Node.js with Mongoose.
</p>


This blog will show a tutorial about how to find data into MongoDB by using Node.js with Mongoose.

How to Find Record from MongoDB with Node.js and Mongoose


<p>
  This blog will show a tutorial about how to delete data from MongoDB by using
  Node.js with Mongoose. Mongoose is the Object Data Modeling library for
  MongoDB and Node.js. It provides functions for schema, query building, and
  more. If you don't use Mongoose to access MongoDB with Node.js, then you can
  use the MongoDB package for Node.js directly.&nbsp;
</p>
<h2>Get Start</h2>
<p>
  First, initialize a new npm package, we'll create a new package and new file,
  and add our code for how to insert data to MongoDB.
</p>
<pre class="language-markup"><code>npm init -y</code></pre>
<p>
  Next, let's install the mongoose package, this will be the only package we'll
  use for this tutorial.&nbsp;
</p>
<pre class="language-javascript"><code>npm install --save mongoose</code></pre>
<p>
  Create an <strong>index.js</strong>, we'll add our code to this file to
  connect to MongoDB and insert data to the Database.
</p>
<h2>Connect to the MongoDB</h2>
<p>
  Now, the following is a sample code to connect to MongoDB. Assume you already
  set up MongoDB at your local and has a database as
  <strong>your-database</strong>.
</p>
<pre class="language-javascript"><code>const {connect} = require('mongoose');

connect('mongodb://localhost:27017/your-database')
.then(() =&gt; {
    console.info('connect successfully')
})
.catch(() =&gt; {
    console.error('connection error');
});</code></pre>
<h2>Defined MongoDB Schema</h2>
<p>
  Here, we'll define our collection in MongoDB, the collection name will be
  <strong>my-collection-name</strong>.
</p>
<pre class="language-javascript"><code>let localModel = new Schema({
    key: {
        type: String
    },
    value: {
        type: String
    },
    culture: {
        type: String
    }
})

let localSchema = model('localization', localModel, 'my-collection-name');</code></pre>
<h2>Insert some data to MongoDB</h2>
<p>
  Before we can try the Mongoose Delete function, let's add some test data. The
  following code will add 100 different records into the collection.
</p>
<pre
  class="language-javascript"
><code>const createTestMillionAsync = async(roopLimit) =&gt; {
    let timerName = `insert-timer-${roopLimit}`;
    console.time(timerName)
    let testTargetList = [];
    for (let index = 0; index &lt; roopLimit; index++) {
    
        testTargetList.push({
            key: `test-key-${index}`,
            value: `my test value : ${index}`,
            culture: 'en-US'
        });    
    
    }
    
    await localSchema.insertMany(testTargetList);

    console.timeEnd(timerName);
}

createTestMillionAsync(100);</code></pre>
<h2>Try delete Records with Mongoose</h2>
<p>
  The following is example is for deleting the specific record, so you just need
  to call the deleted one and pass the _id value.
</p>
<pre class="language-javascript"><code>const removeDataAsync = async() =&gt; {
    
  let result = await localSchema.deleteOne({
        _id: '60a872a9d3ed022504e3aa01'
    });
    if (result) {
        console.info('update successfully', result);
    }
}

removeDataAsync();</code></pre>
<p>
  In case you want to delete everything from the collection, you can try the
  following code.&nbsp;
</p>
<pre class="language-javascript"><code>const removeDataAsync = async() =&gt; {
    
    let result = await localSchema.deleteMany({});
    if (result) {
        console.info('update successfully', result);
    }
}

removeDataAsync();</code></pre>
<p></p>
<h3>Conclusion</h3>
<p>
  Above is how you can use the delete function with Mongoose to MongoDB by using
  Node.js.
</p>


This blog will show a tutorial about how to delete data from MongoDB by using Node.js with Mongoose.

How to Delete Data from MongoDB with Node.js and Mongoose


<p>
  This blog will show a tutorial about how to update data into MongoDB by using
  Node.js with Mongoose. Mongoose is the Object Data Modeling library for
  MongoDB and Node.js. It provides functions for schema, query building, and
  more. If you don't use Mongoose to access MongoDB with Node.js, then you can
  use the MongoDB package for Node.js directly.&nbsp;
</p>
<h2>Get Start</h2>
<p>
  First, initialize a new npm package, we'll create a new package and new file,
  and add our code for how to insert data to MongoDB.
</p>
<pre class="language-markup"><code>npm init -y</code></pre>
<p>
  Next, let's install the mongoose package, this will be the only package we'll
  use for this tutorial.&nbsp;
</p>
<pre class="language-javascript"><code>npm install --save mongoose</code></pre>
<p>
  Create an <strong>index.js</strong>, we'll add our code to this file to
  connect to MongoDB and insert data to the Database.
</p>
<h2>Connect to the MongoDB</h2>
<p>
  Now, the following is a sample code to connect to MongoDB. Assume you already
  set up MongoDB at your local and has a database as
  <strong>your-database</strong>.
</p>
<pre class="language-javascript"><code>const {connect} = require('mongoose');

connect('mongodb://localhost:27017/your-database')
.then(() =&gt; {
    console.info('connect successfully')
})
.catch(() =&gt; {
    console.error('connection error');
});</code></pre>
<h2>Defined MongoDB Schema</h2>
<p>
  Here, we'll define our collection in MongoDB, the collection name will be
  <strong>my-collection-name</strong>.
</p>
<pre class="language-javascript"><code>let localModel = new Schema({
    key: {
        type: String
    },
    value: {
        type: String
    },
    culture: {
        type: String
    }
})

let localSchema = model('localization', localModel, 'my-collection-name');</code></pre>
<h2>Update data from MongoDB</h2>
<p>
  Now, this is the final step we'll find data from the collection, then update
  the data. Following code will first find records by key 'test-key', then
  update the value field.&nbsp;
</p>
<pre class="language-javascript"><code>const updateDataAsync = async() =&gt; {
    
    let result = await localSchema.find({key: 'test-key'});
    if (result) {
        let updateResult = await localSchema.updateOne({
            _id: result[0]._id
        }, {
            value: 'test3'
        });
        if (updateResult) {
            console.info('update successfully')
        }
    }
}

updateDataAsync();</code></pre>
<h3>Conclusion</h3>
<p>
  Now, above is how you can update data from MongoDB by using Node.js with
  Mongoose.
</p>


How to Update MongoDB Data with Node.js and Mongoose


<p>
  This blog will show a tutorial about how to insert data into MongoDB by using
  Node.js with Mongoose. Mongoose is the Object Data Modeling library for
  MongoDB and Node.js. It provides functions for schema, query building, and
  more. If you don't use Mongoose to access MongoDB with Node.js, then you can
  use the MongoDB package for Node.js directly.&nbsp;
</p>
<h2>Get Start</h2>
<p>
  First, initialize a new npm package, we'll create a new package and new file,
  and add our code for how to insert data to MongoDB.
</p>
<pre class="language-markup"><code>npm init -y</code></pre>
<p>
  Next, let's install the mongoose package, this will be the only package we'll
  use for this tutorial.&nbsp;
</p>
<pre class="language-javascript"><code>npm install --save mongoose</code></pre>
<p>
  Create an <strong>index.js</strong>, we'll add our code to this file to
  connect to MongoDB and insert data to the Database.
</p>
<h2>Connect to the MongoDB</h2>
<p>
  Now, the following is a sample code to connect to MongoDB. Assume you already
  set up MongoDB at your local and has a database as
  <strong>your-database</strong>.
</p>
<pre class="language-javascript"><code>const {connect} = require('mongoose');

connect('mongodb://localhost:27017/your-database')
.then(() =&gt; {
    console.info('connect successfully')
})
.catch(() =&gt; {
    console.error('connection error');
});</code></pre>
<h2>Defined MongoDB Schema</h2>
<p>
  Here, we'll define our collection in MongoDB, the collection name will be
  <strong>my-collection-name</strong>.
</p>
<pre class="language-javascript"><code>let localModel = new Schema({
    key: {
        type: String
    },
    value: {
        type: String
    },
    culture: {
        type: String
    }
})

let localSchema = model('localization', localModel, 'my-collection-name');</code></pre>
<h2>Insert new data into MongoDB</h2>
<p>
  Now, this is the final step we'll insert new data into the collection, we'll
  use <strong>insertMany.</strong> after this code it should insert new data
  into the collection <strong>my-collection-name</strong>.
</p>
<pre class="language-javascript"><code>localSchema.insertMany({
    key: 'test-key',
    value: 'key description',
    culture: 'en-US'
}).then(function() {
    console.info('insert new data successfully')
}).catch(function() {
    console.error('has error when insert new data');
})</code></pre>
<h3>Insert Data to MongoDB by using mongoose.create</h3>
<p>
  Another way to insert into data is following, but then which one is better?
  Should I use insert or create.&nbsp;
</p>
<pre class="language-javascript"><code>const createAsync = async() =&gt; {
    await localSchema.create({
        key: 'test-key-2',
        value: 'key2 description',
        culture: 'en-US'
    });    
}

createAsync();</code></pre>
<p>
  So, looks like it is better to use mongoose.insert because it's faster and
  less issue. So I did some research by insert 100,000 records into MongoDB.
</p>
<p>
  When I execute the following record on my macOS, the insert-timer's time was
  11922.764ms.&nbsp;
</p>
<pre
  class="language-javascript"
><code>const createTestMillionAsync = async() =&gt; {
    console.time('insert-timer')
    let testTargetList = [];
    for (let index = 0; index &lt; 100000; index++) {
    
        testTargetList.push({
            key: `test-key-${index}`,
            value: `my test value : ${index}`,
            culture: 'en-US'
        });    
    
    }
    
    await localSchema.insertMany(testTargetList);

    console.timeEnd('insert-timer');
}

createTestMillionAsync();</code></pre>
<p>
  However, when I tried following 100,000 records with creating I was getting
  timed out error, the default connection time out is 10000ms.
</p>
<pre
  class="language-javascript"
><code>const createTestMillionAsync = async(roopLimit) =&gt; {
    let timerName = `insert-timer-${roopLimit}`;
    console.time(timerName)
    let testTargetList = [];
    for (let index = 0; index &lt; roopLimit; index++) {
    
        testTargetList.push({
            key: `test-key-${index}`,
            value: `my test value : ${index}`,
            culture: 'en-US'
        });    
    
    }
    
    await localSchema.insertMany(testTargetList);

    console.timeEnd(timerName);
}

createTestMillionAsync(100000);</code></pre>
<p>
  So I extend the connectionTimeout from 10000 to 50000, re-run as following
  combination, you can see that insertMany are 7 times faster than create.&nbsp;
</p>
<table border="1" style="border-collapse: collapse; width: 100%">
  <tbody>
    <tr>
      <td style="width: 48.0302%"><strong>Records</strong></td>
      <td style="width: 24.0151%"><strong>mongoose.create</strong></td>
      <td style="width: 24.0151%">
        <strong>mongoose.insertMany</strong>
      </td>
    </tr>
    <tr>
      <td style="width: 48.0302%">100000</td>
      <td style="width: 24.0151%">75261.921ms&nbsp;</td>
      <td style="width: 24.0151%">11869.793.ms</td>
    </tr>
    <tr>
      <td style="width: 48.0302%">500000</td>
      <td style="width: 24.0151%">Error: Javascript heap out of memory</td>
      <td style="width: 24.0151%">61775.343ms</td>
    </tr>
  </tbody>
</table>
<h3>Conclusion</h3>
<p>
  Above is how you can insert new data into MongoDB with Node.js with Mongoose.
  Looks like it's better to use InsertMany for better performance.
</p>


This blog will show a tutorial about how to insert data into MongoDB by using Node.js with Mongoose.

How to Insert Data into MongoDB with Node.js and Mongoose


<p>
  This blog shows how to set up MongoDB 4.4 Community version on Mac OS, also
  will create a simple database, table, and collection, and how to backup and
  store data by using mongoexport and mongoimport.
</p>
<h2>Install MongoDB Server</h2>
<p>
  Install MongoDB on Mac is a little different compare to the Mac, you'll need
  brew to install the MongoDB, on this blog assume brew is already installed on
  Mac.
</p>
<h3>Download Homebrew formula for MongoDB</h3>
<pre class="language-markup"><code>brew tap mongodb/brew</code></pre>
<h3>Install MongoDB in macOS</h3>
<pre
  class="language-markup"
><code>brew install mongodb-community@4.4</code></pre>
<h2>Install MongoDB Tools</h2>
<p>
  Starting from MongoDB 4.4, use brew will also install the mongodump,
  mongoexport, mongoimport and some other commands.
</p>
<h2>Install MongoDB Compass</h2>
<p>
  MongoDB Compass is the GUI tool, you should install on your local development
  environment so you can connect to the MongoDB server and run the query from
  GUI.&nbsp;
</p>
<p>
  To install MongoDB Compass on macOS, you'll go to the official site
  <a
    href="https://www.mongodb.com/try/download/compass"
    title="MongoDB Compass"
    target="_blank"
    rel="noopener"
    >here</a
  >
  to download the dmg file and install it on your macOS.
</p>
<p>
  To connect to the localhost MongoDB instance just enter the following URL at
  MongoDB Compass UI.
</p>
<pre class="language-javascript"><code>mongodb://localhost:27017</code></pre>
<h2>Create Database, Collection, and Record</h2>
<p>
  After you install MongoDB Compass and connect to the localhost MongoDB
  instance, you should be able to easily create a new database, collection, and
  record.&nbsp;
</p>
<p>
  You could also use the command line or the MONGOSH BETA command line window at
  the Compass UI.
</p>
<h3>Create Database</h3>
<pre class="language-javascript"><code>show dbs
use myNewDatabase</code></pre>
<p>
  &nbsp;First <strong>show dbs</strong> will list all the databases, the
  <strong>use myNewDtabase </strong>will create a database but you won't see it
  until you add a new collection.
</p>
<h3>Create Table and Record</h3>
<pre
  class="language-markup"
><code>db.myUser.insert({name: "john"});</code></pre>
<p>
  This command will create a new table myUser and insert a new record into the
  collection.
</p>
<h2>MongoDB Backup and Restore Data</h2>
<p>
  At this point, you can MongoDB server installed and able to create a database
  and collection, next I'd like to try to backup and restore data by using
  mongoexport and mongoimport. The mongoexport will export the data from MongoDB
  as JSON file, then use mongoimport can import the JSON file into the
  MongoDB.&nbsp;
</p>
<p>
  This will work in a small development environment, as you want to export a
  list of data then dump it into another environment from this JSON file.&nbsp;
</p>
<h3>Use Mongoexport to export data to JSON</h3>
<p>
  First, cd to the location that has the mongoexport executable file then run
  the following command.
</p>
<pre
  class="language-markup"
><code>mongoexport --collection=myUser --db=myDB --out=myUser.json</code></pre>
<p>
  This command will look up the <strong>myDB</strong> database's
  <strong>myUser</strong> collection, then output the whole result into
  <strong>myUser.json</strong> file.&nbsp;
</p>
<h3>Use Mongoimport to import data to the existing MongoDB Server</h3>
<p>
  Following command will use <strong>myUser.json</strong> and then override the
  myUser collection, used mode as upsert so any existing same record will be
  replaced.
</p>
<pre
  class="language-markup"
><code>mongoimport --collection=myUser --db=myDB --file=myUser.json --mode=upsert
</code></pre>
<p></p>


This blog shows how to set up MongoDB 4.4 Community version on Mac OS, also will create a simple database, table, and collection,and how to backup and store data by using mongoexport and mongoimport.

How to Setup MongoDB on Mac


<p>
  This blog shows how to set up a MongoDB database environment on the cloud, AWS
  EC2 with Amazon Linux.&nbsp;
</p>
<h2>Pre requirement</h2>
<ul>
  <li>
    You'll need an AWS account, if you never set up an AWS account before, go
    <a
      href="https://aws.amazon.com/free/?all-free-tier.sort-by=item.additionalFields.SortRank&amp;all-free-tier.sort-order=asc&amp;awsf.Free%20Tier%20Types=*all&amp;awsf.Free%20Tier%20Categories=*all"
      title="AWS Free Tier"
      target="_blank"
      rel="noopener"
      >here</a
    >
    to create an AWS account.
  </li>
</ul>
<h2>Create EC2 Instance</h2>
<p>
  First, we'll need to set up an EC2 instance, then we'll SSH into the EC2
  instance and set up the MongoDB database.
</p>
<p>Create EC2 Instance with AWS Linux AMI.</p>
<p>Choose t2.micro.</p>
<p>
  During the setup everything as default is fine for this blog, we'll use
  default VPC, as long as the new EC2 can access the internet.&nbsp;
</p>
<p>
  For the security group, we'll just open port 22, so we can SSH later to into
  EC2 for setup MongoDB.
</p>
<h2>Setup MongoDB at EC2 AWS Linux</h2>
<p>
  After SSH into EC2, we'll need to create mongodb-org-4.4.repo file at location
  /ect/yum.repos.d.
</p>
<pre class="language-markup"><code>cd /etc/yum.repos.d</code></pre>
<p>Then, let's create mongodb-org-4.4.repo file.</p>
<pre class="language-markup"><code>nano mongodb-org-4.4.repo</code></pre>
<p>
  &nbsp;This will open the file window, copy the following mongod repo at the
  file and save it.
</p>
<pre class="language-markup"><code>[mongodb-org-4.4]
name=MongoDB Repository
baseurl=https://repo.mongodb.org/yum/amazon/2/mongodb-org/4.4/x86_64/
gpgcheck=1
enabled=1
gpgkey=https://www.mongodb.org/static/pgp/server-4.4.asc</code></pre>
<p>
  Now, mongod 4.4 repo is ready, you should be able to install mongodb package.
</p>
<pre class="language-markup"><code>sudo yum install -y mongodb-org</code></pre>
<p>
  Once you see start downloading mongodb packages, that's a good sign. Once
  install MongoDB package is finish, you can verify by checking this folder is
  exist or not. If the folder exists, means MongoDB installation is done and you
  should be good to run MongoDB.
</p>
<pre class="language-markup"><code>cd /var/lib/mongo</code></pre>
<h2>Enable MongoDB on Linux</h2>
<p>Run following command will start MongoDB process at the EC2 Instance</p>
<pre class="language-markup"><code>sudo systemctl start mongod</code></pre>
<p>Run this command will enable mongod, even after reboot the EC2</p>
<pre class="language-markup"><code>sudo systemctl enable mongod</code></pre>
<p>
  Now, at this point, your MongoDB on Linux Server should be ready. If you have
  data you can import or restore it to the MongoDB server.
</p>
<h2>Create Database, Collection, and Record</h2>
<p>
  Type mongo then it will start MongoDB shell, now let's play around at the
  server to check everything works.
</p>
<pre class="language-markup"><code>mongo</code></pre>
<h3>Create Database</h3>
<p>
  The first command will show all the databases, then trying to create a new
  database <strong>myDB</strong>.
</p>
<pre class="language-markup"><code>show dbs
use myDB</code></pre>
<h3>Create Table and Record</h3>
<p>
  This command will create <strong>myUser</strong> table and insert a new
  record.
</p>
<pre
  class="language-markup"
><code>db.myUser.insert({name: "john"});</code></pre>
<h3>Use mongoexport&nbsp; to export data to JSON</h3>
<p>
  We'll use mongoexport to export the data we just add to the
  <strong>myUser</strong> table. By default, the mongoexport tools are not
  installed. You'll need to install by run following command.
</p>
<pre
  class="language-markup"
><code>sudo yum list installed mongodb-database-tools</code></pre>
<p>
  Now, all other tools mongodump, mongorestore, mongoimport, mongoexport,
  bsondump, mongostat, mongotop, mongofiles should be available to use.
</p>
<p>
  The following command will output <strong>myUser</strong> table and generate
  data to myUser.json file.
</p>
<pre
  class="language-markup"
><code>mongoexport --collection=myUser --db=myDB --out=myUser.json</code></pre>
<h2>To Summarize</h2>
<p>
  This blog is about how to set up MongoDB on Amazon Linux and will use database
  tools for backup or restore data. Following are all the steps.
</p>
<pre class="language-markup"><code>cd /etc/yum.repos.d

nano mongodb-org-4.4.repo

[mongodb-org-4.4]
name=MongoDB Repository
baseurl=https://repo.mongodb.org/yum/amazon/2/mongodb-org/4.4/x86_64/
gpgcheck=1
enabled=1
gpgkey=https://www.mongodb.org/static/pgp/server-4.4.asc

sudo yum install -y mongodb-org

sudo systemctl start mongod</code></pre>


This blog shows how to set up a MongoDB database environment on the cloud, AWS EC2 with Amazon Linux.

How to Setup MongoDB on Amazon Linux EC2


<p>1. Mongo Collection class</p>
<p>Define your C# model as collection.</p>
<pre class="language-csharp"><code> public class LocationModel
    {
        public MongoDB.Bson.ObjectId Id { get; set; }
        public string YouLocationBasedData { get; set; }
        public GeoJsonPoint Location { get; set; }
    }
</code></pre>
<p>2. Example of Saving location data to MongoDB</p>
<p>
  Before you retrieve your location from MongoDB, you need to store to the
  database.
</p>
<p>Following is example of saving the data.</p>
<pre class="language-csharp"><code>Location location = new Location();
                location.Location = new GeoJsonPoint(
                    new GeoJson2DGeographicCoordinates(lng, lat));

MethodOfAddDataToYourMongoDB(location);</code><span style="font-family: 'Helvetica Neue', Helvetica, Arial, Helvetica, sans-serif;">&nbsp;</span></pre>
<p>3. Retrieve location data based on Lng and Lat</p>
<pre
  class="language-csharp"
><code>var collection = MongoDatabase.GetCollection("Location");
            collection.CreateIndex(IndexKeys.GeoSpatialSpherical(x =&gt; x.Location));

GeoNearArgs args = new GeoNearArgs();
            args.Limit = 1;
            args.Spherical = true;
            //args.MaxDistance = 1;
            args.Near = new GeoNearPoint.Legacy(new XYPoint(yourRequest.Longitude, yourRequest.Latitude));

GeoNearResult result = collection.GeoNearAs(args);
var localResult = result.Hits.Select(x =&gt;
            {
                return new
                {
                    SomeData= x.Document.YouLocationBasedData,
                };
            });</code></pre>
<p>http://stackoverflow.com/questions/14398308/c-sharp-mongodb-near-query</p>
<p>need&nbsp;mongocsharpdriver1.9.1 higher</p>


THis blog shows a example of how to use C# location query to MongoDB

How to perform Geospatial Queries by Using MongoDB with C#


<p>List of Free Mongodb Management tools.</p>
<p>&nbsp;1. Robomongo</p>
<p>
  <img
    src="https://d1p0mp3f1fx0hz.cloudfront.net/_5ufvwp941.png"
    alt=""
    width="457"
    height="367"
  />
</p>
<p>&nbsp;</p>
<p>2. Mongo Management Studio</p>
<p>
  <img
    class="fancybox-image"
    src="https://d1p0mp3f1fx0hz.cloudfront.net/_bxjai8746.png"
    alt=""
    width="411"
    height="415"
  />
</p>


Few GUI App to Use MongoDB at Windows


<pre class="language-javascript">
// add index to document's field
collection.CreateIndex(IndexKeys.Ascending(_ =&gt; _.FieldName));
// add index to subdocument's field
collection.CreateIndex("SubDocument.FieldName");
</pre>


Code Snippet - How to Add Index to Document at MongoDB C#


<p>This blog shows how to install simply install and use mongoDB.</p>
<p># go to mongodb site to download zip for your windows enviroment.</p>
<p>I'm using windows 7(64bit) so download windows 64bit zip file.</p>
<pre><code><img class="fancybox-image" src="http://res.cloudinary.com/dmwrakaup/image/upload/v1420658551/ybkbvo9fypfy3jat3dgy.png" alt="" width="313" height="527" /><br /># move the downloaded mongodb folder under C drive.<br /></code><code><img class="fancybox-image" src="http://res.cloudinary.com/dmwrakaup/image/upload/v1420658551/yae2rs0fgk4mssxrsgkz.png" alt="" /><br /># you can just copy this blog's command line to your local and create a command line file.<br />The command is create mongodb to your windows service and some default setting.<br /></code><br /><code><img class="fancybox-image" src="https://d1p0mp3f1fx0hz.cloudfront.net/_wlzky8y8r.png" alt="" width="466" height="241" />
:: this command require mongo db file at C drive.
:: taks will be remove the mongo db service, and add mongo db to windows service.
sc delete "MongoDB"
cd \
move C:\mongodb-win32-* C:\mongodb
md data
md data\db
md mongodb\log
echo logpath=C:\mongodb\log\mongo.log &gt; C:\mongodb\mongod.cfg
C:\mongodb\bin\mongod.exe --config C:\mongodb\mongod.cfg --install
net start mongodb
pause<br /><br /># after you run the command, you should be seen following screen that tell you setup is complete.<br /></code><code><img class="fancybox-image" src="https://d1p0mp3f1fx0hz.cloudfront.net/_733rpn24s.png" alt="" width="485" height="408" /><br /># also windows service had installed MongoDB<br /><br /></code><code><img class="fancybox-image" src="https://d1p0mp3f1fx0hz.cloudfront.net/_l9jlyemnk.png" alt="" width="487" height="132" /><br />#next step you can connect to your local mongodb service and connect db,<br />create collection, insert and show data.<br /></code><code><img class="fancybox-image" src="http://res.cloudinary.com/dmwrakaup/image/upload/v1420680064/ipdofqts6rmoajqafzz9.png" alt="" width="559" height="279" /><br /><br />#That's it, this blog trying to demo that when you want to kickstart your mongodb development at your local machine.<br />
</code></pre>


This blog shows how to install simply install and use mongoDB.

How to Setup MongoDB on Windows Service


<h2>How to use MongoDB text search</h2>
<p>
  MongoDB provide text search function since 2.4, this blog will show how to use
  mongodb text search.
</p>
<p>
  All the example at following is run based on MongoDB version, 3.0.5. Also, I'm
  using Robomongo (0.8.5) to run all the MongoDB command.
</p>
<p>
  I also have code snippet about how to use Mongoose with text search, but I
  recommend at least use 2.6, seems like 2.4 with Mongoose has some problem.
</p>
<h3>Stop Words, Stemming in MongoDB text search</h3>
<p>
  Before jump into how to use MongoDB text search, we need to understand how
  MongoDB do stop words and stemming. <strong>Stop</strong> in MongoDB is, let's
  say you have "I like apple", stop wold will be <strong>apple</strong>.
  <strong>Stemming</strong> is like "cook cooking cooks", so MongoDB text engine
  will index cook.
</p>
<blockquote>I like apple, also I enjoy cooking.</blockquote>
<p>
  Above example, MongoDB will index <code>apple</code> and <code>cook</code>,
  There is very good blog about this topic,&nbsp;<a
    href="https://blog.codecentric.de/en/2013/01/text-search-mongodb-stemming/"
    target="_blank"
    >text-search-mongodb-stemming</a
  >.
</p>
<p>&nbsp;</p>
<h3>Now, let's get started how to use MongoDB text search</h3>
<h6>Get MongoDB's version</h6>
<p>This command will tell you what version of MongoDB you're using.</p>
<pre class="language-javascript">
db.version()
// 3.0.5
</pre>
<h6>Get Current MongoDB database name</h6>
<p>
  This will return your current db name. Before you run you query you need to
  check you're running to the correct mongodb or not right?
</p>
<pre class="language-javascript">
db.getName()
// the current database name.
</pre>
<h6>Check Index of current collection</h6>
<p>
  You can run following command, if you want to check your collection had add
  text index or other index or not.
</p>
<p>
  Following example is how I check my collection
  <code>Posts&nbsp;</code>contains any index or not.
</p>
<pre class="language-javascript">
// You run this
db.posts.getIndexes()
</pre>
<pre
  class="language-javascript"
><code>// Then will some result like this or if there's no index then just empty json. Now as you can see following example contains no text search index.
{
    "0" : {
        "v" : 1,
        "key" : {
            "_id" : 1
        },
        "name" : "_id_",
        "ns" : "dake-tech.posts"
    },
    "1" : {
        "v" : 1,
        "unique" : true,
        "key" : {
            "slug" : 1
        },
        "name" : "slug_1",
        "ns" : "dake-tech.posts",
        "background" : true,
        "safe" : null
    }
}
</code>
</pre>
<p>
  Now, we're going to add text index to this collection.First the collection
  <code>Posts</code> looks like following. I'd like to add create text index to
  <code>content.brief &amp; content.extended &amp; title</code>
</p>
<pre class="language-javascript"><code>
{
    "_id" : ObjectId("535cc04cd06eabf033ee36bc"),
    "__v" : 0,
    "author" : ObjectId("535c4fe25115d24c0c4cf84b"),
    "categories" : [],
    "content" : {
        "brief" : "&lt;/code&gt;&lt;/pre&gt;
&lt;p&gt;Looks like&amp;nbsp;http://embed.ly/ is greate site, if I want to create something with URL. It'll get the short version of the url's detail. I have thought about imprement these kind of stuff, but since somebody already create this, why not just use it.&amp;nbsp;&lt;/p&gt;
&lt;pre class="language-javascript"&gt;&lt;code&gt;\r\n&lt;/code&gt;&lt;/pre&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;pre class="language-javascript"&gt;&lt;code&gt;\r\n&lt;/code&gt;&lt;/pre&gt;
&lt;p&gt;Nextime, i'll post some detail when I use it.&lt;/p&gt;
&lt;pre class="language-javascript"&gt;&lt;code&gt;",
        "extended" : ""
    },
    "publishedDate" : ISODate("2014-04-01T07:00:00.000Z"),
    "slug" : "embedly-get-url-link-detail",
    "state" : "published",
    "title" : "embed.ly - Get url link detail"
}
</code>
</pre>
<p>First, let's add text index to <code>title</code></p>
<pre class="language-javascript">
db.posts.ensureIndex({title: "text"});
</pre>
<p>
  After I create text index to the <code>title</code>field, and run
  <code>db.posts.getIndexes()</code> again to check my index, I got following
  new added index. Cool, I had added text index to my Posts.Title.
</p>
<pre class="language-javascript">
    "4" : {
        "v" : 1,
        "key" : {
            "_fts" : "text",
            "_ftsx" : 1
        },
        "name" : "title_text",
        "ns" : "dake-tech.posts",
        "weights" : {
            "title" : 1
        },
        "default_language" : "english",
        "language_override" : "language",
        "textIndexVersion" : 2
    }
</pre>
<p>
  Now, mongodb also has YouCollection.validate() which will validate your
  index.So when I run <code>db.posts.validate()</code> I got following result
  about my title field's text index. So cool right, the
  <code>"dake-tech.posts.$title_text" : 1464</code> is telling you the
  post.title indexed <code>1464</code>keys words.
</p>
<pre class="language-javascript"><code>
{
    "ns" : "dake-tech.posts",
    "datasize" : 4.72926e+006,
    "nrecords" : 325,
    "lastExtentSize" : 1.67772e+007,
    "firstExtent" : "0:ef000 ns:dake-tech.posts",
    "lastExtent" : "0:351000 ns:dake-tech.posts",
    "extentCount" : 4,
    "firstExtentDetails" : {
        "loc" : "0:ef000",
        "xnext" : "0:111000",
        "xprev" : "null",
        "nsdiag" : "dake-tech.posts",
        "size" : 8192,
        "firstRecord" : "0:ef0b0",
        "lastRecord" : "0:f0eb0"
    },
    "lastExtentDetails" : {
        "loc" : "0:351000",
        "xnext" : "null",
        "xprev" : "0:151000",
        "nsdiag" : "dake-tech.posts",
        "size" : 1.67772e+007,
        "firstRecord" : "0:3510b0",
        "lastRecord" : "0:591230"
    },
    "deletedCount" : 5,
    "deletedSize" : 1.44095e+007,
    "nIndexes" : 5,
    "keysPerIndex" : {
        "dake-tech.posts.$_id_" : 325,
        "dake-tech.posts.$slug_1" : 325,
        "dake-tech.posts.$state_1" : 325,
        "dake-tech.posts.$publishedDate_1" : 325,
        "dake-tech.posts.$title_text" : 1464
    },
    "valid" : true,
    "errors" : [],
    "warning" : "Some checks omitted for speed. use {full:true} option to do more thorough scan.",
    "ok" : 1.0000000000000000
}
</code>
</pre>
<h6>Now, let's do text search</h6>
<p>
  When you type <code>db.posts.runCommand("text", {search: "mongodb"})</code>,
  you might get result as following.
</p>
<pre class="language-javascript"><code>
{
    "ok" : 0.0000000000000000,
    "errmsg" : "no such command: text",
    "code" : 59,
    "bad cmd" : {
        "text" : "posts",
        "search" : "mongodb"
    }
}
</code>
</pre>
<h3>What's going on, doesn't work!</h3>
<p>
  You might able to try following, go to admin enable the text search. However
  you will still get the same result. What happening is following command looks
  like works for the old MongoDB, maybe 2.4 to 2.6. However, if you use latest
  MongoDB (3.0 or above), text search is enable by default, and
  <code>runCommand("text", </code> is no longer exist.
</p>
<pre class="language-javascript">
use admin
db.runCommand({setParameter: 1, textSearchEnabled: true})

db.posts.runCommand("text", {search: "mongodb"})

{
    "was" : true,
    "ok" : 1.0000000000000000
}
</pre>
<h3>So, what's I do?</h3>
<p>
  If you mongodb version is 3.0 or above like my current MongoDB, 3.0.5. You can
  try following.
</p>
<pre class="language-javascript"><code>
db.posts.find( { $text: { $search: "javascript" } } )
</code>
</pre>
<p>Also, following is the result I got. Awesome, right!? you got 12 results.</p>
<p>
  <img
    class="img-responsive"
    src="https://d1p0mp3f1fx0hz.cloudfront.net/_0eg17u58c.png"
    alt=""
  />
</p>
<p>
  Now, I'm going to add text index to my result of fields,
  <code>content.brief</code> and <code>content.extended</code>, So you type...
  <code>db.posts.ensureIndex({'content.brief': 'text'});</code>. Then you got
  this error, what's going on!!? I can only add once!?
</p>
<pre class="language-javascript"><code>
{
    "createdCollectionAutomatically" : false,
    "numIndexesBefore" : 3,
    "errmsg" : "exception: Index with pattern: { _fts: \"text\", _ftsx: 1 } already exists with different options",
    "code" : 85,
    "ok" : 0
}
</code>
</pre>
<p>
  The result is, at current version 3.0.5, you can only add one text index, if
  you want to add multi fields for text search, you could do as following.
  First, you run <code>db.posts.dropIndex('title_text')</code>, so you can drop
  the old text index.
</p>
<p>This is the result you will get.</p>
<pre class="language-javascript"><code>
{
    "nIndexesWas" : 5,
    "ok" : 1.0000000000000000
}
</code>
</pre>
<h6>Add text index to multi fields</h6>
<p>Now, you can run following command.</p>
<p>
  <code
    >db.posts.ensureIndex({title: 'text', 'content.brief': 'text',
    'content.extended': 'text'});</code
  >
</p>
<p>Once shows result as following, the new index is added.</p>
<p><code>Inserted 1 record(s) in 27ms</code></p>
<p>
  If you run <code>db.posts.getIndexes()</code>, you can verify you text index
  is added.
</p>
<pre class="language-javascript"><code>
    "4" : {
        "v" : 1,
        "key" : {
            "_fts" : "text",
            "_ftsx" : 1
        },
        "name" : "title_text_content.brief_text_content.extended_text",
        "ns" : "dake-tech.posts",
        "weights" : {
            "content.brief" : 1,
            "content.extended" : 1,
            "title" : 1
        },
        "default_language" : "english",
        "language_override" : "language",
        "textIndexVersion" : 2
    }
</code>
</pre>
<p>
  Also, if you the index validation <code>db.posts.validate()</code>, you can
  see that new text index has index <code>31429</code>key words.<code>
    "dake-tech.posts.$title_text_content.brief_text_content.extended_text" :
    31429</code
  >Compare before just title only <code>1464</code> was indexed. Now, I'd like
  to run the same text search query again, it's the fun time!!
</p>
<pre class="language-javascript"><code>
{
    "ns" : "dake-tech.posts",
    "datasize" : 4.72926e+006,
    "nrecords" : 325,
    "lastExtentSize" : 1.67772e+007,
    "firstExtent" : "0:ef000 ns:dake-tech.posts",
    "lastExtent" : "0:351000 ns:dake-tech.posts",
    "extentCount" : 4,
    "firstExtentDetails" : {
        "loc" : "0:ef000",
        "xnext" : "0:111000",
        "xprev" : "null",
        "nsdiag" : "dake-tech.posts",
        "size" : 8192,
        "firstRecord" : "0:ef0b0",
        "lastRecord" : "0:f0eb0"
    },
    "lastExtentDetails" : {
        "loc" : "0:351000",
        "xnext" : "null",
        "xprev" : "0:151000",
        "nsdiag" : "dake-tech.posts",
        "size" : 1.67772e+007,
        "firstRecord" : "0:3510b0",
        "lastRecord" : "0:591230"
    },
    "deletedCount" : 5,
    "deletedSize" : 1.44095e+007,
    "nIndexes" : 5,
    "keysPerIndex" : {
        "dake-tech.posts.$_id_" : 325,
        "dake-tech.posts.$slug_1" : 325,
        "dake-tech.posts.$state_1" : 325,
        "dake-tech.posts.$publishedDate_1" : 325,
        "dake-tech.posts.$title_text_content.brief_text_content.extended_text" : 31429
    },
    "valid" : true,
    "errors" : [],
    "warning" : "Some checks omitted for speed. use {full:true} option to do more thorough scan.",
    "ok" : 1.0000000000000000
}
</code>
</pre>
<p>
  You run
  <code
    >db.posts.find( { $text: { $search: "javascript" } }, { score: { $meta:
    "textScore" }} )</code
  >
</p>
<p>
  <img
    class="img-responsive"
    src="https://d1p0mp3f1fx0hz.cloudfront.net/_uwqsh0ebl.png"
    alt=""
  />
</p>
<p>
  Mmmm, this is not what I expected, the first result's title is not relative
  with Javascript.
</p>
<h3>How does Mongodb define score for text search?</h3>
<p>
  I don't have an answer for this yet, this is something I want to figure out.
  In the mean time, once your text search is enable, you can try something as
  following. You can also find document from MongoDB at
  <a
    href="https://docs.mongodb.org/manual/reference/operator/query/text/#text-operator-text-score"
    >Here</a
  >.
</p>
<ol>
  <li>
    search word
    <code> db.post.find( { $text: { $search: "javascript" } } ) </code>
  </li>
  <li>
    search phrase
    <code>
      db.post.find( { $text: { $search: "javascript angular react" } } )
    </code>
  </li>
  <li>
    Exclude Documents that contains term, following will search javascript and
    exclude angular from the document
    <code> db.post.find( { $text: { $search: "javascript -angular" } } ) </code>
  </li>
  <li>
    You can search for different language
    <code>
      db.post.find( { $text: { $search: "javascript", $language: "es" } } )
    </code>
  </li>
  <li>
    You can search Case Sensitive
    <code>
      db.post.find( { $text: { $search: "Javascript", $caseSensitive: true } } )
    </code>
  </li>
  <li>
    Case Sensitive for Phrase
    <code>
      db.post.find( { $text: { $search: "\"Javascript React\"", $caseSensitive:
      true } } )
    </code>
  </li>
  <li>
    Case Sensitive with exclude term, search Javascript but exclude lower-case
    javascript
    <code>
      db.post.find( { $text: { $search: "Javascript -javascript",
      $caseSensitive: true } } )
    </code>
  </li>
  <li>Diacritic Sensitive Search for a Term</li>
  <li>Diacritic Sensitivity with Negated Term</li>
  <li>
    Return the Text Search Score
    <code>
      db.posts.find( { $text: { $search: "javascript" } }, { score: { $meta:
      "textScore" }} )
    </code>
  </li>
  <li>Sort by Text Search Score</li>
  <li>Return Top 2 Matching Documents</li>
  <li>Text Search with Additional Query and Sort Expressions</li>
</ol>


How to Setup MongoDB Text Search with Node.js


<h3>First add text index to the collection.</h3>
<pre class="language-csharp"><code>
// add text index to the item
 string[] textIndex = new string[] { "Name", "ListItem.Name", "ListItem.Name2", "AnotherListItem.Name"};
            string indexName = string.Join("_text_", textIndex) + "_text";
            if (collection.IndexExistsByName(indexName))
            {
                collection.DropIndexByName(indexName);
            }
            collection.EnsureIndex(new IndexKeysBuilder().Text(textIndex));
</code></pre>
<h3>Now, call text search functions</h3>
<pre class="language-csharp"><code>
  var textSearchCommand = new CommandDocument
            {
              { "text", "CollectionName" },
              { "search", yourSearchTargetText}
            };

            var commandResult = Mongo.Database.RunCommand(textSearchCommand);
            var yourCollectionItems = commandResult.Response["results"].AsBsonArray.Select(o =&gt; 
            {
                return BsonSerializer.Deserialize(o["obj"].AsBsonDocument);
            });
</code></pre>
<h3>Mongodb need to be 2.6 or higher</h3>
<p>That's it, now you can enjoy text search in MongoDB.</p>


Simple code snippet to use mongoC# text search

How To Implement Mongodb TextSearch with C#


<p>
  I have noticed that I've been using Mongodb 2.4, text-search is beta. Some
  code like following is not going to work. outputDeal is null.
</p>
<pre
  class="language-javascript"
><code>  mycollection.textSearch(req.body.searchBox, searchOpt, function (err, outputDeal) {
        var result = inspect(outputDeal, { depth: null });
        console.info(result);
    })<br /><br /><span style="color: #494747; font-family: 'PT Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 16px; line-height: 24px; white-space: normal;">MongoDB 2.6 has more feature, see following for reference.<br />MongoDB 2.6 is now available. Key features include aggregation enhancements, text-search integration, query-engine improvements, a new write-operation protocol, and security enhancements.<br /></span></code></pre>
<p>SO this blog provide how to upgrade from 2.4 to 2.6 by following steps.</p>
<ol>
  <li>dump your mongodb data</li>
  <li>download binary 2.6 file.</li>
  <li>stop all service, app using the mongodb</li>
  <li>
    go to mongo bin folder and replace all the dll by using the new 2.6 dll.
  </li>
  <li>restart all service, app using the mongodb.</li>
  <li>you should be able to verify 2.6 by type db.version()</li>
</ol>
<p>
  after I change in above steps, I could verify my first text search query is
  working now.
</p>


Mongodb 2.6 upgrade


<p>
  This blog shows example code of how to use MongoDB's text search by use
  Mongoose. You can also find What's
  <a href="../../blog/post/mongodb-text-search" target="_blank"
    >Mongoose Text Search</a
  >&nbsp;at here.
</p>
<h3>How to use MongoDB text search with Mongoose</h3>
<p>First, install following npm module.</p>
<p>
  <code
    ><a
      href="https://www.npmjs.org/package/mongoose-text-search"
      target="_blank"
      >mongoose-text-search</a
    ></code
  >
</p>
<pre
  class="language-javascript"
><code>textSearch = require('mongoose-text-search')
</code></pre>
<p>set up your schema</p>
<pre class="language-javascript"><code>// give schema text search capabilities
yourMongooseSchema.plugin(textSearch);
// add a text index
yourMongooseSchema.index(
{
    Title: 'text'
});
</code></pre>
<p>Following is example how to use text search.</p>
<pre class="language-javascript"><code>
var option = {
        // list of schema property you do not want to include
        project: '-DealId -DealSiteId -Title'  
        // casts queries based on schema             
        , filter: { likes: { $gt: 1000000 }} 
        , limit: 10
        , language: 'spanish'
          , lean: true
    };

var keyWord = 'key word to search'
yourCollection.textSearch(keyWord , option, function (err, output)
{
}<br /><br />More about Mongoose with MongoDB text search, check <a href="https://www.npmjs.com/package/mongoose-text-search" target="_blank">mongoose-text-search</a>.
</code></pre>
<h3>Mongodb need to be 2.4 or higher</h3>
<h3>Other References</h3>
<ol>
  <li>
    <a
      href="https://blog.codecentric.de/en/2013/01/text-search-mongodb-stemming/"
      target="_blank"
      >Blog -MongoDB Text Search Explained</a
    >
  </li>
  <li>
    <a
      href="https://docs.mongodb.org/v2.4/tutorial/enable-text-search/"
      target="_blank"
      >Enable Text Search</a
    >
  </li>
  <li>
    <a href="https://docs.mongodb.org/manual/release-notes/3.0/" target="_blank"
      >MongoDB release note 3.0</a
    >
  </li>
  <li>
    <a href="https://docs.mongodb.org/manual/release-notes/3.2/" target="_blank"
      >MongoDB release note 3.2</a
    >
  </li>
  <li>
    <a
      href="https://docs.mongodb.org/manual/reference/operator/query/text/#examples"
      target="_blank"
      >$text</a
    >
  </li>
  <li>
    <a
      href="http://willowtreeapps.com/blog/text-searching-with-mongodb/"
      target="_blank"
      >Text Searching with MongoDB</a
    >
  </li>
</ol>
<h3>Other Search Engine</h3>
<p>Want to use other popular search engine?</p>
<ul>
  <li><a href="http://lucene.apache.org/solr/" target="_blank">Solr</a></li>
  <ul>
    <li>
      <a href="https://github.com/mausch/SolrNet" target="_blank">Solr.NET </a>
    </li>
  </ul>
  <li><a href="https://www.elastic.co/" target="_blank">elastic</a></li>
  <ul>
    <li>
      <a
        href="https://www.elastic.co/guide/en/elasticsearch/client/net-api/current/_elasticsearch_net.html"
        target="_blank"
        >Elasticsearch.NET</a
      >
    </li>
  </ul>
</ul>


How to Use MongoDB TextSearch by Mongoose


<p>Following example is export/import to your localhost's mongo database.</p>
<h2>Export Collection from Mongo Database</h2>
<pre class="language-javascript"><code>
Mongodb/bin&gt;mongoexport --db {your database} --collection {your collection} --out {your file name}.json
</code></pre>
<h2>Import Collection to Mongo Database</h2>
<pre class="language-javascript"><code>
Mongodb/bin&gt;mongoimport --db {your database} --collection {your collection} --file {your file name}.json<br /><br /></code></pre>
<h2
  style="
    font-family: 'Helvetica Neue', Helvetica, Arial, Helvetica, sans-serif;
    white-space: normal;
  "
>
  Import Collection to Mongo Database(remote)
</h2>
<pre class="language-javascript"><code>Note: collection needs to be before --db.
Mongodb/bin&gt;mongoimport --host {host server name} --port {server port number} --username {db username} --password {password} --collection {collection name} --db {database name} --file {your file name}.json</code></pre>
<h3>For detail information, reference following mongo document.</h3>
<ul>
  <li>
    <a
      href="http://docs.mongodb.org/v2.2/reference/mongoexport/"
      target="_blank"
      >mongoexport</a
    >
  </li>
  <li>
    <a
      href="http://docs.mongodb.org/manual/reference/program/mongoimport/"
      target="_blank"
      >mongoimport</a
    >
  </li>
</ul>


This blog shows few commands about how to export/import MongoDB Collections.

Few Commands about How to Export/Import MongoDB Collections


<h2>Just few mongo db script/command note</h2>
<p>&nbsp;</p>
<h3>Update All Fileds</h3>
<p><code> db.SomeMongoDBTable.update( </code></p>
<p><code>//</code><code>query </code></p>
<p><code>{ "TableFiledQuery" : true },</code></p>
<p><code>//update </code></p>
<p><code>{ $set : {'FiledWantToChange': false} }, </code></p>
<p><code>// options </code></p>
<p><code>{ </code></p>
<p><code>"multi" : true,</code><code>// update only one document </code></p>
<p>
  <code
    >"upsert" : false // insert a new document, if no existing document match
    the query
  </code>
</p>
<p><code>} );</code></p>
<h3>Between statement -search the Id greater than 5 and less than 10&nbsp;</h3>
<pre><code>
{ "Id" : {$gt: 5, $lt: 10}}
</code></pre>
<p>&nbsp;</p>
<h3>Like Statement -search Name field's contains %like% string&nbsp;</h3>
<pre><code>
{ "Name" : {$regex: 'like'}}
</code></pre>
<p>&nbsp;</p>
<h3>Not in statement - Key(string) is not "not this value"</h3>
<pre><code>
{ "Key" : { $ne : "not this value"}}
</code></pre>
<p>&nbsp;</p>
<h3>Check the database size</h3>
<pre><code>&gt; show dbs dataSize</code>&nbsp;</pre>
<h3>Not in, following example</h3>
<p>
  return data where Key field is not equal to victoria,los-angeles,las-vegas.
</p>
<pre><code>
{ "Key" : {$nin: ['victoria','los-angeles','las-vegas']}}<br /><br /></code></pre>
<h3>Drop database in command</h3>
<p>Simply just run following command</p>
<pre><code>use {your dabase}
b.dropDatabase();<br /><br /></code></pre>
<h3
  style="
    font-family: 'Helvetica Neue', Helvetica, Arial, Helvetica, sans-serif;
    white-space: normal;
  "
>
  Drop collection in command
</h3>
<p
  style="
    font-family: 'Helvetica Neue', Helvetica, Arial, Helvetica, sans-serif;
    white-space: normal;
  "
>
  Simply just run following command
</p>
<pre><code>db.{your collection name}.drop()</code></pre>
<pre><code>&nbsp;</code></pre>
<h3
  style="
    font-family: 'Helvetica Neue', Helvetica, Arial, Helvetica, sans-serif;
    white-space: normal;
  "
>
  Remote MongoLab
</h3>
<p
  style="
    font-family: 'Helvetica Neue', Helvetica, Arial, Helvetica, sans-serif;
    white-space: normal;
  "
>
  Simply just run following command, that it.
</p>
<pre><code>&gt;mongo {hostname}:{portnumber}/{database name} -u {user name} -p {password}</code></pre>
<pre><code>&nbsp;</code></pre>
<h3>Mongodb Aggregate example</h3>
<pre><code>
db.Collection.aggregate(
   [
   { 
	$match : {"State" : "CA"}
    },
     {
       $group:
         {
           _id: null, 
           total: { $sum: "$TotalAmout" }
         }
     }
   ]
)
</code></pre>
<p>Similar to</p>
<pre>
SELECT (TotalAmount) AS total
       FROM Collection
       GROUP BY TotalAmout
       HAVING State = 'CA'
</pre>
<h4>conclusion</h4>
<p>
  Mongo DB syntax is different from existing relational database like MS SQL
  SERVER, Oracle. It take time to get familiar with these. My next plan is write
  compare sql between existing relational database script syntax and compare
  with Mongo DB.
</p>
<h4>Reference</h4>
<p>http://cookbook.mongodb.org/patterns/date_range/</p>
<p>http://docs.mongodb.org/manual/reference/command/nav-diagnostic/</p>


Few Tips for MongoDB


<p>
  With mongodb's mongodump &amp; mongorestore command, you can achieve export
  and import data to your mongo database.
</p>
<p>1. Export Database</p>
<p>
  Go to your local mongo bin folder. Type mongodump --db {your database name}
</p>
<p>
  This command will export all your database as binary file under dump folder.
  When I have 200 MB, totall collection around 50,000. This command run like 2,3
  second in my Windows 8 (8GB memory) PC.
</p>
<p>&nbsp;</p>
<p>2. Restore you database to the remote connected database</p>
<p>
  Asume your remote mongo database have nothing, you just want to import
  everything you just export from local mongo datatabase. Run following command.
</p>
<p>
  mongorestore --db {your database} --host {server name} -- port {server port
  number} --username {your database user name} --password {your database user's
  password} dump/{your database name}
</p>


With mongodb's mongodump & mongorestore command, you can achieve export and import data to your mongo database.

Few Commands about Import/Export Mongo Database


<p>
  <span
    style="
      color: #e2e2e2;
      font-family: 'andale mono', 'lucida console', monospace;
      font-size: 20.4px;
      line-height: 30.6px;
      background-color: #202020;
    "
    >PM&gt; Install-Package CSharpMongo.dll</span
  >
</p>
<p>
  Start create my own nuget dll, since I have worked with MongoDB a little bit.
  So I'm trying to create useful library that I don't need to write code same
  code at my different solution. Unlike the original or old deployment,
  development, you'll chec-in your application's dependency dll. Nuget
  development is different! You don't need to check-in the dependency dlls, you
  will manage as package file which contains list of dependency dll of your
  current projects.&nbsp;
</p>
<p>
  So, when you build the solution of your visual studio, if you setup nuget
  correctly, visual studio will go to network to download the necessary dll to
  your local, by default should be inside the package folder. In additional, at
  the end of the build, these dll will copy to your bin folder.
</p>
<p>Following instructure is about how to manully deploy to nuget.</p>
<p>1. Register to get Nuget account</p>
<p>
  Anyway, this blog I try to write how to simple create your own nuget package.
  First you need to go to&nbsp;<a href="https://www.nuget.org/" target="_blank"
    >nuget.org</a
  >&nbsp;to register.&nbsp;
</p>
<p>2. Make sure your application is build and able to deploy to nuget</p>
<p>
  You have to make sure your application is build successfully, so when people
  get the dll by nuget won't break stuff. You should, think it as deploy to
  Production.
</p>
<p>3. Create and publish a package.</p>
<p>
  <a
    href="https://docs.nuget.org/create/creating-and-publishing-a-package"
    target="_blank"
    >See here for publish nuget package.</a
  >
</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>


Category MongoDB