Re: [sqlite] problems with shared cache?

2009-03-24 Thread Damien Elmes
Sorry, my application's files are called decks, and I unwittingly used the wrong terminology. Any ideas about the problem? On Sat, Mar 21, 2009 at 2:27 AM, Griggs, Donald wrote: > >> However, when I ask the user to send me their deck, I find that: >>

Re: [sqlite] speeding up row by row lookup in a large db

2009-03-24 Thread Stefan Evert
>> Just wanted to say publicly that DBD::SQLite is the greatest thing >> since, well, SQLite. Thanks for making our lives easy. > > +1 $count++; from me, too. We talk so much about speed and versions only because we use DBD::SQLite so heavily. BTW, I've switched to the amalgamation package,

Re: [sqlite] Step Query

2009-03-24 Thread vinod1
Hi, I am new to sqlite and C. I have not been able to write a code which would read row by row using sqlite3_step. Could anybody guide me please. Dan Kennedy-4 wrote: > > On Tue, 2007-06-19 at 10:58 +0530, anand chugh wrote: >> Hi >> >> I am having code like this: >> >>rc =

Re: [sqlite] problems with shared cache?

2009-03-24 Thread Griggs, Donald
-Original Message- On Sat, Mar 21, 2009 at 2:27 AM, Griggs, Donald wrote: > >> However, when I ask the user to send me their deck, I find that: >> >> sqlite> pragma integrity_check; >> integrity_check >> --- >> ok

Re: [sqlite] problems with shared cache?

2009-03-24 Thread Jim Wilcoxson
Not sure if it will make a difference, but in your trigger stuff you explicitly coded null for the primary key value. Have you tried changing that so that you don't specify the primary key field at all? I can't remember from the previous post, but I think it was (or should be) set up as

[sqlite] question about shared cache

2009-03-24 Thread Dave Toll
Hello list I have been trying to understand how shared cache works under the covers, and how a custom VFS should behave when shared cache is enabled - can anyone confirm this assumption: Journal file handles (opened with SQLITE_OPEN_EXCLUSIVE) are shared between database connections opened

[sqlite] Accent Insensitive search

2009-03-24 Thread aditya siram
Hi all, Is there a way to do an accent/diacritic insensitive search in sqlite? For example I want to a query to find " `a blanc " with the search term "a blanc". Thanks ... -deech ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] question about shared cache

2009-03-24 Thread Dan
On Mar 25, 2009, at 12:09 AM, Dave Toll wrote: > Hello list > > > > I have been trying to understand how shared cache works under the > covers, and how a custom VFS should behave when shared cache is > enabled > - can anyone confirm this assumption: > > > > Journal file handles (opened with

[sqlite] UNION with results distinct on a particular column?

2009-03-24 Thread Matthew L. Creech
Hi, I'm hoping someone here can help me out with a query. I have multiple tables, each with the same schema. For example: = Table A: = 1|"xxx" 2|"yyy" 3|"zzz" = = Table B: = 1|"xxx222" 3|"zzz222" 5|"www" = I'd like a SELECT statement that

Re: [sqlite] UNION with results distinct on a particular column?

2009-03-24 Thread David Westbrook
Two possible solutions: A) pure sql ... (warning: untested) Start with all the possible col1 values, and then left join to the other tables, and pick the first col2 found. select col1, coalesce( A.col2, B.col2, C.col2 ) as col2 from ( select distinct col1 from ( select col1 from A

Re: [sqlite] Step Query

2009-03-24 Thread Dennis Cote
vinod1 wrote: > I am new to sqlite and C. > > I have not been able to write a code which would read row by row using > sqlite3_step. > > Could anybody guide me please. > > Hi, This code is equivalent to the very old callback style code shown at http://www.sqlite.org/quickstart.html. It

Re: [sqlite] problems with shared cache?

2009-03-24 Thread John Machin
On 25/03/2009 1:16 AM, Griggs, Donald wrote: > > > -Original Message- > > > On Sat, Mar 21, 2009 at 2:27 AM, Griggs, Donald > wrote: >>> However, when I ask the user to send me their deck, I find that: >>> >>> sqlite> pragma integrity_check;

Re: [sqlite] problems with shared cache?

2009-03-24 Thread Damien Elmes
No, it's a flashcard application. http://ichi2.net/anki/ On Wed, Mar 25, 2009 at 9:30 AM, John Machin wrote: > On 25/03/2009 1:16 AM, Griggs, Donald wrote: >> >> >> -Original Message- >> >> >> On Sat, Mar 21, 2009 at 2:27 AM, Griggs, Donald >>

Re: [sqlite] problems with shared cache?

2009-03-24 Thread Damien Elmes
I can define the primary key column as not null if you think that will help, but dumping the table reveals the ids are being assigned sequential integers. On Tue, Mar 24, 2009 at 11:34 PM, Jim Wilcoxson wrote: > Not sure if it will make a difference, but in your trigger stuff