Check when SQLite database / tables were updated (PHP)

Question

Is there any way to check when the latest SQLite db update?
Alternatively, is there a way to do this for a specific table?

Since SQLite is a file db, I think I can see the date in the file, but I'm not sure I can rely on this.

+2

Varariant Nov 01 '11 at 16:02

2 answers

James · Answer 1 · 2012-05-10T15:48:45+0000

I know this is an old post, but if anyone else reads this, see this post:

Yoshi · Answer 2 · 2013-07-03T14:24:03+0000

I believe this can be achieved by SQLite TRIGGERS