MobileRead Forums - View Single Post

stsu · 04-06-2010, 12:18 PM

IMPORTANT!

Updated versions are available. See the first post of this thread.

zbi opens the database file zotero.sqlite in read-only mode, but I recently noticed that sqlite might write journal files to the file system even if the database is opened in read-only mode. Since SD cards have a limited number of writes, it can shorten the lifespan of the SD card. I am sorry for this bad behaviour.

In version 0.7_1 and later, the journal mode of sqlite is set to MEMORY, that is, the journal files are stored in memory and also the temp store is set to MEMORY, that is temporary files are stored in memory, hence the write access to the card would be minimal as long as I understand (but at the expence of database safety).

I tried to keep the write access to SD card as minimal as possible, and I hope that these new versions would achieve it. But I am not sure about the behaviour of sqlite. Any suggestion is welcome.

04-06-2010, 12:18 PM	#18
stsu Member Posts: 13 Karma: 24 Join Date: Jan 2010 Device: irex dr1000s	IMPORTANT! Updated versions are available. See the first post of this thread. zbi opens the database file zotero.sqlite in read-only mode, but I recently noticed that sqlite might write journal files to the file system even if the database is opened in read-only mode. Since SD cards have a limited number of writes, it can shorten the lifespan of the SD card. I am sorry for this bad behaviour. In version 0.7_1 and later, the journal mode of sqlite is set to MEMORY, that is, the journal files are stored in memory and also the temp store is set to MEMORY, that is temporary files are stored in memory, hence the write access to the card would be minimal as long as I understand (but at the expence of database safety). I tried to keep the write access to SD card as minimal as possible, and I hope that these new versions would achieve it. But I am not sure about the behaviour of sqlite. Any suggestion is welcome.