Search code examples
databasesqlitepysqlite

Is their a unique signature value for the state of of an sqlite3 DB (or table)?

I was looking for some single value that tracked the writes to either the DB or an individual table in the DB.

I would like to say "This data was extracted at this time, from this DB, in this state"

I am not bothered about future updates recreating the data of the table, just information equivalent to a simple count of the number of writes would do.

This would allow me to record the same info when I did other extracts from the DB and so could check to ensure consistency.

Thanks in advance :-)

Solution

  • Use the database file's modified date and time from the file system.