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.
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
I administer an email server for a couple of domains and a few users. Incorrectly configured email servers result in a lot of my administration work. Due to improper configuration, far too many servers look like Spam servers. A little effort in setting up your server can make my life easier, and increase your chance… Continue reading Running an Email Server
The computer to which I had been synchronizing my Palm Tungsten E died a while ago. I explored the two options for connecting to my Ubuntu system using a USB cable. The fastest is to use a direct USB connection. However, I wanted to ensure I could synchronize over a network connection. I also configured… Continue reading Connecting a Palm via USB
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 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
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
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.
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
Now I have replaced my old firewall with OpenWRT, I needed to enhance the configuration of dnsmasq to support the network. The old Ubunutu based firewall was already running dnsmasq, as does the DNS server on the LAN. I run a mixed network with wired and wireless clients on separate address ranges. DHCP services are… Continue reading OpenWRT and Ubuntu dnmasq setup