Category Articles 
How To Create Data Queries in PostgreSQL By Using the Select Command
Viewed 14374 times since Mon, Dec 30, 2013
What is PostgreSQL?PostgreSQL is an open source database management system that utilized the SQL querying language. PostgreSQL, or simply "Postgres", is a very useful tool on a server because it can handle the data storage needs of websites and... Read More
How To Setup Ruby on Rails with Postgres
Viewed 11565 times since Mon, Dec 30, 2013
IntroductionPostgres (or PostgreSQL) is an open source database. Ruby on Rails is an open source web framework written in Ruby. Rails is database agnostic, meaning it can be used with a variety of different databases. By default it assumes that... Read More
How To Create, Remove, & Manage Tables in PostgreSQL on a Cloud Server
Viewed 3282 times since Mon, Dec 30, 2013
What is PostgreSQL?PostgreSQL is a database management system that uses the SQL querying language. It is a very stable and feature-rich database system that can be used to store the data from other applications on your server. In this article, we... Read More
How To Install and Use PostgreSQL on Ubuntu 12.04
Viewed 6217 times since Mon, Dec 30, 2013
Install PostgresBefore we install postgres, we should quick perform a quick update of the apt-get repository: apt-get updateOnce apt-get has updated go ahead and download Postgres and its helpful accompanying dependencies: sudo apt-get install... Read More
How To Install and Configure Django with Postgres, Nginx, and Gunicorn
Viewed 4253 times since Fri, Jan 3, 2014
For convenience, I've broken this tutorial into two parts. The first part (steps 1 - 6) covers installation only. If you are a more advanced Django user who just needs help getting things installed you can stop at step 6. If you already have... Read More
How To Set Up a Postfix Email Server with Dovecot: Dynamic Maildirs and LMTP
Viewed 3595 times since Mon, Dec 30, 2013
PrefaceThis tutorial is based on How To Set Up a Postfix E-Mail Server with Dovecot and picks up where the first part ended. Please go through that tutorial first. In this article, we will divorce mailboxes from system accounts using dovecot&rsquo... Read More