Technology – Page 13

MongoDB IDE
I’m using MongoDB for about 6 months. And some guys asked about an IDE. (Basically a GUI tool for MongoDB) At that time there was only one usable GUI Tool. And it is MongoVUE. It is also a painful one. So I gave it up. And now I’m used to MongoDB shell. And I can do everything in MongoDB shell.

But for Developers and QAs to get to know whether their applications are running properly, they need to check MongoDB instances. For them using MongoDB Shell is something painful.

MonjaDB

But recently from MongoDB Java Developer course, I got to know about MonjaDB. MonjaDB is a plugin to an Eclipse IDE. And it is a really cool IDE. This one is available on any platform where Eclipse is available.

http://marketplace.eclipse.org/content/monjadb#.UVrrrRxHJCY

http://www.jumperz.net/index.php?i=2&a=0&b=9

RoboMongo

This one I just saw one of my colleagues is going to try. This one is not a plugin. And this one also an awesome tool. But only available on Macs and Windows. RoboMongo is more into DBAs side. And it supports MongoDB shell as well. And RoboMongo is a combination of a set of products. And it supports Intellisense like thing for MongoDB commands

http://www.robomongo.org/

Enjoy MongoDB !!!

nn

Tags

nn
- MongoDB
- mongo
- MongoDB Shell
- MongoShell
- Mongo Shell
n

Indexes on Views

I tried to create an Index on View. Then SQL Server said I have to alter that index as a schema-bound view. Then I created a Schema Bound View.

USE AdventureWorks2012GO

CREATE VIEW [dbo].[vHR] WITH SCHEMABINDING 
AS 
    SELECT 
        BusinessEntityID AS A,
        NationalIDNumber AS B,
        LoginID AS C
    FROM HumanResources.EmployeeGO

Then I created Index on that View.

CREATE UNIQUE CLUSTERED INDEX UCI_vHR ON vHR(A,B)GO

Then after that, I altered index. And my index got disappeared suddenly.

ALTER VIEW [dbo].[vHR] WITH SCHEMABINDING 
AS 
    SELECT 
        BusinessEntityID AS A,
        NationalIDNumber AS B
    FROM HumanResources.EmployeeGO

Then I ran below query to confirm that index got disappeared forever.

SELECT * FROM sys.indexes WHERE name = 'UCI_vHR'

I got nothing as a result. As soon as I figured this out, I hope to write about this again.

Tags

SQL Server 2012

T-SQL

TSQL

SQL Server

Install MongoDB on Windows
Installing MongoDB on windows. OOps. What I’m going to post about is not how to install MongoDB on Windows. Because It is not a normal installation process which you have select path like that. So this is about how to run MongoDB service on Windows. That’s it.

n

n

One of my cousin’s friends has asked for this post, hence I’m posting this. But long time ago I posted about how to install MongoDB as windows service. It is bit different.

n

n

So you can find the way to install MongoDB on windows from official link also.

n

http://docs.mongodb.org/manual/tutorial/install-mongodb-on-windows/

n

n
1. First of all you have to download MongoDB binary which is suitable for your processor architecture. I mean 32bit or 64bit.
2. Then extract it to C: drive. You can select any drive or any folder. I post this for beginners, because its easy to use C: drive.
3. And then create a following folders in C: drive. You don’t need to worry about capital simple letters. ;)
4. Then open MongoDB folder and go to bin
5. After that you can see few exe files. Please run mongod.exe
If it disappears please follow instructions carefully again. If you can see a black window on screen you have done it perfectly, Now your MongoDB is working properly!
nn

Tags

nn
- MongoDB
- mongo
- MongoDB Install
n
MongoDB Sri Lanka User Group
Wow! It’s a great pleasure to hear that we have a MongoDB User Group in Sri Lanka. I just sent a request to join to MongoDB User Group page in facebook. I really worry about got so long time to join the community of MongoDB.

n

n

You can also join to Colombo MongoDB User Group from this link.

n

http://www.facebook.com/groups/490378190986291/?ref=ts&fref=ts

n

n

I really didn’t know there are much more people in Sri Lanka, who is interested in MongoDB. I hope to join community and enjoy MongODB!!!

nn

Tags

nn
- MongoDB
- mongo
n
Do you want a colorful terminal
After moving to Ubuntu, I was looking for a way to make my terminal colourful. Because I really don’t like mono colour environments. Then I was searching “Enable Colors in Terminal”. Then I found a very easy way to give colours to my odd terminal.
1. Take a terminal window. Press Ctrl + Alt + T (We are going to give colours to the terminal from the terminal.)
2. Then type below command. vi ~/.bashrc
3. Then you will have vi editor opened. Then Press ‘i’ to start inserting.
4. Find and remove # in front of below line or add it to that file. force_color_prompt=yes
5. Then press Esc.
6. Then type :wq
7. And close your terminal and take a new terminal.
Now you got colours!
nn

