This website runs primarily out of a database. The main pages (Catalog, Photo Viewer, Exhibits, and Comments) are all generated using Active Server Pages, Microsoft's cgi application. Of the 24 pages here, only ten of them are regular html pages in the Technical subdirectory. I used Visual Basic Script (VBS) to program the pages.
*Note that the number of .jpg files indexed includes the "b", "m", "s" and "t" versions of a photograph, so it is about 3 times larger than the number of photos in the database.
Here is a diagram of the database:
The Dirs table contains the list of all photo directories, and what is in them. The Photo table, the main table in the database, keeps all info about each particular photograph. Most fields in this table are not currently used, but can be if I want to fill them (or when I get a camera that records it automatically). The files table is used to keep file information about each .jpg file, particularly the size. The ratings table stored user comments, and the clients table is used to keep track of privacy, so only those who log in will see their own photos.