[sqlite] fts virtual table questions

I didn't get an answer to my earlier question on fts. I guess it's difficult area. Should an fts virtual table always be re-created from scratch when the database is opened by the application before you start using fts commands? I see that the fts tables are not deleted when the database is closed

[sqlite] Can you add rows to fts virtual table?

Some basic questions: I have been creating the fts virtual table at the start of my program like this: CREATE VIRTUAL TABLE ItemFts USING FTS3(ItemId, ItemName, Description); INSERT INTO ItemFts (ItemId, ItemName, Description) SELECT ItemId, ItemName, Description FROM Item"; As rows are added t

[sqlite] Compound primary key problem

This is a mapping table or descriptor table or whatever you want to call it, between 2 tables (about 120,000 rows). I'm finding that operations are very slow (delete, select, etc.) even within transactions. Foreign keys = ON. I tried a different design with an integer primary key (which in this cas

Re: [sqlite] Source code for system.data.sqlite

gt; System.Data.SQLite - probably something along the lines of > http://www.fossil-scm.org/fossil/doc/trunk/www/copyright-release.html > used for Fossil. > > You need to login to the Fossil site, even if only as "Anonymous", to > be able to add a ticket. > > -Shane >

[sqlite] Fwd: Fwd: Fwd: fts virtual table questions

My problem is the term "virtual" I guess. I think of virtual as in-memory only or something. Once they are created in a SQLite database they seem to be as real as the other tables. >> I had an API problem, and I now think that the virtual table does not need >> to be created each time. I can't fi

[sqlite] Source code for system.data.sqlite

Since sqlite has taken on system.data.sqlite for .net you will be seeing issues on this until a forum is set up for it. Please try to make sure the entire source tips are available for download. The last time I checked 1.0.68 (or ?) did not compile due to missing linq related files. Hopefully ther

[sqlite] Fwd: Fwd: fts virtual table questions

this issue. Original Message Subject: Fwd: fts virtual table questions Date: Mon, 28 Feb 2011 22:48:58 -0700 From: Paul Shaffer To: General Discussion of SQLite Database Edit: with doing a create virtual call --> without doing a create virtual call Original Message

[sqlite] Fwd: fts virtual table questions

Edit: with doing a create virtual call --> without doing a create virtual call Original Message Subject: fts virtual table questions Date: Mon, 28 Feb 2011 22:46:32 -0700 From: Paul Shaffer To: General Discussion of SQLite Database I am still testing my results and am new

[sqlite] fts virtual table questions

I am still testing my results and am new to fts. To use fts, is "create virtual table" required every time my program runs and opens the sqlite database? I see that the table (plus a few other related fts tables) is physically present in the database after my program closes. I would prefer to not

Re: [sqlite] Question on the VdbeCursor structure changes

a risk I took, and it works so far. > > Best regards, > Sylvain > > On Sat, Apr 17, 2010 at 8:07 PM, D. Richard Hipp wrote: > >> >> On Apr 17, 2010, at 1:02 PM, Paul Shaffer wrote: >> >> > Due to changes in VdbeCursor structure, this code for 3.6.16

[sqlite] Question on the VdbeCursor structure changes

Due to changes in VdbeCursor structure, this code for 3.6.16 won't compile anymore: else if(pC->pseudoTable) { *prowid = pC->iKey; } and for 3.6.23 would have to be replaced by something like this: else if(pC->pseudoTableReg>0) { //*prowid = } My problem is that after about an hour of

Re: [sqlite] Better example of fk mismatch problem

Thanks. Typo is only in my post edit, not in the actual software. Your edit is correct. Question still stands. > On Sun, 06 Dec 2009 00:05:28 -0700, Paul Shaffer > wrote: > >> I found where I was getting a 'foreign key mismatch' error, but I don't >> know w

[sqlite] Better example of fk mismatch problem

I found where I was getting a 'foreign key mismatch' error, but I don't know why. There are 2 versions of the last table below. They look like they are about the same to me, but one causes the error. The error occurs when I am doing a cascading delete in unrelated tables, and the problem table has

Re: [sqlite] "foreign key mismatch" error

Original Message > On Dec 4, 2009, at 12:31 PM, Paul Shaffer wrote: > >> Below are 3 tables. When I delete a row in Item with related rows in >> Item_attribute I get the dreaded "foreign key mismatch" error. I've >> read >> thr

[sqlite] "foreign key mismatch" error

Below are 3 tables. When I delete a row in Item with related rows in Item_attribute I get the dreaded "foreign key mismatch" error. I've read through the documentation and don't see what I'm doing wrong. sqlite v 1.6.20 CREATE TABLE [Item_attribute] ( "ItemID"integer NOT NULL, "At