AWS

Mongo Monitoring Service to ensure uptime of MongoDB

Mongo Monitoring Service(MMS) is a service that ensures that the MongoDB is up and running and can alert us when the service is stopped/restarted.It can be run on an on-premise architecture or in the cloud like AWS. Use Case We have multiple servers running MongoDB service and they are present in different environments as Production,...

by Ankit Giri
Tag: Database
30-Jun-2015

Grails

Adding field to hasMany, got MySql error ??

It's a common practice to add fields to Grails domain's hasMany block while in database a foreign key relationship is maintained for every such entry. In other words, for each foreign key, we have a column in parent table (or domain) and a reference column in other table. I was adding a field into hasMany block recently when I got this...

by Ankit Agrawal
Tag: Database
25-May-2015

Automation Testing

Connect to PostgreSQL using JavaScript

One of the best practices of Automation testing is to leave the system from the state where you started your test from. While doing functional testing for an angularjs application using Protractor and Cucumber (BDD framework), there was a need to clean up whatever data was being generated in the Data setup (generally the Given) of the...

by Anuj Verma
Tag: Database
20-May-2015

AWS

Building MySql Database Test Plan Using Jmeter

In this blog we will setup the jmeter and we will see how to create a simple test plan to test the database server.We will use MySql database server for our test purpose or you can use any-other database. Setup requirement Download the latest jmeter from here and untar jmeter in you home directory. Download JDBC driver is...

by Prashant Sharma
Tag: Database
23-Apr-2015

Big Data

Consistent Hashing? What the heck is that…..

Hashing is one of the main concepts that we are introduced to as we start off as a basic programmer. Be it 'data structures' or simple ‘object’ notion - hashing has a role to play everywhere. But when it comes to Big Data - like every thing else, the hashing mechanism is also exposed to some challenges which we generally don’t...

by Surendra Pratap Singh
Tag: Database
27-Feb-2015

Node.js

High performance find query using lean() in mongoose

Lets start with a basic find query in mongoose and observe its execution time. [js] Event.find({'schedule.closing': {'$gte': +new Date()}}, {}, {limit:20, skip:0} ).exec(function (err, events){ ........ ........ } ); [/js] In my last project on Nodejs, I have used the above query to fetch the events...

by Sakshi Tyagi
Tag: Database
13-Feb-2015

Technology

MySQL to MongoDB Migration

MySQL and MongoDB are a very popular open-source databases these days. Through this blog, I wanted to share a use case of migrating MySQL database to MongoDB database and perhaps want to share few lessons during the migration process which would be helpful. There are three steps to the migration process: Suppose you have a user...

by Deepak Kumar Mittal
Tag: Database
29-Jan-2015

Technology

A level ahead with text search in mongoDb

In our previous post, we saw how simply we could use the free text search feature from MongoDB. In continuation to that, in this post we would be looking at how can we create multiple text indexes and understand how actually the things work. Document Scoring MongoDB assigns a score to each of the document that contains the search term...

by Sakshi Tyagi
Tag: Database
11-Jul-2014

Technology

Free text search in MongoDb

MongoDb introduced free text search beta in its v2.4 but it was in experimental phase. In v.2.6, MongoDb has finally made its free text search (the most requested feature) production ready. In this post, we will have a look at how can we use this pretty useful feature that MongoDb offers us. To enable Free text search, Mongodb...

by Sakshi Tyagi
Tag: Database
30-Jun-2014

Node.js

Getting started with Mongoose !!

Mongoose is a Node.js package that gives you an interface to play with mongo database. Mongoose has all sets of methods that help you to connect and access data stored in database. It translates data from database in javaScript object which you can provide to your application. We will move step by step to know how it works. 1....

by ajay.mishra
Tag: Database
07-Apr-2014

Grails

PostgreSQL with Grails

Currently in my Grails project I am using PostgreSQL database so I thought to share my knowledge with everyone. I am using it on Linux operating system. I am mentioning all the steps that I followed to integrate PostgreSQL with Grails . Step 1: Install PostgreSQL on your system To install postgreSql [java] sudo apt-get install...

by Gunpreet
Tag: Database
05-Sep-2012

Technology

Removing/replacing special character from database.

Recently in one of my project i faced a problem that database was having special character, which is shown as space on the User Interface. So as to solve this issue i found a very simple solution which consists of following steps: 1. First, you just need to identify which type special character to be removed/replaced like in my case...

by Anuj Aneja
Tag: Database
11-Jun-2012