Well, if 'Apache-Mysql-Auth' won't fit your needs, you definitely have to read the Eagle, 'Writing Apache Modules with Perl', O'Reilly.
It contains EYEWTK about perl module for apache.