For last decade data breaches and data losses of Social Security numbers, credit card numbers, or one of a slew of other pieces of private information, have landed businesses on the front page of major newspapers, and in some instances with legal liability.
I knew when I had an opportunity to work an application which handled sensitive information, that it had to be done with the protection of this information as the number one priority.
Continue reading
Recently I was working on a car maintenance database. The database stores, among other things, odometer reading, miles per fill up, number of gallons per fill up, and cost per gallon. One of the missing pieces of information I wanted to report on is the miles per gallon I was achieving. While this is trivial to insert, I didn’t want to modify the client which was already deployed and running. Since the data to determine this value was already present, I turned to database triggers to help me record this value.
Wikipedia describes “A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database.”
In our case, the procedural code we want to execute is the computation of our miles per gallon, and the event we are responding to is an insert into our table. In this article I will outline how to create these triggers in both MySQL and PostgreSQL.
Continue reading
Recently we looked at adding a sidebar to twentyeleven via a child theme. While adding functionality is likely where you will start in your theme customization, there will likely come a point that you will want to remove some specific functionality as well.
One of the most eye catching features of twentyeleven are it’s header images, but if you really want to make the theme your own, you may want to remove the stock header images in favor of your own. Today we will do just that as we continue to explore customizing twentyeleven via a child theme.
Continue reading