Install Apache/PHP 5.3.10 on Fedora 16/15, CentOS/Red Hat (RHEL) 6.2/5.7

Updated by on Feb 5, 2012 in CentOS, Featured, Fedora, Linux, Most Popular, Programming, Red Hat (RHEL), Server Guides, Servers | 76 comments

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...

Read More

PostgreSQL: Select a Random Number in a Range (Between Two Numbers)

Updated by 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...

Read More

PostgreSQL Sleep Function pg_sleep – Postgres Delay Execution

Updated by 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...

Read More

Install PostgreSQL 8.4 Database Server on CentOS, Fedora, Red Hat

Updated by on Feb 8, 2011 in CentOS, Featured, Fedora, Linux, Red Hat (RHEL), Server Guides, Servers, SQL | 23 comments

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...

Read More

PostgreSQL: Partitioned Table vs Non Partitioned Table (Part 3)

Updated by 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...

Read More

PHP Script to Generate PostgreSQL Table Partitioning (Part 2)

Updated by 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...

Read More

Create PostgreSQL Table Partitioning (Part 1)

Updated by 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...

Read More

Partitioning PostgreSQL Tables – Handle Millions of Rows Efficiently

Updated by 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...

Read More

Postgresql (psql) .psqlrc tips and tricks

Updated by 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...

Read More
Bear