Re: [sqlite] Concurrent inserts -> DB corruption in travisci vm with sqlite 3.7.9

2013-08-16 Thread Yuriy Kaminskiy
Gary Weaver wrote: > On Aug 15, 2013, at 3:47 PM, ibrahim wrote: > >> On 15.08.2013 21:39, Gary Weaver wrote: >>> SQLite varies between file is encrypted/not a DB errors and database disk >>> image is malformed. It would seem consistent with SQLite not handling >>> concurrent processing in this

Re: [sqlite] Concurrent inserts -> DB corruption in travisci vm with sqlite 3.7.9

2013-08-16 Thread Simon Slavin
On 16 Aug 2013, at 5:03pm, Gary Weaver wrote: > Thanks to you and Richard for the links and info. Concurrency is not > outlandish to expect, especially when it works in OS X and just not in the > Ubuntu vm in Travis, but I now understand that these are expected problems. Worth noting that con

Re: [sqlite] Concurrent inserts -> DB corruption in travisci vm with sqlite 3.7.9

2013-08-16 Thread Gary Weaver
On Aug 15, 2013, at 3:47 PM, ibrahim wrote: > On 15.08.2013 21:39, Gary Weaver wrote: >> SQLite varies between file is encrypted/not a DB errors and database disk >> image is malformed. It would seem consistent with SQLite not handling >> concurrent processing in this particular environment or

Re: [sqlite] SQLite Input with validation and lookup

2013-08-16 Thread Kai Peters
Stephen, you might want to look at http://dabodev.com/ Among other DBs it does support Sqlite and is fully cross-platform Cheers, Kai On Thu, 15 Aug 2013 17:39 +0100 (BST), Stephen Hughes wrote: > Sorry if the following is a duplicate but I've just updated to the latest > version of my emai

[sqlite] Wasted work in method sqlite3_blob_open() and sqlite3Fts3EvalPhrasePoslist()

2013-08-16 Thread pchang9
Hi, The problem appears in latest amalgamation "sqlite-amalgamation-201308152240.zip". I have attached simple one-line patches that fixes it. In method sqlite3_blob_open(), the loop on line 72034 should break immediately after "zFault" is set to "foreign key". All the iterations after "zFault" i

Re: [sqlite] Concurrent inserts -> DB corruption in travisci vm with sqlite 3.7.9

2013-08-16 Thread ibrahim
On 15.08.2013 21:39, Gary Weaver wrote: SQLite varies between file is encrypted/not a DB errors and database disk image is malformed. It would seem consistent with SQLite not handling concurrent processing in this particular environment or with the version of SQLite since 3.7.7 is fine in OS X

Re: [sqlite] Concurrent inserts -> DB corruption in travisci vm with sqlite 3.7.9

2013-08-16 Thread Richard Hipp
On Fri, Aug 16, 2013 at 6:58 AM, Gary Weaver wrote: > > I'm going to stop on this for now, because it sounds like SQLite was never > intended to support concurrent writes to a file DB from what you said, so > there is no use trying to debug an use case that isn't supported. I am a > little surpri

Re: [sqlite] Concurrent inserts -> DB corruption in travisci vm with sqlite 3.7.9

2013-08-16 Thread Gary Weaver
On Thu, Aug 15, 2013 at 4:20 PM, Richard Hipp wrote: > On Thu, Aug 15, 2013 at 3:39 PM, Gary Weaver > wrote: > > > > > Is there anything that stands out as something that would keep 30 > > processes from being able to concurrently insert into the same tables? > > > > Yes. SQLite does not (and h

Re: [sqlite] SQLite Input with validation and lookup

2013-08-16 Thread Stephen Hughes
Thank you David for correctly pointing out:- > Perhaps the better question for you to be asking is what software > would best meet your needs in creating a form that will interface > with sqlite's db back end. That is precisely the question I should have asked (should I start a new thread?). OO