If Not True Then False

Currently Browsing Tag: SQL

Install Apache/PHP 7.1.0 on Fedora 25/24, CentOS/RHEL 7.3/6.8

This guide shows howto install Apache HTTP Server (httpd) with PHP 7.1.0 and following modules on Fedora 25/24/23, CentOS 7.3/6.8 and Red Hat (RHEL) 7.3/6.8 systems. OPcache (php-opcache) – The Zend OPcache provides faster PHP...

Install phpMyAdmin 4.3.10 on Fedora 21/20, CentOS/RHEL 6.6/5.11

This is guide, howto install phpMyAdmin 4.3.10 with Nginx or Apache on Fedora 21/20/19, CentOS 7/6.6/5.11 and Red Hat (RHEL) 7/6.6/5.11 servers. phpMyAdmin needs web server with PHP and MySQL database. This guide uses Apache web server...

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 ~/.psqlrc file. Set all null fields to NULL: \pset null 'NULL' After this, the query results look like...

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 important to remember that the PostgreSQL tables partitioning has also another benefits, than the better...

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 explains how SQL commands for PostgreSQL partitioning can be made with a simple PHP script. This...

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 parent table. Parent table is empty and it exists just to describe the whole data set. PostgreSQL...

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 worthwhile only when a table would be very large. Here are a few benefits of what can be achieved...

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 myself, because I do not remember ever seen this kind function. But then I found pg_sleep Postgres...