SQL

This guide shows howto install Apache HTTP Server (httpd) with PHP 5.3.10 and following modules on Fedora 16/15/14/13/12, CentOS...

Updated by JR on May 26, 2010 in SQL | 0 comments

This is quick tip howto select a random number in a range. Example random number between 1-100 (>= 1 and < 100). This is actually very easy...

Updated by JR on May 26, 2010 in SQL | 0 comments

One day, I was looking for PostgreSQL database function, which could delay the execution of queries. At first I thought that I will do one...

This is quick guide howto install PostgreSQL 8.4 (current stable 8.4.7) database server on CentOS, Fedora and Red Hat. Fedora 14, Fedora...

Updated by JR on Sep 7, 2010 in SQL | 9 comments

This article compares the speed and performance of queries between partitioned and non partitioned PostgreSQL tables. However, it is...

Updated by JR on Sep 7, 2010 in Programming, SQL | 1 comment

As Part 1 (Howto create PostgreSQL table partitioning) shows, making of PostgreSQL partitioning needs a lot of SQL commands. So this Part 2...

Updated by JR on Sep 7, 2010 in SQL | 3 comments

PostgreSQL supports partitioning via table inheritance. So the partitioning is made in such a way that every child table inherits single...

Updated by JR on Sep 7, 2010 in SQL | 0 comments

PostgreSQL table partitioning means splitting one large database table into smaller logical pieces. PostgreSQL table partitioning will be...

Updated by JR on Sep 30, 2010 in Featured, SQL | 0 comments

Psql is a good tool for the PostgreSQL database management and use. Psql client functioning can easily be improved by adding a few lines...