Database Naming Conventions

Naming standards for database objects can simplify development. The names used for tables and columns are most visible. Using standard conventions for the other objects can clarify where they fit in the design. This article describes the conventions I use by default.

Code Optimization Rules

It is common for developers to worry about optimization while doing initial programming. Some write extremely complex code in the belief that it is optimized. Unfortunately, this code is often slower than it might otherwise be. Additionally, the compiler may be unable to optimize the code. I find optimization is rarely necessary and effective optimizations… Continue reading Code Optimization Rules

Analog with Report Magic and Logwrangler

I am now using Report Magic for Analog with my Analog installation.  My last attempt had failed miserably, but this time it went extremely well.  I found Logwrangler which does a lot of the work.  I encountered an incompatibility between Report Magic and an updated graphics library.  Once the patch was applied the program ran… Continue reading Analog with Report Magic and Logwrangler

Analog for Multiple Sites

Analog is a fast and flexible web log analysis tool.  Its configuration can consist of several files nested using include statements.  This allows common configuration items to be grouped in separate files.  The minimal site specific configuration items can be contained in small include files.  Similarly, time period specific include files allow for reports by… Continue reading Analog for Multiple Sites

Monitoring with Munin

Munin is a system monitoring program designed to capture and graph performance statistics with minimal configuration. It is significantly easier to configure than MRTG and has a wide variety of plugins.  The Ubuntu (Debian) installer will setup a reasonable configuration on installation.  It requires one server, and a client daemon on all monitored servers including… Continue reading Monitoring with Munin

Installing WordPress on Ubuntu

WordPress is available as a packaged application for Ubuntu.  However it requires a bit of post installation configuration. The installation will install the apache2 multi-user server if no server is installed. I modified the installation to run over top of an existing site.  The default installation creates directories under /var/www, which I move to /srv.

Setting up Windows

The following guide is intended to help install Windows on system in a secure manner.  The steps here are intended to limit the exposure of the system to malware during installation.  However, it does not guarantee that malware will not infect the system.  There are many known vectors used by malware, some of which are… Continue reading Setting up Windows