WEB SITE DESIGN & HOSTING -- DATABASES
In any situation where your site will include collections of similar items, which will be presented in the same way on the site, one or more databases may be the best approach. This applies to collections of images, information about customers or clients, or any case where similarly formatted pages are presented with different data content.
Placing your repetitive data into a database on the server allows the server, at the time of serving a page, to select items from the data for presentation according to criteria determined by the site user. For the Web designer, such presentation can often be accomplished with a single page design.
A very good example of the database approach is shown by the display of pictures on this site. There is a database for all the pictures to be displayed. When the site user chooses a category from the menu at the top of the pictures page, the server refreshes the page by selecting all the pictures in the database having the chosen category. This then displays the thumbnails for all the selected pictures at the bottom of the page. When the user clicks on one of the thumbnails, the page, without reloading itself, displays the larger version of the picture in the center area of the page.
The database also allows you to easily add to or change the content to be displayed. A private login lets you access your database for updating or addition of items. When you make changes to the database this way, the pages that display from that database will immediately show your updates the next time they are accessed by your users.
The image below shows the database entry page for the picture data on this site.
If you are interested in a Web design project, please contact me.