Near the bottom of http://sqlite.org/pragma.html you'll find:
"PRAGMA [database.]user_version;
PRAGMA [database.]user_version = integer ;
The pragmas [...] user_version are used to set or get the [...]
user-version, [which is a] 32-bit signed integers stored in the database
header. [...] The user-version is not used internally by SQLite. It may be
used by applications for any purpose."
A quick python session:
import apsw
con=apsw.Connection("aaa")
con=apsw.Connection("temp")
con=apsw.Connection("temp")
csr=con.cursor()
csr.execute("PRAGMA user_version").next()
(0,)
csr.execute("PRAGMA user_version=0604010013")
csr.execute("PRAGMA user_version").next()
(604010013,)
csr.execute("PRAGMA user_version=0604010015")
csr.execute("PRAGMA user_version").next()
(604010015,)
HTH
Martin
----- Original Message -----
From: "Chris Fletcher" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Monday, April 03, 2006 11:49 PM
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.
