Storing Data in a PHP Project

October 15, 2025 | Comment

Over the last year I have been reevaluating how and were I store the data for my projects. Traditionally I have added a new database in MySQL for each but I thought that was a bit overkill for some of the smaller, single user, projects that I was working on.

There are several options for storing your data, but each comes with its own trade-offs in setup time, performance, and scalability. Here I look at the ones I have used in my prejects — flat files, SQLite, and MySQL — and see where each one shines (and where … Read the rest

Automatically Restarting Unresponsive MySQL Service

October 29, 2023 | Comment

This blog and others that I run are all hosted on a cloud server with MySQL installed locally. Occasionally MySQL becomes unresponsive and I have to login to the server to kick it back into life by restarting msqld.

The most likely reason for MySQL becoming unresponsive is lack of resources so the best solution would be to increase the size of the server – however, that requires money that I don’t want to spend. Therefore, the next best option was to write a script to detect when MySQL was unavailable. Enter mysqladmin.

mysqladmin — A MySQL Server Administration Program

… Read the rest

The Evolution of Databases

January 10, 2014 | 1 comment

iStock_000016066249XLarge One of the beauties of a long career is that you get to see how things in your sector evolve over time. Being in IT is no different other than the phenomenal rate of change.

Nowhere is this more evident than in databases. When I started out in the late eighties I was a COBOL programmer working on hierarchical databases and specifically IDMSX on ICL’s VME platform. These databases worked on the basis of linked lists and you had to “walk” through a whole chain in order to get to the record you wanted.

Hierarchical databases were straightforward to learn … Read the rest

Documenting MySQL Tables in MediaWiki

March 11, 2013 | Comment

The last few companies that I have worked for we have setup an internal wiki that everyone uses to hold information about all aspects of the business including, of course, the technical team. We use MediaWiki for this mainly because it is easy to setup and is also familiar to users through Wikipedia.

One area that we try and document is the database structure. Having this on hand and searchable in the wiki allows new employees to quickly get to grips with it and makes us all more productive.

The issue is that creating the MediaWiki tables by hand is … Read the rest