Are you maybe using WAL mode? Do you have any other files alongside your database like *.db-shm or *.db-wal?
If so, you can just cat all the files together and pipe through md5sum or such. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of lebron james [lebron.m...@gmail.com] Sent: Wednesday, October 17, 2012 4:51 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] SQLite flush on disk to calc db file hash,how? I have program which with some period insert row in sqlite database. I need calc hash sum of database file after each insert without close connection. I have some problem with that, after insert database file hash sum are same with they have before insert. Only after closing connection hash sum are changed. How i can solve this problem? platform are windows, and i dont have open transaction, just default opened sqlite db file and simple insert, if i do COMMIT after INSERT query i have exception "you dont have open transaction" _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
