Re: [sqlite] Problem with porting Sqlite to Arm embedded platform

2013-08-16 Thread Girish Padharthi
Fellows, Could someone suggest a resolution for this issue, please? http://stackoverflow.com/questions/17880257/sqlite-database-fails-on-target-due-to-long-long-int-64-bits-data-type -Girish From: girish.padhar...@outlook.com To:

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?). OOI

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 d...@sqlite.org wrote: On Thu, Aug 15, 2013 at 3:39 PM, Gary Weaver garyswea...@gmail.com 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.

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 garyswea...@gmail.com 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

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

[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 is set

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 email

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 ibrahim.a...@googlemail.com 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 garyswea...@gmail.com 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.

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 ibrahim.a...@googlemail.com 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