Tags

nn
- terminal
- Ubuntu
- linux
n
Install MongoDB on Ubuntu using deb file
WoW! This is the first video that I have created. Today, right now I uploaded it to YouTube and I hope to create few more videos also. It seems funny!

So these videos describe how to install MongoDB on Ubuntu or on any Debian using deb file(deb package). And you don’t need to use apt-get install command to do this. In this method, every configuration file creates on the system without any matter and you don’t need to create a user account for MongoDB also.

Go MonGO!

UPDATE: I had to remove the video :D

nn

Tags

nn
- MongoDB
- Youtube
- MongoDB Install
n
Login to a Linux box
After the first day of Linux training, I got IP, Username and Password for a Linux box. But I really didn’t know how to log in to a Linux box with Credentials. Then I asked from a few guys, unfortunately, they also didn’t know what is the way to log in to Linux box.

Then I asked the guy who was next to me. How to log in to this box, then he told you to have to use putty for this. That’s my first day of using putty. But I really didn’t know that I’m using SSH. I’m writing this blog post because there may be people who are like me don’t know how to log in to a Linux box. And Google here and there for it.
So first what you need to do is you have to download putty. For that you can Google ‘putty’ then you can download it. Here’s the link. http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

Then run it!

You will have a window like below. Enter the IP or hostname on the text box.

Then Click Open.

For the first time, they should be a long message with Yes, No Cancel Buttons. Please press “Yes”

Then Putty will ask for the user name. Type user name and press enter.

Then Putty prompts for a password. Please type password and press enter.

Here you go !!!! Now you have successfully logged in to your Linux box using putty, enjoy shell!!!
nn

Tags

nn
- ssh
- putty
- linux
n
Installing RedHat Enterprise Linux from USB Drive
Recently I downloaded Red Hat Enterprise Linux 6.0 to install on my home server. And I’m a person who hasn’t used Optical Drive for ages. On my laptop, even DVD Drive doesn’t work properly. So every time I use USB Drive (Pen Drive) to install any operating system because my server doesn’t have an optical drive. Although I call it a server it is just a machine without CD Rom and blah blah.

Then as usually, I wanted to make Red Hat ISO bootable. Then I used UNetBootin to make my USB drive bootable. But I got a mounting error in installation when I was going to format the hard drive. So it never happened with Ubuntu for me. Then I searched here and there to find a method to install RHEL. Then I found a link to iso2usb. It worked a bit far away from that place. But it just installed minimal Linux server without any GUI. There was no option for it on Installation Wizard. Installation Wizard was GUI one although.

The I used fedora live USB create. It didn’t work properly. Then I copied all the contents of DVD into my server machine and added a repo entry for yum to DVD packages. :)

nn

Tags

nn
- RedHat
- linux
- USB Drive
n
Juju
Did you know about JuJu?

Juju is a new solution for Developer’s to configure their development environments faster than it was. Developers don’t need to be an expert on each and every service and how to configure each and service. Juju has distilled knowledge on each and every product like MongoDB, Cassandra or Hadoop. Creating environments (Linux) become easier with juju.

Juju is still in development and not suitable for production use. But as I feel it is going to play a big role in the industry especially with applications like Hadoop. Most of the businesses are looking into the DevOps model. So juju helps DevOps as well.

Juju is another work from an African language like Ubuntu. It means magic. Juju is magic. Actually magic is going to happen! Enjoy JuJu!

nn

Tags

nn
- juju
- Ubuntu
- linux
- devops
n
Mac OS Virtual Machine
For a long time, I was suffering because I wanted to use Mac OS. But I didn’t have any apple computer to use it. Also, I didn’t try to install Mac OS to Virtual Machine. But after joining Pearson I saw few Apple machines daily. And my eager to use Mac OS got exponentially increased. Then I started to think about Mac OS Virtual Machine. I had downloaded a genuine Mac OS installation long ago. But it was not a good one to install Mac OS to Virtual. So then I found this article.

http://www.macbreaker.com/2012/07/mountain-lion-virtualbox.html

And I tried with its instruction in a little bit different way. I used Ubuntu 12.10 as a host operating system. My computer had a Core i7 processor with DH67CL motherboard. So I was able to successfully install and run Mac OS Mountain Lion as a Virtual Machine on Ubuntu 12.10 with Oracle VirtualBox.

nn

Tags

nn
- Virtual
- VirtualBox
- Ubuntu
- Apple
- Mac
n