Re: [sqlite] Where Clause

> BEGIN; > SELECT COUNT() FROM WHERE ; > if count == 0 > raise exception > else > UPDATE ... > COMMIT I have passed the query for count to sqlite3_exec () function. Return of count value is part of callback function or I need to use some other way to

[sqlite] AUTO: Oren Bar is out of the office - He is in vacation (returning 20/08/2013)

I am out of the office until 20/08/2013. I will be unavailable. Note: This is an automated response to your message "[sqlite] SQLITe space issue" sent on 09/08/2013 1:52:11. This is the only notification you will receive while this person is away.

Re: [sqlite] SQLITe space issue

On 8 Aug 2013, at 11:52pm, Inna Belakhova wrote: > We have a database that is 8GB and most of the data is in a RESOURCE > table that contains BLOB type. > > > > Is there a limit on how much data can be inserted into the table? Limits for things in

[sqlite] SQLITe space issue

Hi, We have a database that is 8GB and most of the data is in a RESOURCE table that contains BLOB type. Is there a limit on how much data can be inserted into the table? Is it possible to convert SQLITe to SQL database and transferring the BLOB data as well? Cheers, Inna

Re: [sqlite] Slow Query on large database Help

On Aug 8, 2013, at 3:40 PM, Christopher W. Steenwyk wrote: > This database is generated once, and then queried and interrogated multiple > times. So I am most concerned with read speed and not with writing or > updating. Ohohoho… in that case… I have some snake oil to sell

Re: [sqlite] Slow Query on large database Help

I just uploaded the output from sqlite3_analyze to dropbox. On Thu, Aug 8, 2013 at 9:40 AM, Christopher W. Steenwyk wrote: > Here is the data from stat1: > > "tbl", "idx", "stat" > "metrics", "metrics_idx", "68682102 2 2 2" > "metrics", "metrics_frame_idx", "68682102 2" >

Re: [sqlite] Slow Query on large database Help

Here is the data from stat1: "tbl", "idx", "stat" "metrics", "metrics_idx", "68682102 2 2 2" "metrics", "metrics_frame_idx", "68682102 2" "metrics", "sqlite_autoindex_mobileye_ldw_metrics_1", "68682102 230 1" "object_characteristics", "object_characteristics_idx", "1148344 164050 31899 1"

Re: [sqlite] How to "upgrade" a DB without write access to its file, or to the direction it's in?

On Wed, Aug 7, 2013 at 6:36 PM, Richard Hipp wrote: > On Wed, Aug 7, 2013 at 12:15 PM, Dominique Devienne >wrote: > > > On Wed, Aug 7, 2013 at 2:45 PM, Clemens Ladisch > > wrote: > > > > > Dominique Devienne wrote: > > > > We can of