PostgreSQL Basic Commands

PostgreSQL PostgreSQL, often simply Postgres, is an object-relational database management system with an emphasis on extensibility and standards compliance. This post is the collection of most commonly used PostgreSQL commands. Login to PostgreSQL psql -Upostgres Where postgres is PostgreSQL username. It will ask password of postgres user. Once you enter password it will enter to…

Read more...

MySQL tips: Back Up and Restore MySQL Database

Sometimes we have to take backup and restore our database. In this post I’m describing how to take backup from MySQL database and restore to Linux/Unix machine. If phpMyAdmin is installed to your system, you can take backup from web portal. If not installed you can take backup from command prompt. Here is MySQL command…

Read more...

Install and use MongoDB with Rails in Ubuntu

MongoDB is a scalable, high-performance, document-oriented schemaless database. In this post I describe how to install MongoDB in ubuntu 12.04 and how to use MongoDB with rails. Followings are the steps to install MongoDB 1. Add GPG Key sudo apt-key adv –keyserver keyserver.ubuntu.com –recv 7F0CEB10 2. Edit your source.list sudo gedit /etc/apt/sources.list and add this…

Read more...

Setting MySQL database to Rails Application

MySQL is an open-source relational database management system. In this post I’m going to explain to use MySQL database to rails project. Install MySQL database if you do not have installed MySQL databse to your system.When you create new rails project with following command, it will add SQLite gem to the Gemfile, which is for…

Read more...