Umm, how about a "last modified at" file attribute on your db file?
-Boris -- +1.604.689.0322 DeepCove Labs Ltd. 4th floor 595 Howe Street Vancouver, Canada V6C 2T5 [EMAIL PROTECTED] CONFIDENTIALITY NOTICE This email is intended only for the persons named in the message header. Unless otherwise indicated, it contains information that is private and confidential. If you have received it in error, please notify the sender and delete the entire message including any attachments. Thank you. -----Original Message----- From: Chris Fletcher [mailto:[EMAIL PROTECTED] Sent: Monday, April 03, 2006 3:50 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] last modified time or version of sqlite database > <http://sqlite.org/capi3ref.html#sqlite3_total_changes> Thanks - but this seems to give the number of changes during the lifetime of a db session. With CGI the sessions will be short lived. On a new session I want to know when the db was last modified (or some other indication of changes). Regards, Chris.
smime.p7s
Description: S/MIME cryptographic signature