On Tue, Apr 03, 2012 at 01:22:02AM +0100, Simon Slavin scratched on the wall: > On 3 Apr 2012, at 12:27am, Webdude <webd...@thewebdudes.com> wrote:
> > Does anyone know if SQLite stores additional unique internal > > information such as timestamps etc. that would affect this, and > > if so could these "additional to the data" variable features be > > disabled in any way? > > SQLite files do contain some metadata like row numbers and internal page > hashes, but nothing like timestamps unless the programmer generated them > in software. While there are no timestamps, SQLite does keep a number of counters and other meta-data in the file header page that are not directly under programmer control. This includes a "change counter" that gets incremeted with every write. http://www.sqlite.org/fileformat.html -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
