PhotoSite is an extensible perl site which heavily uses a mysql backend. The author writes "Something I threw together for myself that is mainly geared around posting photos, but I decided to make it modular so that it could easily be expanded." It retrieves all of its content from a mysql database so some mysql knowledge will be required.