mariadb - pontikis.net

How To Store MySQL Result To Array From Bash

Post author:Christos Pontikis
Post published:July 31, 2020
Post category:Database Administration
Reading time:2 min(s) read

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…

Lion stretching

Debian 9 Stretch RC3 Dedicated Web Server Setup Step by Step. Time for PHP7 and MariaDB

Post author:Christos Pontikis
Post published:April 23, 2017
Post category:Linux Desktop
Reading time:16 min(s) read

Debian 9 (Stretch) release candidate 3 (RC3) is available since April 10th, 2017. Debian 9 RC3 is still a "testing" release (not recommended for production servers). Which is the release…

Blue and pink dolphins at work

How and When To Enable MySQL Logs

Post author:Christos Pontikis
Post published:October 21, 2013
Post category:Database Administration
Reading time:9 min(s) read

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…

Credits

Is it time to Remove MySQL in favor of MariaDB in Production Servers?

Post author:Christos Pontikis
Post published:April 1, 2013
Post category:Database Administration
Reading time:5 min(s) read

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…

Billiards

How to Use PHP Improved MySQLi extension (and Why You Should)

Post author:Christos Pontikis
Post published:March 29, 2013
Post category:Database Administration
Reading time:8 min(s) read

PHP supports MySQL using a PHP extension. Thousands or millions projects have been written worldwide using PHP and MySQL. PHP team announced plans to deprecate MySQL extension in mid 2011.…