I was asked to do something like this about seven years ago, and it turned out that the Access database was optional -- it was what the start-up company was using for their in-house data, but the web site didn't yet exist and there was no reason to specify windoze as the hosting platform. So, I eliminated the windoze requirement, convinced them to provide flatfile (TSV) dumps of their data, and stuffed the whole thing into MySQL on Linux with Apache.
Their web site uses CGI::FastTemplate as the templating engine with MySQL behind it. CGI::FastTemplate was chosen (by me) because the site was originally deployed in a shared web hosting environment and being relatively light it doesn't compete too much with other domains wanting their fair share of resources. Today the site is on its own server, but we're still using CGI::FastTemplate because it ain't broke.
If I had it to do over again, I might still use CGI::FastTemplate because the client company likes to pinch pennies by doing a lot of their own web site maintenance, and the steeper learning curve of the more powerful templating engines would probably knock them for a loop. This way, I keep a happy client. I'd never suggest that CGI::FastTemplate is the best solution for even a simple majority of applications, but the learning curve is relatively short and shallow, and in this case it's done exactly what's needed and everyone's happy.
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.
| & || & |
| < || < |
| > || > |
| [ || [ |
| ] || ] ||