I am generating web pages from an sqlite database. I would like to generate an ETag header so I need some handle on when the database has changed, either a last modified time or a revision number of the data.
Is there an easy way to get this out of SQLite? In this case the db is very simple so I can easily add a new column (or in fact use an existing column) but I wondered if there was a more general solution. Thanks, Chris.