On 30 Aug 2010, at 2:34pm, Pankaj Chawla wrote:

> Yes, I guess I am trying to figure out which poison to pick :-)
> So here is what I need:
> 
> 1. Lowest possible writes to the NAND.
> 2. Highest possible database reliability in situations of power
> outage/reboots
>    since the device is unmonitored.
> 3. Am ok with losing 2-5 minutes of data as long as 2 is not compromised.

Do not mess with any PRAGMAs or compilation options at all.
Do all your operations with a database held in :memory:

http://www.sqlite.org/inmemorydb.html

Every two minutes (background timer ?), update the database held in NAND, using 
one big transaction.

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

Reply via email to