Jump to Content
Jump to Navigation

Archive for “November, 2007”

Another MySQL headache

Tuesday, November 27th, 2007

In http://www.dbmail.org/mantis/view.php?id=655, Mr. Maenaka writes:
MySQL’s automatic reconnection is unsafe because of the following reason.First, SET NAMES query is a required arbitration between server and client if both’s character encoding is different. This should be done at the time of connection open. (Of course you can issue SET NAMES between every query with the huge overhead though.) By […]


Two request monty for persistent services on non-persistent hosts

Wednesday, November 7th, 2007

A problem I’ve been thinking about for a long time was how to build a backend service for a stateless web frontend. All of the solutions I have seen involve building a daemon that lives on the server and holds the persistent data. Or, in the case of PHP, weird ass service side session cookie […]


Perl in Apache with mod_perlite

Tuesday, November 6th, 2007

Lately at work a few folks have been batting around possible solutions to the perceived problem of how hard it is to run Perl code from Apache. Of course there are very good solutions, mod_cgi, mod_fastcgi, and best of all mod_perl. But there are very good reasons why web hosts shy away from CGI, and […]


SSL Key Management App

Friday, November 2nd, 2007

The crux of my SSL management headache is that I have a lot of domains, but only four public IP addresses. I bet that most home-operated sites are like that. I also have a number of different applications running — HTTPS, SMTPS, and IMAPS in particular. For each HTTPS domain, I need to have an […]