[sqlite] pragma temp_store_directory is deprecated, what is the alternative?

2015-08-14 Thread James K. Lowden
On Mon, 27 Jul 2015 20:35:30 +0100 Simon Slavin wrote: > On 27 Jul 2015, at 8:03pm, Zsb?n Ambrus wrote: > > > Does this work with the same environment variable name on both unix > > and windows? I'm asking because unix and windows programs each use > > different conventions for what environmen

[sqlite] SQLite database becomes corrupt on iOS

2015-08-14 Thread Rob Willett
Simon, Thanks very much for this information. Rob. > On 14 Aug 2015, at 17:38, Simon Slavin wrote: > > > On 14 Aug 2015, at 4:17pm, skywind mailing lists > wrote: > >> this is the problem. I could never reproduce it by myself and even my >> customers have normally no problems. But it happ

[sqlite] SQLite database becomes corrupt on iOS

2015-08-14 Thread Simon Slavin
On 14 Aug 2015, at 5:16pm, Random Coder wrote: > I've run into other issues > that lead me to believe the OS is caching file writes until the app > exits in some situations regardless of various sync calls, but I never > did have time to track down if I was just fooling myself, or if the OS > wa

[sqlite] SQLite database becomes corrupt on iOS

2015-08-14 Thread skywind mailing lists
Hi, this is the problem. I could never reproduce it by myself and even my customers have normally no problems. But it happens once a year or so to one of my customers. Still this is very annoying as it results in data loss. Regards, Hartwig > Am 14.08.2015 um 17:15 schrieb Simon Slavin : > >

[sqlite] SQLite database becomes corrupt on iOS

2015-08-14 Thread skywind mailing lists
Hi, I think that I can exclude for 99.99% that there are two SQLite version because I should get linker errors. Anyway, what is definitely guaranteed that these two versions know anything from each other and that they are working on the same database. Regards, Hartwig > Am 13.08.2015 um 21:42

[sqlite] SQLite database becomes corrupt on iOS

2015-08-14 Thread skywind mailing lists
Hi, I do not get any error message from SQLite. And the database only gets corrupted when the iDevice has to shut down due to battery issues. I have never had a customer complaining about a corrupt database during normal operation. Regards, Hartwig > Am 13.08.2015 um 21:04 schrieb Simon Slavin

[sqlite] SQLite database in a Windows CE6.0 mobile device

2015-08-14 Thread J Trahair
Hi I am trying to run a SQLite database in a CE6.0 device (Psion Omnii XT15). I have persuaded it to run the demo from sqlite-netFx35-binary-PocketPC-ARM-2008-1.0.97.0.zip, which creates a db (containing info on broccoli and onions) from testce.exe, but on running my VB.net app it produces an

[sqlite] SQLite database becomes corrupt on iOS

2015-08-14 Thread Simon Slavin
On 14 Aug 2015, at 4:17pm, skywind mailing lists wrote: > this is the problem. I could never reproduce it by myself and even my > customers have normally no problems. But it happens once a year or so to one > of my customers. > Still this is very annoying as it results in data loss. I have s

[sqlite] SQLite database becomes corrupt on iOS

2015-08-14 Thread Simon Slavin
On 14 Aug 2015, at 4:10pm, skywind mailing lists wrote: > I do not get any error message from SQLite. And the database only gets > corrupted when the iDevice has to shut down due to battery issues. I have > never had a customer complaining about a corrupt database during normal > operation.

[sqlite] SQLite database becomes corrupt on iOS

2015-08-14 Thread Rousselot, Richard A
Are all your customers on the latest version of iOS? Maybe you need to make your app only compatible with current versions that behave properly? What version of iOS and model is the customer that has the issue running? Regards, A fly on the wall... -Original Message- From: sqlite-use

[sqlite] Patch to add sqlite3_trace_v2

2015-08-14 Thread sqlite-mail
Hello ! After seem the question about "how to sync sqlite3 databases" and proposed the creation/extension of sqlite3_trace function to make it easy to log changes to the database I implemented what I'll call sqlite3_trace_v2 that has an extra parameter to indicate if we only want to log sql stat

[sqlite] SQLite database becomes corrupt on iOS

2015-08-14 Thread Richard Hipp
On 8/14/15, skywind mailing lists wrote: > I think that I can exclude for 99.99% that there are two SQLite version > because I should get linker errors. Sadly, no. But on the bright side, even if you do have two or more copies of SQLite linked into your binary, everything will still work fine a

[sqlite] SQLite database becomes corrupt on iOS

2015-08-14 Thread Random Coder
On Fri, Aug 14, 2015 at 8:38 AM, Simon Slavin wrote: > I have seen a problem like this only in one context, and it had nothing to do > with SQLite. When an iDevice's power starts running low, it sends out > notifications to all running Apps and expects their cooperation in shutting > down. An