The last article in my
Web caching series published by
InformIT.com details the
database integration methods. As most SQL databases don't give you record modification timestamps, you have to implement them yourself. In this article, you'll see how you can use SQL triggers to implement
table-level,
record-level and
join-level timestamps that can be used to set the last-modified date on an HTTP response.