Re: [sqlite] How to minimize fsync'ed writes to flash for storing periodically measured data?

Hi Stephen, > *First*, buy a bulk amount of cheap, inexpensive USB keys and start > throwing your data at the key instead of your OS's card. Don't see how that will change things: Once the SD card fails, data logging will fail too - same is true for the usb key. > *Second*, instead of writing

Re: [sqlite] How to minimize fsync'ed writes to flash for storing periodically measured data?

Hi Richard, > In WAL mode, with synchronous=NORMAL (the default), fsync() only happens on > a checkpoint operation. Whether or not checkpoint is "very seldom" depends > on a number of factors, but seems likely to be the case in your scenario. Thanks a lot for your answer. Just to make sure,

[sqlite] How to minimize fsync'ed writes to flash for storing periodically measured data?

Hi, I would like to use sqlite for storing temperature data acquired every 10s running on my raspberry pi. As my first SD card died within a week with this workload, I am looking for opportunities to reduce write operations triggered by fsyncs to flash. For me loosing 1h of data at a power

[sqlite] How is the page-cache filled?

Hi, I would like to create a version of sqlite, which includes a few changes to the way pages are loaded and written to disk. * Which version of the source should I use? The amalgamized source isn't really useful, however for all other source-archives its stated its not recommended using. *

[sqlite] Howto use max() function?

HI there! I have just migrated to my application from hsqldb to SQLite-2.8 using the jdbc-driver from christian werner. However I have a problem with the following statement which is used very oftern to increment indexes. I know this is not a cool way to archieve this, however I must be 100% fully