How To Store MySQL Result To Array From Bash
Every programming language offers drivers or extensions to query MySQL and fetch the result. In other words to store MySQL result to array. Sometimes you need to do the same…
Update Postgres Major Version in Debian Jessie
Postgresql update is not a trivial task. According to PostgreSQL Versioning policy: A major release is numbered by increasing either the first or second part of the version number, e.g.…
How to Install PostgreSQL 9.3 on Debian 7 Wheezy
While MySQL considered as "The world's most popular open source database", PostgreSQL rightly considered as "the world's most advanced open source database". PostgreSQL architecture is based on CLUSTERS (a group…
How and When To Enable MySQL Logs
If you are a web developer, you need to refer to various log files, in order to debug your application or improve its performance. Logs is the best place to…
Is it time to Remove MySQL in favor of MariaDB in Production Servers?
MariaDB is a fork of MySQL, which is community maintained under the GPL v2 license. All code in MariaDB is open source. MariaDB is a binary drop in replacement for…