-
Install WordPress 3.0.1 on Fedora 13, CentOS 5.5, Red Hat (RHEL) 5.5/6
02 September 2010 1:06 PM | 2 Comments -
PHP 1st, 2nd, 3rd, 4th, 5th, 6th – PHP Add Ordinal Number Suffix
24 August 2010 3:46 PM | No Comments -
YUM Downgrade Packages on Fedora, CentOS, Red Hat (RHEL)
23 August 2010 6:56 PM | No Comments -
LAMP on Fedora 13, CentOS/Red Hat (RHEL) 5.5/6 – (Linux, Apache, MySQL, PHP)
20 August 2010 3:21 PM | 3 Comments - Install Apache (httpd) and PHP 5.3.3 on Fedora 13, CentOS/RHEL 5.5/6
17 August 2010 3:54 PM | 1 Comment -
Fedora 13 ATI Catalyst (fglrx) 10.7 Drivers Install/Uninstall
09 August 2010 4:46 PM | 10 Comments -
Android SDK and Eclipse ADT on Fedora 13, CentOS 5.5, RHEL 5.5/6
06 August 2010 10:37 AM | 23 Comments -
Eclipse 3.6 Install PDT, JavaScript, CDT, Ruby, MarketPlace Plugins
03 August 2010 3:57 PM | No Comments
- Install WordPress 3.0.1 on Fedora 13, CentOS 5.5, Red Hat (RHEL) 5.5/6
02 September 2010 1:06 PM | 2 Comments - LAMP on Fedora 13, CentOS/Red Hat (RHEL) 5.5/6 – (Linux, Apache, MySQL, PHP)
20 August 2010 3:21 PM | 3 Comments - Fedora 13 ATI Catalyst (fglrx) 10.7 Drivers Install/Uninstall
09 August 2010 4:46 PM | 10 Comments - Android SDK and Eclipse ADT on Fedora 13, CentOS 5.5, RHEL 5.5/6
06 August 2010 10:37 AM | 23 Comments -
Install Firefox 4 (beta 4) on Fedora 13 and Fedora 12 – Screenshots
30 July 2010 11:42 AM | 2 Comments - Install MySQL 5.1 (5.1.50) on Fedora 13, CentOS 5.5, Red Hat (RHEL) 5.5
30 July 2010 9:54 AM | 6 Comments - Install Sun/Oracle Java JDK/JRE 6u21 on Fedora 13/CentOS 5.5/RHEL 5.5/6
29 July 2010 7:58 AM | 13 Comments - Install Eclipse SDK 3.6 (Helios) on Fedora 13, CentOS 5.5, RHEL 5.5/6
28 July 2010 10:48 AM | 1 Comment
- Android SDK and Eclipse ADT on Fedora 13, CentOS 5.5, RHEL 5.5/6
06 August 2010 10:37 AM | 23 Comments - Install Sun/Oracle Java JDK/JRE 6u21 on Fedora 13/CentOS 5.5/RHEL 5.5/6
29 July 2010 7:58 AM | 13 Comments -
Install Adobe Flash Player 10.1 on Fedora 13, CentOS 5.5, Red Hat (RHEL) 5.5
11 March 2010 11:51 AM | 29 Comments -
CentOS 5.5 Netinstall – Network Installation
08 March 2010 3:41 PM | 5 Comments - Install Mozilla Firefox 3.6 (3.6.8) on Fedora Linux
21 February 2010 3:00 PM | 5 Comments - Install Google Chrome with YUM on Fedora 13, Red Hat (RHEL) 6
20 February 2010 9:03 PM | 25 Comments - Install OpenOffice.org 3.2.1/3.3.0 on Fedora 13, CentOS/Red Hat (RHEL) 5.5
18 February 2010 2:37 PM | 32 Comments - Install VirtualBox 3.2.8 on Fedora 13, CentOS 5.5, Red Hat (RHEL) 5.5/6
18 February 2010 11:46 AM | 15 Comments
-
SQL Archive
Install Apache (httpd) and PHP 5.3.3 on Fedora 13, CentOS/RHEL 5.5/6
Posted on August 17, 2010 | 1 CommentThis guide shows howto install Apache HTTP Server (httpd) with PHP 5.3.3 and following modules: PEAR PDO MySQL PostgreSQL Memcache GD XML MBString MCrypt on Fedora 13/12/11/10/9/8/7/6, CentOS 5.4/5.5 and Red Hat (RHEL) 5.4/5.5/6 systems. Install Apache HTTP Server (httpd) and PHP 5.3.3 1. Change...
PostgreSQL: Select a Random Number in a Range (Between Two Numbers)
Posted on April 22, 2010 | No CommentsThis 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 job with PostgreSQL own random() function, which returns random value between 0-1. Following example selects 5 random values...PostgreSQL Sleep Function pg_sleep – Postgres Delay Execution
Posted on April 13, 2010 | No CommentsOne day, I was looking for PostgreSQL database function, which could delay the execution of queries. At first I thought that I will do one myself, because I do not remember ever seen this kind function. But then I found pg_sleep Postgres function which directly...Howto Install PostgreSQL 8.4 Database Server on CentOS, Fedora, Red Hat
Posted on January 21, 2010 | 16 CommentsThis is quick guide howto install PostgreSQL 8.4 (current stable 8.4.4) database server on CentOS, Fedora and Red Hat. Fedora 12, Fedora 13, CentOS 5.5 and Red Hat (RHEL) 5.5 has PostgreSQL 8.4 database server as default so extra repositories is not needed. Personally, I...Performance testing between partitioned and non partitioned PostgreSQL tables (Part 3)
Posted on December 11, 2009 | 9 CommentsThis article compares the speed and performance of queries between partitioned and non partitioned PostgreSQL tables. However, it is important to remember that the PostgreSQL tables partitioning has also another benefits, than the better performance on queries. More information about other benefits from the first...PHP script to generate SQL commands for PostgreSQL table partitioning (Part 2)
Posted on December 3, 2009 | 1 CommentAs Part 1 (Howto create PostgreSQL table partitioning) shows, making of PostgreSQL partitioning needs a lot of SQL commands. So this Part 2 explains how SQL commands for PostgreSQL partitioning can be made with a simple PHP script. This example script make SQL for child...Howto create PostgreSQL table partitioning (Part 1)
Posted on November 27, 2009 | No CommentsPostgreSQL supports partitioning via table inheritance. So the partitioning is made in such a way that every child table inherits single parent table. Parent table is empty and it exists just to describe the whole data set. PostgreSQL partitioning can be implemented in range partitioning...Partitioning large PostgreSQL tables and handle millions of rows efficiently and quickly
Posted on November 27, 2009 | No CommentsPostgreSQL table partitioning means splitting one large database table into smaller logical pieces. PostgreSQL table partitioning will be worthwhile only when a table would be very large. Here are a few benefits of what can be achieved with partitioning: Large tables query performance can be...Postgresql (psql) .psqlrc tips and tricks
Posted on November 2, 2009 | No CommentsPsql is a good tool for the PostgreSQL database management and use. Psql client functioning can easily be improved by adding a few lines ~/.psqlrc file. Set all null fields to NULL: \pset null 'NULL' After this, the query results look like this: select 'test'...
