Install PostgreSQL 9.2 on Fedora 18/17, CentOS/RHEL/SL 6.4/5.9
This is guide, howto install PostgreSQL 9.2 (currently 9.2.1) database server on Fedora 18/17/16, CentOS/Red Hat (RHEL)/Scientific Linux...
Read More
Install phpMyAdmin 3.5.7 on Fedora 18/17, CentOS/RHEL 6.3/5.9
This is guide, howto install phpMyAdmin 3.5.7 with Nginx or Apache on Fedora 18/17/16/15/14, CentOS 6.3/6.2/6.1/6/5.9 and Red Hat (RHEL)...
Read More
PHP / PDO / SQLite3 Example
This is a PHP, PDO and SQLite3 example, which demonstrates the SQLite3 databse usage with PHP-PDO. The PHP / PDO / SQLite3 example code...
Read More
LEMP on Fedora 18/17, CentOS/Red Hat (RHEL) 6.4/5.9
LEMP (Linux, Nginx, MySQL, PHP) server is extremely powerful setup behind any website or web based service. This guide is collection of...
Read More
LAMP on Fedora 18/17, CentOS/Red Hat (RHEL) 6.4/5.9
LAMP (Linux, Apache, MySQL, PHP) server is very powerful server setup behind any website or web based service. This guide is collection of...
Read More
Install MySQL 5.5.31 on Fedora 18/17, CentOS/Red Hat (RHEL) 6.4/5.9
MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This...
Read More
PostgreSQL: Select a Random Number in a Range (Between Two Numbers)
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
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
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
nginx, PHP 5.3 and FastCGI on CentOS 5.5, Fedora 13, Red Hat RHEL 5.5/6
This is guide howto install nginx, PHP 5.3 and FastCGI webserver with MySQL and/or PostgreSQL and Memcache support on Fedora 12 and Fedora...
Read More
PostgreSQL: Partitioned Table vs Non Partitioned Table (Part 3)
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)
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)
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
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
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
