-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 23/01/12 22:43, David Henry wrote: > I am working without an operating system so there are no other agents > trying to steal data. Bearing that in mind, is it still necessary to > actually write zero data to the sectors allocated? Is SQLite expecting > it?
You should ensure that your operating system still reports free space correctly to all other file system users (ie the space is actually allocated). For example on traditional Unix file systems you can open a file, seek to 1TB and write one byte. The file system will not report 1TB less free space. If you read in the space you'll get zeroes back. As you write it will come out of free space. But if the disk only had 10MB free you'll suddenly find writes failing even though you "allocated" the space. Trying to recover will get hairy depending on what writes will succeed or fail as the mess is cleaned up. You could (in theory, maybe not in practise) get the database into a state where SQLite can't put it back into a clean state by applying journals. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk8eZhEACgkQmOOfHg372QQBoQCfS7bsoSk+M8Irqv6ZTAElm3BC u0wAnjL8w6OblWe/dTI67PhIfsgxqD1n =DoRG -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users