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…
Dynamically Bind Params in Prepared Statements with MySQLi
Prepared statements must be used in application development with databases. There are two main reasons: performance: parameterized queries with prepared statements reduces the database load, reusing access plans that were…