Hi Jay,

thanks for your help,


/  >  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
 <http://www.sqlite.org/fileformat.html>

But if data was added exactly in the same way/order shouldn't the counters all 
count to the same end result if the process was repeated at a later time on a 
another machine?


Thanks again for your time,

David


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to